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;