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; |