RMAN Repair Block Corruption

Check Block Corruptions (SQLPLUS)

COLUMN owner FORMAT A20
COLUMN segment_name FORMAT A30
SELECT DISTINCT owner, segment_name
FROM   v$database_block_corruption dbc
       JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
ORDER BY 1,2;

Recover Blocks Using RMAN

RMAN> blockrecover datafile 3 block 121;

Other Block Repair Methods

  • Full DB recovery
  • Individual datafile recovery
  • Drop table and restore if from previous export

Was this article helpful?

Related Articles

Leave a Comment