1z0-060 Exam QuestionsBrowse all questions from this exam

1z0-060 Exam - Question 33


Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE

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

You issue a SHUTDOWN ABORT.

How should you recover the control file to its default location?

Show Answer
Correct Answer: D

To recover the control file to its default location, issue the STARTUP NOMOUNT command, re-create the control file manually using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command. This process will ensure the control file is accurately restored and the database can be properly recovered and opened.

Discussion

3 comments
Sign in to comment
Yoones
Jun 4, 2021

Based on Re-creating a Controlfile in this reference: https://docs.oracle.com/cd/E28271_01/backup.1111/e10642/osadvsce.htm#CHDJAABB The correct answer is : D

Chaudhary
Dec 18, 2019

Answer is E http://www.dba-oracle.com/t_alter_database_backup_controlfile_to_trace.htm

Blade69
Jan 5, 2022

from https://docs.oracle.com/database/121/BRADV/osrecvry.htm#BRADV210 B is the correct answer