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;