一.对数据文件检查
注意：应该在关闭数据库模式下进行bbed的操作
[oracle@ora10 controlfile]$ dbv file=/u01/app/oracle/oradata/ORCL/datafile/test_01.dbf blocksize=8192DBVERIFY: Release 10.2.0.1.0 - Production on Fri Jan 16 23:05:01 2015Copyright (c) 1982, 2005, Oracle. All rights reserved.DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/ORCL/datafile/test_01.dbfBlock Checking: DBA = 20974772, Block Type = KTB-managed data blockdata header at 0xb7ee3264kdbchk: the amount of space used is not equal to block size used=3681 fsc=7 avsp=4407 dtl=8088Page 3252 failed with check code 6110DBVERIFY - Verification completeTotal Pages Examined : 12800Total Pages Processed (Data) : 3204Total Pages Failing (Data) : 1Total Pages Processed (Index): 0Total Pages Failing (Index): 0Total Pages Processed (Other): 68Total Pages Processed (Seg) : 0Total Pages Failing (Seg) : 0Total Pages Empty : 9528Total Pages Marked Corrupt : 0Total Pages Influx : 0Highest block SCN : 434362 (0.434362)[oracle@ora10 controlfile]$
文件test_01.dbf的3252块 出现问题
二.查找资料
dbsnake的建议，将所有itl的fsc全部改为0，然后将kdbh.kdbhavsp和kdbh.kdbhtosp的值改成相等。它们的值都等于dbv校验中显示的dtl－used=8088-3681=4407。
三.利用bbed修复
BBED> set dba 5,3252 DBA 0x01400cb4 (20974772 5,3252)BBED> verifyDBVERIFY - Verification startingFILE = /u01/app/oracle/oradata/ORCL/datafile/test_01.dbfBLOCK = 3252Block Checking: DBA = 20974772, Block Type = KTB-managed data blockdata header at 0xb7e7b264kdbchk: the amount of space used is not equal to block size used=3681 fsc=7 avsp=4407 dtl=8088Block 3252 failed with check code 6110DBVERIFY - Verification completeTotal Blocks Examined : 1Total Blocks Processed (Data) : 1Total Blocks Failing (Data) : 1Total Blocks Processed (Index): 0Total Blocks Failing (Index): 0Total Blocks Empty : 0Total Blocks Marked Corrupt : 0Total Blocks Influx : 0BBED> print kdbh struct kdbh, 14 bytes @100 ub1 kdbhflag @100 0x00 (NONE) b1 kdbhntab @101 1 b2 kdbhnrow @102 333 sb2 kdbhfrre @104 -1 sb2 kdbhfsbo @106 684 sb2 kdbhfseo @108 5423 b2 kdbhavsp @110 4407 b2 kdbhtosp @112 4416BBED>
3.1 查看itl中的fsc
BBED> p ktbbhitlstruct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0004 ub2 kxidslt @46 0x001e ub4 kxidsqn @48 0x000000eb struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00803a71 ub2 kubaseq @56 0x005f ub1 kubarec @58 0x30 ub2 ktbitflg @60 0x2001 (KTBFUPB) union _ktbitun, 2 bytes @62 b2 _ktbitfsc @62 7 ub2 _ktbitwrp @62 0x0007 ub4 ktbitbas @64 0x0006a0bastruct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x0002 ub2 kxidslt @70 0x0022 ub4 kxidsqn @72 0x000000f8 struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x008090ac ub2 kubaseq @80 0x0085 ub1 kubarec @82 0x1f ub2 ktbitflg @84 0x8000 (KTBFCOM) union _ktbitun, 2 bytes @86 b2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x000600bcBBED>
修改 b2 _ktbitfsc 的值使其为0.
BBED> dump /v dba 5,3252 offset 62 count 32 File: /u01/app/oracle/oradata/ORCL/datafile/test_01.dbf (5) Block: 3252 Offsets: 62 to 93 Dba:0x01400cb4------------------------------------------------------- 0700baa0 06000200 2200f800 0000ac90 l ..籂...."... 80008500 1f000080 0000bc00 06000000 l .............. <16 bytes per line> BBED> modify /x 00 dba 5,3252 offset 62Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y File: /u01/app/oracle/oradata/ORCL/datafile/test_01.dbf (5) Block: 3252 Offsets: 62 to 93 Dba:0x01400cb4------------------------------------------------------------------------ 0000baa0 06000200 2200f800 0000ac90 80008500 1f000080 0000bc00 06000000 <32 bytes per line>BBED> BBED> print ktbbhitlstruct ktbbhitl[0], 24 bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0004 ub2 kxidslt @46 0x001e ub4 kxidsqn @48 0x000000eb struct ktbituba, 8 bytes @52 ub4 kubadba @52 0x00803a71 ub2 kubaseq @56 0x005f ub1 kubarec @58 0x30 ub2 ktbitflg @60 0x2001 (KTBFUPB) union _ktbitun, 2 bytes @62 b2 _ktbitfsc @62 0 ub2 _ktbitwrp @62 0x0000 ub4 ktbitbas @64 0x0006a0bastruct ktbbhitl[1], 24 bytes @68 struct ktbitxid, 8 bytes @68 ub2 kxidusn @68 0x0002 ub2 kxidslt @70 0x0022 ub4 kxidsqn @72 0x000000f8 struct ktbituba, 8 bytes @76 ub4 kubadba @76 0x008090ac ub2 kubaseq @80 0x0085 ub1 kubarec @82 0x1f ub2 ktbitflg @84 0x8000 (KTBFCOM) union _ktbitun, 2 bytes @86 b2 _ktbitfsc @86 0 ub2 _ktbitwrp @86 0x0000 ub4 ktbitbas @88 0x000600bcBBED> sumCheck value for File 5, Block 3252:current = 0x0e90, required = 0x0e97BBED> sum applyCheck value for File 5, Block 3252:current = 0x0e97, required = 0x0e97BBED>
3.2 修改kdbh.kdbhavsp和kdbh.kdbhtosp的值=8088-3681=4407
BBED> print kdbhstruct kdbh, 14 bytes @100 ub1 kdbhflag @100 0x00 (NONE) b1 kdbhntab @101 1 b2 kdbhnrow @102 333 sb2 kdbhfrre @104 -1 sb2 kdbhfsbo @106 684 sb2 kdbhfseo @108 5423 b2 kdbhavsp @110 4407 b2 kdbhtosp @112 4416BBED> dump /v dba 5,3252 offset 112 count 32 File: /u01/app/oracle/oradata/ORCL/datafile/test_01.dbf (5) Block: 3252 Offsets: 112 to 143 Dba:0x01400cb4------------------------------------------------------- 40110000 4d01b01d b81dc01d c81dd01d l @...M. d81de01d e81df01d f81d001e 081e101e l ...... <16 bytes per line>BBED>--4416的16进制1140 转储后为 4011 BBED> dump /v dba 5,3252 offset 110 count 32 File: /u01/app/oracle/oradata/ORCL/datafile/test_01.dbf (5) Block: 3252 Offsets: 110 to 141 Dba:0x01400cb4------------------------------------------------------- 37114011 00004d01 b01db81d c01dc81d l 7.@...M. d01dd81d e01de81d f01df81d 001e081e l .... <16 bytes per line>BBED> --4407的16进制1137 转储后为3711--修改值BBED> modify /x 3711 dba 5,3252 offset 112 File: /u01/app/oracle/oradata/ORCL/datafile/test_01.dbf (5) Block: 3252 Offsets: 112 to 143 Dba:0x01400cb4------------------------------------------------------------------------ 37110000 4d01b01d b81dc01d c81dd01d d81de01d e81df01d f81d001e 081e101e <32 bytes per line>BBED> --应用BBED> sum applyCheck value for File 5, Block 3252:current = 0x0ee0, required = 0x0ee0BBED> verifyDBVERIFY - Verification startingFILE = /u01/app/oracle/oradata/ORCL/datafile/test_01.dbfBLOCK = 3252DBVERIFY - Verification completeTotal Blocks Examined : 1Total Blocks Processed (Data) : 1Total Blocks Failing (Data) : 0Total Blocks Processed (Index): 0Total Blocks Failing (Index): 0Total Blocks Empty : 0Total Blocks Marked Corrupt : 0Total Blocks Influx : 0
--利用dbv检查
[oracle@ora10 controlfile]$ dbv file=/u01/app/oracle/oradata/ORCL/datafile/test_01.dbf blocksize=8192DBVERIFY: Release 10.2.0.1.0 - Production on Fri Jan 16 23:40:02 2015Copyright (c) 1982, 2005, Oracle. All rights reserved.DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/ORCL/datafile/test_01.dbfDBVERIFY - Verification completeTotal Pages Examined : 12800Total Pages Processed (Data) : 3204Total Pages Failing (Data) : 0Total Pages Processed (Index): 0Total Pages Failing (Index): 0Total Pages Processed (Other): 68Total Pages Processed (Seg) : 0Total Pages Failing (Seg) : 0Total Pages Empty : 9528Total Pages Marked Corrupt : 0Total Pages Influx : 0Highest block SCN : 434362 (0.434362)[oracle@ora10 controlfile]$