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

1: install: 11g R2 version

Cd $ORACLE_HOME/

Find. -name ins_rdbms.mk

Cd rdbms/lib

Make-f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

An error will be reported at 11g. Three files need to be downloaded from the Internet. Or if you have a 10g library, just copy 10g files:

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

Copy the downloaded bbedus.msb to cp lib/bbedus.msb mesg/ in the directory mesg one level up

Execute make-f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed after that

$. / bbed

After entering, the bbed password is: blockedit

2: configure View:

Then show all takes a look at what pre-configurations to do:

In another window, find the file select * from v$datafile that you want to operate.

So here we can insert a record to see if the file is actually inserted there: using the dbms_rowid package

Select dbms_rowid.ROWID_RELATIVE_FNO (rowid), dbms_rowid.ROWID_BLOCK_NUMBER (rowid), id from T4

Find out that the real inserted data is in file 2, block 121. then set filename, file, block, blocksize, mode.

Set FILENAME'/ u01qqappUniqqoracleUniplicateTestUnixDATA Universe TestUniverse 01.dbf'

Set file 2

Set block 121

Set blocksize 8192

Set mode edit / / edit can be modified, but browse mode is not allowed.

Lookup in bbed: find

Bbed > set block 47 / / read Block 47

Bbed > dump / / shows dump

> show all

You can look at the offset. OFFSET

Find / c by string

> find / c BBBBBBB

Find is to find and reset the offset.

Find in hexadecimal:

> find / x 4242424242424242

Sometimes it is because of a 32-bit error to report to invalid number.

Modify command: modify / c

Bbed > modify / c EEEEEEE

At this point, let's look at the previous data:

Select * from T1

If you report to block corrupted now:

Then this is due to the checksum problem: it can be set to turn off the checksum:

Show parameter check

1)

Change db_block_checksum = false

Alter system set db_block_checksum=false

Refresh the buffer_cache again

Alter system flush buffer_cache

Select * from T1

2) there is a better way:

Directly change the checksum

Bbed > sum apply

Then go back and refresh the buffer_cache.

Alter system flush buffer_cache

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.