Which command will result in a trace file being created with the create controlfile command
contained in it?
A.
alter database backup controlfile;
B.
alter database backup controlfile to trace;
C.
alter database controlfile backup;
D.
alter database controlfile backup to ‘/ora01/oracle/ctrl_backup.ctl’;
E.
alter database begin controlfile backup;
Explanation:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE
Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file
rather than making a physical backup of the control file. You can use SQL statements written
to the trace file to start up the database, re-create the control file, and recover and open the
database appropriately, based on the created control file. If you issue an ALTER
DATABASE BACKUP CONTROLFILE TO TRACE statement while block change tracking is
enabled, then the resulting trace file will contain a command to reenable block change
tracking.
The trace file will also include ALTER DATABASE REGISTER LOGFILE statements for
existing logfiles that reside in the current archivelog destinations. This will implicitly create
database incarnation records for the branches of redo to which the logfiles apply.
You can copy the statements from the trace file into a script file, edit the statements as
necessary, and use the script if all copies of the control file are lost (or to change the size of
the control file).