Repairing bad blocks via Rman in Oracle

Oracle database bad blocks are repaired through the DBV and Rman Blockrecover.

(1) When the Rman backup, Alert.log reported the following error:

Fri 2 12:41:36 2010

Hex Dump of (file, block 2718618) in trace file/u01/app/oracle/admin/bi/udump/bi_ora_31213.trc

Corrupt block relative dba:0x03297b9a (file, block 2718618)

Fractured block found during backing up datafile

Data in bad block:

Type:6 Format:2 rdba:0x03297b9a

Last Change scn:0x0002.482fc15b seq:0x1 flg:0x06

spare1:0x0 spare2:0x0 spare3:0x0

Consistency value in tail:0x77b20601

Check value in block header:0x253

Computed Block Checksum:0xb6e9

Reread of blocknum=2718618, file=/u01/oradata/bi/estaging_user01.712.714072365. Found same corrupt data

Reread of blocknum=2718618, file=/u01/oradata/bi/estaging_user01.712.714072365. Found same corrupt data

Reread of blocknum=2718618, file=/u01/oradata/bi/estaging_user01.712.714072365. Found same corrupt data

Reread of blocknum=2718618, file=/u01/oradata/bi/estaging_user01.712.714072365. Found same corrupt data

Reread of blocknum=2718618, file=/u01/oradata/bi/estaging_user01.712.714072365. Found same corrupt data

(2) Querying the database, you know the object containing the bad block:

sql> Col segment_name format A20

Col partition_name format A10

Select Owner,segment_name,partition_name from dba_extents where file_id = and 2718618 between block_id and block_id + b locks-1;

OWNER segment_name Partition_

-------------------- -------------------- ----------

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Estaging Log_record_detail_4 P20100630

(3) But the full table scan does not have any problem:

Sql> Select COUNT (*) from estaging. Log_record_detail_4 partition (P20100630);

COUNT (*)

----------

449937

Sql> Select COUNT (*) from estaging. Log_record_detail_4;

COUNT (*)

----------

42049608

(4) Using DBV Check to find a bad block (time-consuming):

$ DBV file=/u01/oradata/bi/estaging_user01.712.714072365 blocksize=8192

Dbverify:release 10.2.0.4.0-production on Fri June 2 14:15:49 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Dbverify-verification Starting:file =/u01/oradata/bi/estaging_user01.712.714072365

Page 2718618 is influx-most likely media corrupt

Corrupt block relative dba:0x03297b9a (file, block 2718618)

Fractured block found during DBV:

Data in bad block:

Type:6 Format:2 rdba:0x03297b9a

Last Change scn:0x0002.482fc15b seq:0x1 flg:0x06

spare1:0x0 spare2:0x0 spare3:0x0

Consistency value in tail:0x77b20601

Check value in block header:0x253

Computed Block Checksum:0xb6e9

Dbverify-verification Complete

Total Pages examined:2748160

Total Pages processed (Data): 2462446

Total Pages Failing (Data): 0

Total Pages processed (Index): 235234

Total Pages Failing (Index): 0

Total Pages processed (other): 24969

Total Pages processed (SEG): 0

Total Pages Failing (Seg): 0

Total Pages empty:25510