nerdexam
Oracle

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.

New Features for Availability

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)
  • A
    10% (4)
  • B
    68% (28)
  • C
    17% (7)
  • D
    5% (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.

ARestore the backup control file to all the locations specified in the CONTROL_FILES parameter

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.

BIssue the STARTUP NOMOUNT command, restore the backup control file only to the defaultCorrect

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.

CIssue the STARTUP MOUNT command, restore the backup control file to all the locations

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.

DIssue the STARTUP NOMOUNT command, re-create the control file manually by using the

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

#control file recovery#BACKUP CONTROLFILE TO TRACE#STARTUP NOMOUNT#media recovery sequence

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice