New Features for Administrators - Question 033

What does Block Media Recovery (BMR) do?

A. Does only a recovery of the specified blocks

B. Replaces bad blocks by substituting good blocks

C. Uses the DBMS_REPAIR package to fix block corruptions

D. Does a restore and a recovery of the specified blocks

Answer: D

Explanation:

Block Media Recovery restores and recovers the specified blocks. You can use the new BLOCKRECOVER statement to perform BMR.

Incorrect Answers

A: It does not only recover the specific blocks but also restores blocks.

B: It does not replace bad blocks by substituting good blocks.

C: Block Media Recovery does not use the DBMS_REPAIR package to fix block corruptions.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 186

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 84-86

Chapter 3: New Oracle9i Availability and Recoverability Features