故障分析：常见坏块分类，dbv报错代码：6106

我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！
由于博客中有大量代码，通过页面浏览效果更佳。

故障分析：常见坏块分类，dbv报错代码：6106

下面是来至其它实验中的一部分，关于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

------------------作者介绍-----------------------
姓名：黄廷忠
现就职：Oracle中国高级服务团队
曾就职：OceanBase、云和恩墨、东方龙马等
电话、微信、QQ：18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)