Oracle bbed Use

1: Installation: 11g version R2

CD $ORACLE _home/

Find. -name ins_rdbms.mk

CD Rdbms/lib

Make-f ins_rdbms.mk $ORACLE _home/rdbms/lib/bbed

The error will be in 11g. Three files need to be downloaded online. Or you have a 10g library to directly copy the 10g files:

Attached: http://download.csdn.net/detail/jycjyc/4578006

Copy the downloaded BBEDUS.MSB to the top level directory MESG CP LIB/BBEDUS.MSB mesg/

Then execute the make-f ins_rdbms.mk $ORACLE _home/rdbms/lib/bbed

$./bbed

After entering the bbed password is: Blockedit

2: Configuration view:

Then show all to see what to do with:

Find the file to manipulate in another window select * from V$datafile;

So here we can insert a record to see if the file is actually inserted into that : use Dbms_rowid this package

Select Dbms_rowid. ROWID_RELATIVE_FNO (ROWID), Dbms_rowid. Rowid_block_number (ROWID), id from T4;

Locate the data that was actually inserted in number 2nd, Block 121th, next set filename, file, block, blocksize, mode

Set FILENAME '/u01/app/oracle/test/data/test_01.dbf '

Set File 2

Set Block 121

Set BlockSize 8192

Set mode edit//edit can be modified, The browse mode does not allow modification

Find in bbed: find

Bbed> Set block 47//Read Block No. 47th

Bbed>dump//Show Dump

> Show All;

You can see the offset. OFFSET

Find/C with string

>FIND/C BBBBBBB

Find is finding and resetting offsets.

Search by Hex:

> find/x 42424242424242

Sometimes the invalid number is due to the 32-bit error.

Modify Command: MODIFY/C

bbed > Modify/c eeeeeee

Now look at the original data:

SELECT * from T1;

If you now report block corrupted:

That's because of the checksum problem: You can set the checksum off:

Show parameter check;

1)

Change db_block_checksum = false;

alter system set DB_BLOCK_CHECKSUM=FALSE;

Then refresh the next buffer_cache;

alter system flush Buffer_cache;

SELECT * from T1;

2) There is a better way:

Change the checksum directly

bbed> sum apply

Then go back in the refresh times Buffer_cache

Alter system flush Buffer_cache

This article is from the "Technology Life" blog, please be sure to keep this source http://jesnridy.blog.51cto.com/5554751/1439397