I. Checking the data files
Note: The bbed operation should be performed in the Shutdown database mode
[[email protected] controlfile]$ DBV file=/u01/app/oracle/oradata/orcl/datafile/test_01.dbf blocksize= 8192dbverify:release 10.2.0.1.0-production on Fri Jan 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 are 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 (S eg): 0Total pages empty:9528total pages Marked corrupt:0total pages influx:0highest block S cn:434362 (0.434362)[[email protected] controlfile]$
Problem with 3252 blocks of file test_01.dbf
Two. Find information
Dbsnake's recommendation is to change all ITL's FSC to 0 and then change the value of KDBH.KDBHAVSP and Kdbh.kdbhtosp to equal. Their values are equal to the dtl-used=8088-3681=4407 shown in the DBV checksum.
Three. Repair with bbed
Bbed> Set DBA 5,3252 dba 0X01400CB4 (20974772 5,3252) bbed> Verifydbverify-verification starting FILE =/u01/app/oracle/oradata/orcl/datafile/test_01.dbfblock = 3252Block checking:dba = 20974772, Block Type = Ktb-manag Ed data Blockdata header at 0xb7e7b264kdbchk:the amount of space used was not equal to block size used=3681 fsc=7 a vsp=4407 Dtl=8088block 3252 failed with check code 6110dbverify-verification completetotal Blocks examined:1to Tal Blocks processed (data): 1Total Blocks Failing (data): 1Total Blocks processed (Index): 0Total Blocks Failing (I Ndex): 0Total Blocks empty:0total Blocks Marked corrupt:0total Blocks influx:0bbed> Print kdbh struct KDBH, bytes @100 ub1 kdbhflag @100 0x00 (NONE ) B1 kdbhntab @101 1 b2 kdbhnrow @102 333 SB2 KD Bhfrre @104-1 sb2 kdbhfsbo @106 684 SB2 Kdbhfseo @108 5423 B2 kdbhavsp @110 4407 B2 kdbhtosp @112 4416bbed>
3.1 Viewing the FSC in ITL
Bbed> p ktbbhitlstruct ktbbhitl[0], bytes @44 struct ktbitxid, 8 bytes @44 UB2 kxidusn @44 0x0004 ub2 kxidslt @46 0x001 E 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 (KTBF UPB) Union _ktbitun, 2 bytes @62 B2 _KTBITFSC @62 7 ub2 _KTBITWRP @62 0x0007 ub4 ktbitbas @64 0x0006a0bastruct k Tbbhitl[1], 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 0 X008090AC 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>
Modify the value of B2 _KTBITFSC to 0.
bbed> dump/v dba 5,3252 Offset, Count of File:/U01/APP/ORACLE/ORADATA/ORCL/DATAFILE/TEST_01.DBF (5) block:3252 offsets:62 to DBA:0X01400CB4-------------------------------------------------------0700baa0 06000200 2200f80 0 0000ac90 L.. 籂 ..... 80008500 1f000080 0000bc00 06000000 l ..... .....< -bytes per line>bbed> modify/x xx dba 5,3252 offset 62warning:contents of previous bifile would 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< +bytes per line>bbed> bbed> print ktbbhitlstruct ktbbhitl[0], bytes @44 struct ktbitxid, 8 bytes @44 ub2 kxidusn @44 0x0004 ub2 kxidslt @4 6 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 0x000 6a0bastruct ktbbhitl[1], bytes @68 struct ktbitxid, 8 bytes @68 UB2 k Xidusn @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 = 0x0e 97bbed>
3.2 Modifying the values of KDBH.KDBHAVSP and Kdbh.kdbhtosp =8088-3681=4407
bbed> print kdbhstruct kdbh, bytes @100 ub1 kdbhflag @1 (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 k Dbhtosp @112 4416bbed> dump/v dba 5,3252 Offset, Count of File:/u01/app/oracle/o RADATA/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 ...< -bytes per line>bbed>--4416 16 binary 1140 dumps for 4011 bbed> dump/v dba 5,3252 offset + count File:/u01/app/oracle/oradata/orcl/d ATAFILE/TEST_01.DBF (5) block:3252 offsets:110 to 141 dba:0x01400cb4---------------------------------------------- ---------37114011 00004d01 b01db81d c01dc81d l [email protected] d01dd81d e01de81d f01df81d 001e081e l ....< -bytes per line>bbed>--4407 16 binary 1137 dumps for 3711--modified values bbed> modify/x 3711 dba 5,3252 offset by File:/U01/APP/ORACLE/ORADATA/ORC L/DATAFILE/TEST_01.DBF (5) block:3252 offsets:112 to 143 dba:0x01400cb4------------------------- -----------------------------------------------37110000 4d01b01d b81dc01d c81dd01d d81de01d e81df01d f81d001e 081e101e< +bytes per line>bbed>--Apply bbed> sum Applycheck value for File 5, Block 3252:current = 0x0ee0, required = 0x0ee0bbed> Verifydb Verify-verification startingfile =/u01/app/oracle/oradata/orcl/datafile/test_01.dbfblock = 3252DBVERIFY- Verification completetotal Blocks Examined:1total Blocks processed (data): 1Total Blocks Failing (data): 0To Tal Blocks processed (index): 0Total Blocks Failing (index): 0Total Blocks empty:0total Blocks Marked corru Pt:0total Blocks influx:0
--Using DBV inspection
[Email protected] controlfile]$ DBV file=/u01/app/oracle/oradata/orcl/datafile/test_01.dbf blocksize= 8192dbverify:release 10.2.0.1.0-production on Fri Jan 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 P Rocessed (Index): 0Total pages failing (index): 0Total pages processed (other): 68Total pages processed (SEG) : 0T Otal Pages failing (Seg) : 0Total pages Empty : 9528Total pages Marked corrupt : 0Total Pages influx
: 0Highest block SCN : 434362 (0.434362) [[email protected] controlfile]$
Kdbchk:the amount of space used is not equal to block size