Q&As: Block Media Recovery


(Q) What is Block Media Recovery?

Recovery of specified blocks within a data file
RMAN> RECOVER ... BLOCK
Leaves the affected datafiles ONLINE and recovers only the damaged/corrupted data blocks.


$ rman
RMAN> connect target /
connected to target database: ORCL11G (DBID=123456789)

RMAN> recover datafile 2 block 13;
...

     (optionally)
RMAN> recover … 
        From backupset …
        Exclude flashback log

     (To recover ALL blocks logged in V$DATABASE_BLOCK_CORRUPTION)
RMAN> recover corruption list;

No comments:

Post a Comment