http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90136/rcmsyn10.htm#79197 Examples Recovering a Group of Corrupt Blocks: Example This example recovers corrupt blocks in three datafiles: BLOCKRECOVER dATAFILE 2 BLOCK 12, 13 dATAFILE 7 BLOCK 5, 98, 99 dATAFILE 9 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 set with the tag weekly_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 the SYSTEM tablespace and forces the blocks to be restored from backups created at least t Wo Days Ago: BlockRecover TableSpace System DBA 4194404, 4194405 Restore Until Time 'sysdate-2'
RMAN can restore logic bad blocks in the case of data file online, manually shut down database editing data files caused damage, then test SQL> select count (*) from rainy.test; select count (*) from rainy.test * error at line 1 : ORA-01578: ORA-01578: Oracle Data Block Corrupted (File # 2, Block # 12) ORA-01110: Data File 2: 'E: /oracle/oradata/rainy/test.dbf' Rman> Run {2> BlockRecover DataFile 2 Block 12 from datafilecopy;} Starting blockrecover at 2003-09-08 12:22:27 using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid = 16 devtype = DISK channel ORA_DISK_1: restoring block (s) from datafilecopy E : / Test.dbf Starting Media Recovery Media Recovery Complete Finished BlockRecover AT 2003-09-08 12:22:34 RMAN> SQL> Select Count (*) from rainy.test; count (*) -------------------------------------------------------------------------------------------- - 29725 SQL> Related resources: Oracle Database 11G RMAN Backup and Recovery - Detailed Bookmark Edition
