code 6101 和 code 6111的解决办法

<<<< code 6101 和 code 6111的解决办法
<<<<
<<<< kdbchk: row locked by non-existent transaction
<<<<         table=0   slot=0
<<<<         lockid=2   ktbbhitc=2
<<<< Block 96081 failed with check code 6101
<<<<
<<<< kdbchk: space available on commit is incorrect
<<<<         tosp=8030 fsc=0 stb=2 avsp=8030
<<<< Block 96081 failed with check code 6111

 

 

BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/ora11g/system01.dbf
BLOCK = 96081

Block Checking: DBA = 4290385, Block Type = KTB-managed data block
data header at 0x1c5145c
kdbchk: row locked by non-existent transaction
        table=0   slot=0
        lockid=2   ktbbhitc=2
Block 96081 failed with check code 6101

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
Message 531 not found;  product=RDBMS; facility=BBED


BBED> x /rnnnnnc
rowdata[24]                                 @8182    
-----------
flag@8182: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8183: 0x02                                     <<<< lock置为0.
cols@8184:    1

col    0[2] @8185: 1 


BBED> modify /x 00 offset 8183
 File: /u01/app/oracle/oradata/ora11g/system01.dbf (1)
 Block: 96081            Offsets: 8183 to 8191           Dba:0x00417751
------------------------------------------------------------------------
 000102c1 02020699 5a 

 <32 bytes per line>

BBED> sum apply
Check value for File 1, Block 96081:
current = 0x09c9, required = 0x09c9

BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/ora11g/system01.dbf
BLOCK = 96081

Block Checking: DBA = 4290385, Block Type = KTB-managed data block
data header at 0x1c7345c
kdbchk: the amount of space used is not equal to block size
        used=66 fsc=0 avsp=8023 dtl=8096
Block 96081 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
Message 531 not found;  product=RDBMS; facility=BBED







BBED> verify
DBVERIFY - Verification starting
FILE = /u01/app/oracle/oradata/ora11g/system01.dbf
BLOCK = 96081

Block Checking: DBA = 4290385, Block Type = KTB-managed data block
data header at 0x1f4b05c
kdbchk: the amount of space used is not equal to block size
        used=66 fsc=0 avsp=8019 dtl=8096
Block 96081 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 Co