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
再次验证，已经没有报错了。
常见坏块分类，dbv报错代码：6110：等您坐沙发呢！