You are working on a very large database. You had performed a binary backup of the control file a
month ago. After this you added a few tablespaces, and dropped a couple of tablespaces. This
morning, due to hardware failure, you lost all your control files. How would you recover the
database from this situation?
A.
execute the CREATE CONTROLFILE FROM BACKUP.. command
B.
restore all database files from the last backup and apply redo logs till the point of failure
C.
restore the binary copy of the control file to the respective location and start up the database
D.
start up the database in the NOMOUNT state, generate the trace file from binary backup, and recreate the control file using the trace file and
then mount and open the database
E.
restore the binary copy of the control file to the correct location, start up the instance in the
mount state, backup the control file to trace, shut down the instance, edit the trace file to reflect the
added and removed data files, then use the script generated in the trace file to start the instance
and re-create the control file
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’;
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 a trace file where it can be captured and edited to reproduce the control file. View the alert log to determine the name and location of the trace file.
BINARY ~~ long step