1Z0-083 practice question 13 of 35

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

Full set: 286 questions
Answer options
A: It creates a binary backup of the control file.
B: It updates the alert log with the location and contents of the control file
C: It creates a file that contains SQL statements to re-create the control file. Correct answer
D: It creates a file that contains RMAN scripts to create a duplicate database.
E: It creates a copy of the control file in the fast recovery area (FRA).
Correct Answer:
C. It creates a file that contains SQL statements to re-create the control file.
Explanation

The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command reads the current control file and writes a human-readable script to a trace file in the Automatic Diagnostic Repository (ADR) trace directory. This script contains the CREATE CONTROLFILE SQL statement, which can be edited and executed to recreate the control file if all physical copies are lost. It is a critical part of disaster recovery planning, providing a logical backup of the control file's structure and contents.

Why Incorrect

A. A binary backup is created using the BACKUP CONTROLFILE TO 'filename' syntax or via RMAN, not with the TO TRACE clause.
B. The alert log records the location of the generated trace file, but it does not contain the full SQL script itself.
D. The generated file is a SQL script for control file creation, not an RMAN script for database duplication.
E. The output is a text-based trace file in the diagnostic destination, not a binary copy of the control file in the FRA.

References

1. Oracle Database SQL Language Reference, 19c. "ALTER DATABASE". In the section for backupcontrolfileclause, it states: "Specify TO TRACE to write a SQL script to a trace file that can be used to re-create the control file."

2. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 15, "Managing the Control File". Section "Backing Up the Control File to a Trace File". It explains that this command creates a script with a CREATE CONTROLFILE statement.

Scroll to Top