下面是来至其它实验中的一部分，关于verify验证块中，报错
欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw
|
BBED> p kdbh struct kdbh, 14 bytes @92 ub1 kdbhflag @92 0x01 (KDBHFFK) sb1 kdbhntab @93 3 sb2 kdbhnrow @94 187 sb2 kdbhfrre @96 -1 sb2 kdbhfsbo @98 400 sb2 kdbhfseo @100 401 sb2 kdbhavsp @102 1 sb2 kdbhtosp @104 1
BBED> set offset 96 OFFSET 96
就是存放106号的行偏移量的位置，这里将kdbhfrre更改为106的位置，代表中第一行包含空闲行的位置
BBED> modify /x 6a00 File: /tmp/system01.dbf (0) Block: 3008 Offsets: 96 to 607 Dba:0x00000000 ———————————————————————— 6a009001 91010100 01000000 1a001a00 50006a00 5100891f 1f1e5a1d ed1c801c BBED> p kdbh struct kdbh, 14 bytes @92 ub1 kdbhflag @92 0x01 (KDBHFFK) sb1 kdbhntab @93 3 sb2 kdbhnrow @94 187 sb2 kdbhfrre @96 106 sb2 kdbhfsbo @98 400 sb2 kdbhfseo @100 401 sb2 kdbhavsp @102 1 sb2 kdbhtosp @104 1
BBED> sum apply Check value for File 0, Block 3008: current = 0x7d84, required = 0x7d84
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
Block Checking: DBA = 4197312, Block Type = KTB-managed data block data header at 0x2a98c8825c kdbchk: entries on the free list are not ordered next=51 nrow=187 chas=106 Block 3008 failed with check code 6106 这里我们又可以看到触发了6106的错误，next=51这里其实就是指kdbr[106]这行记录的开始位置，这里我们将106指定107，代表106这行是已经被标识为删除了。Chas=106，这个应该是代表kdbr[106]这一行有问题。 DBVERIFY – Verification complete
Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdbr[107] sb2 kdbr[107] @332 215
BBED> x /r kdbr[107] kdbr[107] @332 ——— flag@332: 0xd7 (KDRHFN, KDRHFP, KDRHFL, KDRHFD, KDRHFC, KDRHFK) lock@333: 0x00 cols@334: 0
BBED> x /r kdbr[108] kdbr[108] @334 ——— flag@334: 0x7e (KDRHFP, KDRHFL, KDRHFF, KDRHFD, KDRHFH, KDRHFC) lock@335: 0x00 cols@336: 0 ckix@337: 30
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
Block Checking: DBA = 4197312, Block Type = KTB-managed data block data header at 0x2a98c8825c kdbchk: entries on the free list are not ordered next=51 nrow=187 chas=106 Block 3008 failed with check code 6106 DBVERIFY – Verification complete 这里又触发了6106的错误 Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> set offset 330 OFFSET 330
BBED> modify /x 6b00 File: /tmp/system01.dbf (0) Block: 3008 Offsets: 330 to 841 Dba:0x00000000 ———————————————————————— 6b00d700 7e000e1e b71d491d dc1c6f1c 151ca51b 4b1bdb1a 851a141a a7194c19
BBED> p kdbr[106] sb2 kdbr[106] @330 107
BBED> sum apply Check value for File 0, Block 3008: current = 0x7ddc, required = 0x7ddc
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
Block Checking: DBA = 4197312, Block Type = KTB-managed data block data header at 0x2a98c8825c kdbchk: entries on the free list are not ordered next=215 nrow=187 chas=107 Block 3008 failed with check code 6106
BBED> set offset 332 OFFSET 332
BBED> modify /x 6c00 File: /tmp/system01.dbf (0) Block: 3008 Offsets: 332 to 843 Dba:0x00000000 ———————————————————————— 6c007e00 0e1eb71d 491ddc1c 6f1c151c a51b4b1b db1a851a 141aa719 4c19f518
BBED> sum apply Check value for File 0, Block 3008: current = 0x7d67, required = 0x7d67
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
Block Checking: DBA = 4197312, Block Type = KTB-managed data block data header at 0x2a98c8825c kdbchk: entries on the free list are not ordered next=6016 nrow=187 chas=126 Block 3008 failed with check code 6106
BBED> p kdbr[107] sb2 kdbr[107] @332 108
BBED> p kdbr[108] sb2 kdbr[108] @334 126
BBED> set offset 334 OFFSET 334
BBED> modify /x ffff File: /tmp/system01.dbf (0) Block: 3008 Offsets: 334 to 845 Dba:0x00000000 ———————————————————————— ffff0e1e b71d491d dc1c6f1c 151ca51b 4b1bdb1a 851a141a a7194c19 f5189f18 这里的FFFF代表的就是结束的意思 BBED> sum apply Check value for File 0, Block 3008: current = 0x82e6, required = 0x82e6
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
Block Checking: DBA = 4197312, Block Type = KTB-managed data block data header at 0x2a98cab25c kdbchk: the amount of space used is not equal to block size used=8044 fsc=0 avsp=1 dtl=8096 Block 3008 failed with check code 6110
DBVERIFY – Verification complete
Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 1 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED
BBED> p kdbh struct kdbh, 14 bytes @92 ub1 kdbhflag @92 0x01 (KDBHFFK) sb1 kdbhntab @93 3 sb2 kdbhnrow @94 187 sb2 kdbhfrre @96 106 sb2 kdbhfsbo @98 400 sb2 kdbhfseo @100 401 sb2 kdbhavsp @102 1 sb2 kdbhtosp @104 1
BBED> set offset 102 OFFSET 102
BBED> set offset 102 OFFSET 102
BBED> modify /x 3400 File: /tmp/system01.dbf (0) Block: 3008 Offsets: 102 to 613 Dba:0x00000000 ———————————————————————— 34000d48 00001a00 1a005000 6a005100 891f1f1e 5a1ded1c 801cb61b ec1a251a b8199317 2717ba16 4d168915 11144813 83126711 f910df0f be0e910c c70b3009
BBED> modify /x 3400 File: /tmp/system01.dbf (0) Block: 3008 Offsets: 104 to 615 Dba:0x00000000 ———————————————————————— 34000000 1a001a00 50006a00 5100891f 1f1e5a1d ed1c801c b61bec1a 251ab819 93172717 ba164d16 89151114 48138312 6711f910 df0fbe0e 910cc70b 3009a106
BBED> sum apply Check value for File 0, Block 3008: current = 0x82e6, required = 0x82e6
BBED> verify DBVERIFY – Verification starting FILE = /tmp/system01.dbf BLOCK = 3008
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 Message 531 not found; product=RDBMS; facility=BBED
|
常见坏块分类，dbv报错代码：6106：等您坐沙发呢！