Oracle Exam 1Z0-060 Topic 9 Question 43 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 43
Topic #: 9

Your database is running In archivelog mode. You back up the control file by executing alter database backup controlfile 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 would you recover the control file to Its default location?

AIssue the startup nomount command, restore the backup control file only to the default location, issue recover database using backup controlfile until cancel, and open the database with the resetlogs option.

BRestore 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 the resetlogs option.

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

DIssue the startup mount 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.

Show Suggested Answer

Suggested Answer: A

by Jolanda at Jun 24, 2022, 01:30 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!