ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-060 All Questions

View all questions & answers for the 1z0-060 exam
Go to Exam

Exam 1z0-060 topic 2 question 33 discussion

Actual exam question from Oracle's 1z0-060
Question #: 33
Topic #: 2
[All 1z0-060 Questions]

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?

  • A. 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 the RESETLOGS option.
  • B. Issue 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.
  • C. Issue 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.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Reference:
https://docs.oracle.com/cd/E28271_01/backup.1111/e10642/osadvsce.htm
by Chaudhary at Dec. 18, 2019, 2:51 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Blade69
3 years, 4 months ago
from https://docs.oracle.com/database/121/BRADV/osrecvry.htm#BRADV210 B is the correct answer
upvoted 1 times
...
Yoones
3 years, 11 months ago
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
upvoted 2 times
...
Chaudhary
5 years, 4 months ago
Answer is E http://www.dba-oracle.com/t_alter_database_backup_controlfile_to_trace.htm
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago