当前位置: 首页 > BBED > 正文

常见坏块分类,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

 

本文固定链接: 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 | 认真就输

该日志由 huangtingzhong 于2014年06月26日发表在 BBED 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: 常见坏块分类,dbv报错代码:6106 | 认真就输
关键字: