RMAN SCRIPT : BLOCK RECOVERY

[ block_recovery.scp]

# Block recovery can be used to recover a corrupted block(s). It is not intended to recover complete datafile. Usually, the corruption is reported in alert logs, trace files or results in SQL commands. for example, as a result of SQL command

# SQL > select * from emp;

# NAME

#ORA-01578: ORACLE datablock corrupted ( file # 7, block # 233)

#ORA-01578: ORACLE datablock corrupted ( file # 4, block # 101)

#ORA-01110: datafile 7:'/oracle/dbs/tbs_07.f'

#ORA-01110: datafile 4:'/oracle/dbs/tbs_04.f'

# Use the following BLOCKRECOVER command to recover the corrupted blocks

BLOCKRECOVER DATAFILE 7 BLOCK 233 DATAFILE 4 BLOCK 101;

# The BLOCKRECOVER command can also be used to repair all corrupted blocks

# listed iN V$BACKUP_CORRUPTION and V$COPY_CORRUPTION. These views are populated whenever an RMAN process performs a complete scan of a file for the purpose

of backing it up, such as with the BACKUP or COPY command. Use the following command to repair all blocks listed in the V$xxxCORRUPTION views command

BLOCKRECOVER CORRUPTION LIST;