Oracle Database 12c: Installation and Administration — Question 52

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of a duplexed control file?

Answer options

• A. The database remains open but transactions are not permitted.
• B. The database instance aborts, and media recovery is required after restoration of the control file to open the database.
• C. The database instance remains open and the control file can be restored without shutting down the database.
• D. The database instance aborts and a control file restore operation does not require media recovery.

Correct answer: C

Explanation

The correct answer is C because when a duplexed control file is lost, the database can remain open, allowing the control file to be restored without needing to shut down. Options A and B are incorrect since the database does not abort in this scenario, and media recovery is not required. Option D is also wrong because the instance does not abort.