QUESTION 195-ALTER DATABASE CONTROLFILE TO TRACE NORESETLOGS

Your database is running in ARCHIVELOG mode. You backup the controlile by executing:

ALTER DATABASE CONTROLFILE TO TRACE NORESETLOGS

whenever you make structural changes to the database. A media failure has damaged at the ocntrol files, but the online redo log files are intact.

You issue a SHUTDOWN ABORT.

How would you recover the controlfile to its default location?

 

A. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location, issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTILE CANCEL, and open the database with the RESETLOGS option.

B. Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

C. Issue the STARTUP NOMOUNT command, restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP CONTROLFILE.

D. Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with RESETLOGS option.

 

Correct Answer: B