You executed the following command to back up the control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE ;
What do you find in the trace file?
A.
Image of the control file
B.
Location of the control file
C.
Contents of the control file in text format
D.
SQL command to re-create the database
E.
SQL command to re-create the control file
F.
Contents of the control file in binary format
Explanation:
Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:
1. Back up the control file to a binary file (duplicate of existing control file) using the following statement:
ALTER DATABASE BACKUP CONTROLFILE TO’/oracle/backup/control.bkp’;
2. Produce SQL statements that can later be used to re-create your control file:/ ALTER DATABASE BACKUP CONTROLFILE TO TRACE
This command writes a SQL script to the database trace file where it can be captured and edited to reproduce the control file.
REF.: Oracle 10g Administrator Guide, 5-8