Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about bbed utility

Sami A.Oct 23 2014 — edited Oct 23 2014

I am trying out this hidden utility  and i can recover deleted rows and modify data blocks,  but i am not understanding how the recover block option is working .

In Graham Thornton guide page 31 it says quote "

The sequence number also  comprises one component of the tailcheck of the block, which occupies the last 8 bytes. This also needs to be reset for Oracle to recognize the block as valid again.

Using bbed we can print the tail check and see that is 0x000006ff , However when we reset it we must remember that this value is interpreted as a single unsigned integer. On Intel machines therefore, the value is stored low-order  byte first.

BBED> p tailchk

ub4     tailchk                                         @8188            0x000006ff

BBED> moidfy /x  0106000    dba 7,16   offset   8188

"

my question is :  why/how the value of 0106000 is being used as the modificaion value?

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2014
Added on Oct 23 2014
2 comments
547 views