New Features of 11g rman blockrecover, rmanblockrecover
Reference:
New Rman Blockrecover command in 11g (Recover upload uption list) (Document ID 1390759.1)
New Features of 11g rman blockrecover:
Note: The blockrecover command for 10 Gb is discarded, but it is still supported.
Rman> Recover datafile <fileno> block <block number reported upload upt>; Rman> Recover datafile <fileno> block <block number> to <block number>; Rman> recover uption list; ---> recover all the bad blocks in V $ DATABASE_BLOCK_CORRUPTION.
Rman> Recover tablespace <name> dba <integer value> ;Rman> Recover tablespace testing dba 29360329 ;
Example:
SQL>SELECT DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS(<file#>,<block#>) FROM DUAL;SQL> SELECT DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS(7,201) FROM DUAL;DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS(7,201)------------------------------------------- 29360329Rman> Recover tablespace <name> dba <integer value> ;Rman> Recover tablespace testing dba 29360329 ;
For 10 Gb, only:
RMAN> blockrecover datafile 5 block 20; ---> you can only use this syntax! Starting blockrecover at 17-JUN-15using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid = 1068 devtype = DISKstarting media recoverymedia recovery complete, elapsed time: 00: 00: 00 Finished blockrecover at 17-JUN-15RMAN>