Last updated on December 21st, 2015 at 05:34 am
1. Recovering Data blocks By Using All Available Backups
Run the BLOCKRECOVER command at the RMAN prompt, specifying the file and block numbers for the corrupted blocks
RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15;
Recover multiple blocks in single command
RMAN>BLOCKRECOVER DATAFILE 11 BLOCK 15 DATAFILE 2 BLOCK 10;
2. Recovering Data blocks Using Selected Backups
Run the BLOCKRECOVER command at the RMAN prompt, Specifying the data file and block numbers for the corrupted blocks and limiting the backup candidates by means of the available options. For example, specify what type of backup should be used to restore the blocks.
# restore from backupset
RMAN> BLOCKRECOVER DATAFILE 11 BLOCK 15 FROM BACKUPSET;
# restore from datafile image copy
RMAN> BLOCKRECOVER DATAFILE 11 BLOCK 15 FROM DATAFILECOPY;
# restore from backup set with tag “Sunday”
RMAN> BLOCKRECOVER DATAFILE 11 BLOCK 15 FROM TAG = Sunday;
3 . Recovering blocks listed in V$DATABASE_BLOCK_CORRUPTION view
Run the below command to recover all blocks marked corrupt in V$DATABASE_BLOCK_CORRUPTION
RMAN> BLOCKRECOVER CORRUPTION LIST;
Restores blocks from backup sets created more than 7 days ago
RMAN> BLOCKRECOVER CORRUPTION LIST FROM BACKUPSET RESTORE UNTIL TIME ‘SYSDATE-7’;