Oracle Database Blog‎ > ‎Backup & Recovery‎ > ‎RMAN‎ > ‎

Block Media Recovery

DB block corruption - recovery examples:


BLOCKRECOVER DATAFILE 2 BLOCK 12, 13 DATAFILE 3 BLOCK 5, 98, 99 DATAFILE 4 BLOCK 19;


RUN
{
  BLOCKRECOVER DATAFILE 3 BLOCK 2,3,4,5 TABLESPACE sales DBA 4194405, 4194409, 4194412
  FROM DATAFILECOPY;
}


BLOCKRECOVER TABLESPACE SYSTEM DBA 123456789, 123456780 FROM TAG "weekly_backup";


Recover from backup to point of time of two days ago:

BLOCKRECOVER TABLESPACE SYSTEM DBA 123456789, 123456780 RESTORE UNTIL TIME 'SYSDATE-2';


Runs a backup validation to populate V$DATABASE_BLOCK_CORRUPTION and repairs all corruptions:

BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;