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

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

BBED> verify

DBVERIFY – Verification starting

FILE = /oracle/app/oracle/oradata/orcl1024/users01.dbf

BLOCK = 68

 

Block Checking: DBA = 16777284, Block Type = KTB-managed data block

data header at 0x2a9769627c

kdbchk: the amount of space used is not equal to block size

        used=1327 fsc=80 avsp=6737 dtl=8064

Block 68 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

 

这里验证的时候,报avsp空间的 问题,avsp=dtl-used的空间

 

将所有itl的fsc全部改为0,然后将kdbh.kdbhavsp和kdbh.kdbhtosp的值改成相等,它们的值都等于dbv校验中显示的dtl-used

 

SQL> select 8064-1327 from dual;

 

 8064-1327

———-

      6737

 

SQL> select to_char(6737,’xxxxxxxx’) from dual;

 

TO_CHAR(6

———

     1a51

    

    

BBED> assign offset 136=offset 134;

b2 kdbhtosp                                 @136      6737

 

BBED> p kdbh

struct kdbh, 14 bytes                       @124    

   ub1 kdbhflag                             @124      0x00 (NONE)

   b1 kdbhntab                              @125      1

   b2 kdbhnrow                              @126      16

   sb2 kdbhfrre                             @128     -1

   sb2 kdbhfsbo                             @130      50

   sb2 kdbhfseo                             @132      6787

   b2 kdbhavsp                              @134      6737

   b2 kdbhtosp                              @136      6737

 

BBED> verify

DBVERIFY – Verification starting

FILE = /oracle/app/oracle/oradata/orcl1024/users01.dbf

BLOCK = 68

 

Block Checking: DBA = 16777284, Block Type = KTB-managed data block

data header at 0x2a9769627c

kdbchk: the amount of space used is not equal to block size

        used=1327 fsc=80 avsp=6737 dtl=8064

Block 68 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

再次验证,这里还是报错,报错的原因是因为fsc=80的原因,这里我们将fsc的值清空

BBED> p kdbh

struct kdbh, 14 bytes                       @124    

   ub1 kdbhflag                             @124      0x00 (NONE)

   b1 kdbhntab                              @125      1

   b2 kdbhnrow                              @126      16

   sb2 kdbhfrre                             @128     -1

   sb2 kdbhfsbo                             @130      50

   sb2 kdbhfseo                             @132      6787

   b2 kdbhavsp                              @134      6737

   b2 kdbhtosp                              @136      6737

 

这里还是报错了

 

BBED> p ktbbh

struct ktbbh, 96 bytes                      @20     

   ub1 ktbbhtyp                             @20       0x01 (KDDBTDATA)

   union ktbbhsid, 4 bytes                  @24     

      ub4 ktbbhsg1                          @24       0x0000caec

      ub4 ktbbhod1                          @24       0x0000caec

   struct ktbbhcsc, 8 bytes                 @28     

      ub4 kscnbas                           @28       0x4008482e

      ub2 kscnwrp                           @32       0x09c7

   b2 ktbbhict                              @36       3

   ub1 ktbbhflg                             @38       0x32 (NONE)

   ub1 ktbbhfsl                             @39       0x00

   ub4 ktbbhfnx                             @40       0x01000041

   struct ktbbhitl[0], 24 bytes             @44     

      struct ktbitxid, 8 bytes              @44     

         ub2 kxidusn                        @44       0xffff

         ub2 kxidslt                        @46       0x0000

         ub4 kxidsqn                        @48       0x00000000

      struct ktbituba, 8 bytes              @52     

         ub4 kubadba                        @52       0x00000000

         ub2 kubaseq                        @56       0x0000

         ub1 kubarec                        @58       0x00

      ub2 ktbitflg                          @60       0x8000 (KTBFCOM)

      union _ktbitun, 2 bytes               @62     

         b2 _ktbitfsc                       @62       2503

         ub2 _ktbitwrp                      @62       0x09c7

      ub4 ktbitbas                          @64       0x4008482e

   struct ktbbhitl[1], 24 bytes             @68     

      struct ktbitxid, 8 bytes              @68     

         ub2 kxidusn                        @68       0x000e

         ub2 kxidslt                        @70       0x001c

         ub4 kxidsqn                        @72       0x00000010

      struct ktbituba, 8 bytes              @76     

         ub4 kubadba                        @76       0x00800d9a

         ub2 kubaseq                        @80       0x0014

         ub1 kubarec                        @82       0x34

      ub2 ktbitflg                          @84       0x2001 (KTBFUPB)

      union _ktbitun, 2 bytes               @86     

         b2 _ktbitfsc                       @86       80

         ub2 _ktbitwrp                      @86       0x0050

      ub4 ktbitbas                          @88       0x40084883

   struct ktbbhitl[2], 24 bytes             @92     

      struct ktbitxid, 8 bytes              @92     

         ub2 kxidusn                        @92       0x0000

         ub2 kxidslt                        @94       0x0000

         ub4 kxidsqn                        @96       0x00000000

      struct ktbituba, 8 bytes              @100    

         ub4 kubadba                        @100      0x00000000

         ub2 kubaseq                        @104      0x0000

         ub1 kubarec                        @106      0x00

      ub2 ktbitflg                          @108      0x0000 (NONE)

      union _ktbitun, 2 bytes               @110    

         b2 _ktbitfsc                       @110      0

         ub2 _ktbitwrp                      @110      0x0000

      ub4 ktbitbas                          @112      0x00000000

 

BBED> modify /x 00 offset 86

 File: /oracle/app/oracle/oradata/orcl1024/users01.dbf (0)

 Block: 68               Offsets:   86 to  105           Dba:0x00000000

————————————————————————

 00008348 08400000 00000000 00000000 00000000

 

 <32 bytes per line>

 

BBED> p ktbbh

struct ktbbh, 96 bytes                      @20     

   ub1 ktbbhtyp                             @20       0x01 (KDDBTDATA)

   union ktbbhsid, 4 bytes                  @24     

      ub4 ktbbhsg1                          @24       0x0000caec

      ub4 ktbbhod1                          @24       0x0000caec

   struct ktbbhcsc, 8 bytes                 @28     

      ub4 kscnbas                           @28       0x4008482e

      ub2 kscnwrp                           @32       0x09c7

   b2 ktbbhict                              @36       3

   ub1 ktbbhflg                             @38       0x32 (NONE)

   ub1 ktbbhfsl                             @39       0x00

   ub4 ktbbhfnx                             @40       0x01000041

   struct ktbbhitl[0], 24 bytes             @44     

      struct ktbitxid, 8 bytes              @44     

         ub2 kxidusn                        @44       0xffff

         ub2 kxidslt                        @46       0x0000

         ub4 kxidsqn                        @48       0x00000000

      struct ktbituba, 8 bytes              @52     

         ub4 kubadba                        @52       0x00000000

         ub2 kubaseq                        @56       0x0000

         ub1 kubarec                        @58       0x00

      ub2 ktbitflg                          @60       0x8000 (KTBFCOM)

      union _ktbitun, 2 bytes               @62     

         b2 _ktbitfsc                       @62       2503

         ub2 _ktbitwrp                      @62       0x09c7

      ub4 ktbitbas                          @64       0x4008482e

   struct ktbbhitl[1], 24 bytes             @68     

      struct ktbitxid, 8 bytes              @68     

         ub2 kxidusn                        @68       0x000e

         ub2 kxidslt                        @70       0x001c

         ub4 kxidsqn                        @72       0x00000010

      struct ktbituba, 8 bytes              @76     

         ub4 kubadba                        @76       0x00800d9a

         ub2 kubaseq                        @80       0x0014

         ub1 kubarec                        @82       0x34

      ub2 ktbitflg                          @84       0x2001 (KTBFUPB)

      union _ktbitun, 2 bytes               @86     

         b2 _ktbitfsc                       @86       0

         ub2 _ktbitwrp                      @86       0x0000

      ub4 ktbitbas                          @88       0x40084883

   struct ktbbhitl[2], 24 bytes             @92     

      struct ktbitxid, 8 bytes              @92     

         ub2 kxidusn                        @92       0x0000

         ub2 kxidslt                        @94       0x0000

         ub4 kxidsqn                        @96       0x00000000

      struct ktbituba, 8 bytes              @100    

         ub4 kubadba                        @100      0x00000000

         ub2 kubaseq                        @104      0x0000

         ub1 kubarec                        @106      0x00

      ub2 ktbitflg                          @108      0x0000 (NONE)

      union _ktbitun, 2 bytes               @110    

         b2 _ktbitfsc                       @110      0

         ub2 _ktbitwrp                      @110      0x0000

      ub4 ktbitbas                          @112      0x00000000

 

BBED> sum apply

Check value for File 0, Block 68:

current = 0x29fc, required = 0x29fc

 

BBED> verify

DBVERIFY – Verification starting

FILE = /oracle/app/oracle/oradata/orcl1024/users01.dbf

BLOCK = 68

 

 

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

 

再次验证,已经没有报错了。

本文固定链接: http://www.htz.pw/2014/07/06/%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%9a6110.html | 认真就输

该日志由 huangtingzhong 于2014年07月06日发表在 BBED 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: 常见坏块分类,dbv报错代码:6110 | 认真就输
关键字: , , , ,