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

Source: Internet
Author: User
Tags dba

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.