Multiple choice

Five data files, that are spread across multiple disks have to be recovered. Which initialization parameter should be set to speed up redo application?

  1. RECOVERY_PARALLELISM

  2. FAST_START_MTTR_TARGET

  3. LOG_CHECKPOINT_INTERVAL

  4. FAST_START_PARALLEL_ROLLBACK

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

RECOVERY_PARALLELISM is the initialization parameter that controls the degree of parallelism used during media recovery. When recovering multiple data files spread across different disks, setting this parameter allows Oracle to spawn multiple recovery processes that can apply redo logs in parallel to different data files simultaneously. This parallelization significantly speeds up redo application compared to sequential processing. FAST_START_MTTR_TARGET controls crash recovery time, LOG_CHECKPOINT_INTERVAL affects checkpoint frequency, and FAST_START_PARALLEL_ROLLBACK manages transaction rollback parallelism - none of these specifically control parallel redo application during media recovery.