b2 _ktbitfsc @86 3

ub2 _ktbitwrp @86 0x0003

ub4 ktbitbas @88 0x0007a3d5?

BBED> m /x 00 offset 86

File: /u01/app/oracle/oradata/ORCL/system01.dbf (1)

Block: 60290 Offsets: 86 to 149 Dba:0x0040eb82

------------------------------------------------------------------------

0000d5a3 07000001 0200ffff 1600801f 741f771f 00000200 931f8a1f 02000000

02000200 791f321f 831e481e 00000000 00000000 00000000 00000000 00000000?

<32 bytes per line>?

BBED> sum apply

Check value for File 1, Block 60290:

current = 0x3c21, required = 0x3c21?

BBED> p kdbh

struct kdbh, 14 bytes @92

ub1 kdbhflag @92 0x00 (NONE)

b1 kdbhntab @93 1

b2 kdbhnrow @94 2

sb2 kdbhfrre @96 -1

sb2 kdbhfsbo @98 22

sb2 kdbhfseo @100 8064

b2 kdbhavsp @102 8052

b2 kdbhtosp @104 8055?

BBED> m /x 741f offset 102

File: /u01/app/oracle/oradata/ORCL/system01.dbf (1)

Block: 60290 Offsets: 102 to 165 Dba:0x0040eb82

------------------------------------------------------------------------

741f771f 00000200 931f8a1f 02000000 02000200 791f321f 831e481e 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000?

<32 bytes per line>?

BBED> m /x 741f offset 104

File: /u01/app/oracle/oradata/ORCL/system01.dbf (1)

Block: 60290 Offsets: 104 to 167 Dba:0x0040eb82

------------------------------------------------------------------------

741f0000 0200931f 8a1f0200 00000200 0200791f 321f831e 481e0000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>?

BBED> sum apply

Check value for File 1, Block 60290:

current = 0x3c22, required = 0x3c22?

BBED> verify

DBVERIFY - Verification starting

FILE = /u01/app/oracle/oradata/ORCL/system01.dbf

BLOCK = 60290?

DBVERIFY - Verification complete?

Total Blocks Examined : 1

Total Blocks Processed (Data) : 1

Total Blocks Failing (Data) : 0

Total Blocks Processed (Index): 0

Total Blocks Failing (Index): 0

Total Blocks Empty : 0

Total Blocks Marked Corrupt : 0

Total Blocks Influx : 0

此时数据块验证通过?

现在回到库里进行验证：

SYS@ORCL>alter system flush buffer_cache;?

System altered.?

SYS@ORCL>select * from bbed_test;?

X Y

---------- --------------------

1 BADLY9

2 JP?

可以看到UPDATE之前的数据已经被恢复回来了。?

实验过程参考飞总的文章：

http;//www.xifenfei.com/3704.html