Prev Question
Next Question

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).

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *