sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle数据库dbv检查坏块时报错代码:6106解决办法

时间:2016-10-24 21:02   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:分享一篇关于Oracle数据库在使用verify验证块中,报错6106的解决办法。

在verify验证块中,报错


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 offsetOracleoracleplus.net 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

本文固定链接: http://www.htz.pw/2014/06/26/%e5%b8%b8%e8%a7%81%e5%9d%8f%e5%9d%97%e5%88%86%e7%b1%bb%ef%bc%8cdbv%e6%8a%a5%e9%94%99%e4%bb%a3%e7%a0%81%ef%bc%9a6106.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle数据库dbv检查坏块时报错代码:6106解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1058.html

Oracle研究中心

关键词:

常见坏块分类dbv报错代码:6106

数据库报file I/O错

用dbv检查文件也报错