Shulou(Shulou.com)06/01 Report--

Oracle Block Brower and EDitor Tool (that is, bbed) tool, a tool used to view and modify data file data directly, is an internal tool of Oracle that can directly modify the contents of Oracle data file blocks. To put it simply, it is a binary editing tool for Oracle. The tool is not supported by Oracle, so no executable is generated by default and needs to be recompiled before using it.

Compile and generate bbed tools under oracle 11g

1. Copy the class library required by the tool

These libraries do not exist by default in Oracle 11G and need to be copied from the 10G version.

[oracle@testdb ~] $cp$ORA10G_HOME/rdbms/lib/ssbbded.o $ORACLE_HOME/rdbms/lib

[oracle@testdb ~] $cp$ORA10G_HOME/rdbms/lib/sbbdpt.o $ORACLE_HOME/rdbms/lib

[oracle@testdb] $cp-r $ORA10G_HOME/rdbms/mesg/bbedus.msb$ORACLE_HOME/rdbms/mesg

[oracle@testdb] $cp-r $ORA10G_HOME/rdbms/mesg/bbedus.msg$ORACLE_HOME/rdbms/mesg

Note: the above file permissions must have execution permissions

2. Compile and generate bbed tools

[oracle@testdb ~] $cd$ORACLE_HOME/rdbms/lib

[oracle@testdb lib] $make-f ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

[oracle@testdb lib] $which bbed

/ u01/app/oracle/product/11.2.0/dbhome_1/bin/bbed

[oracle@testdb lib] $bbed

Password: blockedit

BBED uses SQL > set heading off;SQL > set feedback off;SQL > spool / u04/bbedlist.parfSQL > select file# | |'| name | |'| | bytes from v$datafile; 1 / OracleData/testdb/system01.dbf 9437184002 / OracleData/testdb/sysaux01.dbf 7654604803 / OracleData/testdb/undotbs01.dbf 2988441604 / OracleData/testdb/users01.dbf 1087897605 / OracleData/testdb/tbs1.dbf 10485760SQL > spool off

[oracle@testdb ~] $vim / u04/bbed.par-enter the following

Blocksize = 8192 listfile= / u04/bbedlist.parfmode = edit

[oracle@testdb U04] $bbed parfile=/u04/bbed.par password=blockedit

Introduction to common commands

Set sets the current environment.

Show looks at the current environment parameters, similar to sqlplus's command of the same name.

Dump lists the contents of the specified block

Find looks for the specified string in the specified block. The result is that the string and its offset, offset, are displayed. The offset is the number of bytes in the block.

Modify modifies the value of the specified offset of the specified block, which can be modified online.

Copy copy the contents of one block to another block

Verify checks whether there are bad blocks in the current environment

After sum calculates the checksum,modify of block, block is identified as a bad block, currentchecksum is inconsistent with reqired checksum, and the sum command can calculate a new checksum and apply it to the current block.

Undo rolls back the current modification operation. If you make a mistake, undo will ok and return to the original state.

Revert rolls back all previous modifications, which means undoall

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.