(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