11g rman blockrecover 的新特性，rmanblockrecover

11g rman blockrecover 的新特性，rmanblockrecover

參考自：
New Rman Blockrecover command in 11g (Recover corruption list) (文檔 ID 1390759.1)

11g rman blockrecover 時的新特性：
注意：10g時的blockrecover命令被廢棄，但是依然支援。

Rman> Recover datafile <fileno> block <block number reported corrupt>;Rman> Recover datafile <fileno> block <block number >  to <block  number>;Rman> recover corruption list ;--->將V$DATABASE_BLOCK_CORRUPTION 中的壞塊都recover掉。

 

Rman> Recover tablespace <name> dba <integer value> ;Rman> Recover tablespace testing dba 29360329 ;

 舉例：

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 ;

 

而10g時，只能：

RMAN> blockrecover datafile 5 block 20; --->只能用這個文法！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:00Finished blockrecover at 17-JUN-15RMAN>