Multiple choice technology databases

Suppose you are working in a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two)

  1. By multiplexing the control files.

  2. By multiplexing the redo log files.

  3. By decreasing the size of redo log files.

  4. By configuring the Mean Time Recover (MTTR) to a lower value.

  5. By setting UNDO_RETENTION parameter to a higher value.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Instance recovery time depends on the amount of redo to apply since the last checkpoint. Reducing redo log file size (C) causes more frequent checkpoints, leaving less redo to apply. Configuring FAST_START_MTTR_TARGET to a lower value (D) tells Oracle to recover faster by advancing checkpoints more aggressively. Multiplexing files (A, B) improves availability but not recovery speed. UNDO_RETENTION affects undo, not redo recovery.

Keep practicing — related questions