1Z0-060 · Question #217
Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to the database. A…
The correct answer is B. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default. When all control files are lost but online redo logs are intact and a NORESETLOGS trace backup exists, recovery begins at STARTUP NOMOUNT and recreates the control file only at the default location before opening without RESETLOGS.
Question
Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact. You issue a SHUTDOWN ABORT. How should you recover the control file to its default location?
Options
- ARestore the backup control file to all the locations specified in the CONTROL_FILES parameter
- BIssue the STARTUP NOMOUNT command, restore the backup control file only to the default
- CIssue the STARTUP MOUNT command, restore the backup control file to all the locations
- DIssue the STARTUP NOMOUNT command, re-create the control file manually by using the
How the community answered
(41 responses)- A10% (4)
- B68% (28)
- C17% (7)
- D5% (2)
Why each option
When all control files are lost but online redo logs are intact and a NORESETLOGS trace backup exists, recovery begins at STARTUP NOMOUNT and recreates the control file only at the default location before opening without RESETLOGS.
Attempting to restore or copy the control file before issuing any STARTUP command is incorrect; the Oracle instance must first be started to NOMOUNT stage before the control file can be recreated or placed into the proper location.
Because no control file exists, the instance can only start to NOMOUNT stage. The ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS command produced a SQL script that recreates the control file using the NORESETLOGS option, meaning the intact online redo logs are preserved and the database can be opened without RESETLOGS. Recreating the control file at the default location is sufficient to allow mounting, recovering, and opening the database in this scenario.
STARTUP MOUNT requires a valid control file to exist before Oracle can mount the database; since all control files are damaged, the instance cannot reach MOUNT stage and must instead be started to NOMOUNT first.
Although recreating the control file from the trace script is technically the right method, this option likely specifies using RESETLOGS in the CREATE CONTROLFILE statement, which is incorrect here because the backup was taken with NORESETLOGS and the online redo logs are intact, making RESETLOGS an unnecessary and data-destructive choice.
Concept tested: Control file recovery from BACKUP CONTROLFILE TO TRACE NORESETLOGS
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-recovery-scenarios.html
Topics
Community Discussion
No community discussion yet for this question.