• Arun Kumar

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

191 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir