(Q) What is Block Media Recovery?
Recovery of specified blocks within a data file
RMAN> RECOVER ... BLOCKLeaves 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