Block media recovery (BMR) recovers one block or a set of data blocks marked "media corrupt" in a data file by using the RMAN BLOCKRECOVER
command. When a small number of data blocks are marked media corrupt and require media recovery, you can selectively restore and recover damaged blocks rather than whole data files. This results in lower RTO because only blocks that need recovery are restored and only necessary corrupt blocks undergo recovery. Block media recovery minimizes redo application time and avoids I/O overhead during recovery. It also enables affected data files to remain online during recovery of the corrupt blocks. The corrupt blocks, however, remain unavailable until they are completely recovered.
Use block media recovery when:
-
A small number of blocks require media recovery and the blocks that need recovery are known. If a significant portion of the datafile is corrupt, or if the amount of corruption is unknown, then a different recovery method should be used.
-
Blocks are marked corrupt (verified with the RMAN
BACKUP VALIDATE
command) and only when complete recovery is required. -
Backup of the data file containing the corrupted blocks is available locally or can be retrieved from a remote location including from a a physical standby database.
Block media recovery cannot be used to recover from the following:
-
User error or software bugs that cause logical corruption where the data blocks are intact. See Section 4.2.8, "Recovering from Human Error" for additional details for this type of recovery.
-
Changes caused by corrupt redo data. Block media recovery requires that all available redo data be applied to the blocks being recovered.
For example, to recover a specific corrupt block using RMAN block media recovery:
RMAN> BLOCKRECOVER DATAFILE 7 BLOCK 3;
32. What are the two advantages of RMAN Block Media Recovery (BMR) over filelevel
recovery?
(Choose two.)
A.BMR lowers the mean time to recover (MTTR).
B.BMR supports pointintime
recovery of individual data blocks.
C.BMR enables you to use incremental backups for block recovery.
D.BMR enables recovery even when the database is not mounted or open.
E.BMR enables you to use proxy backups to perform block media recovery.
F.BMR enables increased availability of data during recovery because the data file that requires a
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 14
TestInside
Information Co., Ltd. All rights reserved.
recovery can remain online.
Answer: AF