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. The NOMOUNT state allows RMAN to access the control file without opening the database fully. You cannot restore control files in OPEN, IDLE, or MOUNT states because the database needs to read the control file during startup.

Keep practicing — related questions