oracle 数据快修复—之使用RMAN 块介质恢复
Examples
Recovering a Group of Corrupt Blocks: Example This example recovers corrupt blocks in three datafiles:
BLOCKRECOVER DATAFILE 2 BLOCK 12, 13 DATAFILE 3 BLOCK 5, 98, 99 DATAFILE 4 BLOCK 19;
Limiting Block Media Recovery by Type of Restore: Example The following example recovers a series of blocks and restores only from datafile copies:
RUN{ BLOCKRECOVER DATAFILE 3 BLOCK 2,3,4,5 TABLESPACE sales DBA 4194405, 4194409, 4194412 FROM DATAFILECOPY;}Limiting Block Media Recovery by Backup Tag: Example This example recovers blocks and restores only from the backup with the tagweekly_backup:
BLOCKRECOVER TABLESPACE SYSTEM DBA 4194404, 4194405 FROM TAG "weekly_backup";
Limiting Block Media Recovery by Time: Example The following example recovers two blocks in theSYSTEM tablespace. It restores only from backups that could be used to recover the database to a point two days ago:
BLOCKRECOVER TABLESPACE SYSTEM DBA 4194404, 4194405 RESTORE UNTIL TIME 'SYSDATE-2';
Repairing All Block Corruption in the Database: Example The following example runs a backup validation to populateV$DATABASE_BLOCK_CORRUPTION, then repairs any corrupt blocks recorded in the view:
BACKUP VALIDATE DATABASE;BLOCKRECOVER CORRUPTION LIST;