Multiple choice technology databases

When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.

  1. OPEN

  2. IDLE

  3. MOUNT

  4. NOMOUNT
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When restoring a control file in NOARCHIVELOG mode using RMAN, the database must be in NOMOUNT state. NOMOUNT allows instance initialization and control file access without opening the data files. OPEN state would require a valid control file already, MOUNT needs the control file to be accessible, and IDLE is not a valid Oracle state. The NOMOUNT state enables control file restoration before mounting.

Keep practicing — related questions