1Z0-062 · Question #255
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 aduplexed c
The correct answer is C. The database instance remains open and the control file can be restored without shutting down. In an ARCHIVELOG mode database with duplexed control files and RMAN autobackups, the loss of one control file copy will not cause the database instance to abort, and the lost file can be restored online.
Question
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 aduplexed control file?
Options
- AThe database remains open but transactions are not permitted.
- BThe database instance aborts, and media recovery is required after restoration of the control file
- CThe database instance remains open and the control file can be restored without shutting down
- DThe database instance aborts and a control file restore operation does not require media
How the community answered
(34 responses)- A3% (1)
- B6% (2)
- C88% (30)
- D3% (1)
Why each option
In an ARCHIVELOG mode database with duplexed control files and RMAN autobackups, the loss of one control file copy will not cause the database instance to abort, and the lost file can be restored online.
The database will continue to operate with the remaining control file copies, and while specific operations might encounter errors, the primary outcome is not merely restricted transactions but the ability to continue running.
The database instance does not abort if at least one copy of the control file is still available; it continues running using the remaining valid copies to ensure continuous operation.
When control files are duplexed (multiple copies exist), the loss of one copy does not immediately cause the database instance to abort because other valid copies are still available, allowing the database to remain open and the damaged control file to be restored or re-created online.
The database instance does not abort in this specific scenario because other control file copies are present; therefore, the premise that it aborts is incorrect.
Concept tested: Oracle duplexed control file loss behavior and recovery
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-and-recovering-the-control-file.html#GUID-98C39F22-506B-4819-B589-9A265BF77771
Topics
Community Discussion
No community discussion yet for this question.