Exam 1z0-060 topic 2 question 49 discussion

Actual exam question from Oracle's 1z0-060

Question #: 49
Topic #: 2

Your database runs in NOARCHIVELOG mode.
Whole database backups are taken daily.
A media failure damages data files belonging to the USERS tablespace and the online redo log files.
The hardware that is causing this damage is not repairable.
You issue the SHUTDOWN ABORT command.
Examine these steps:
1. Restore only the damaged files from the whole database backup to a new location.
2. Restore the whole database backup to a new location.
3. Edit the restored initialization parameter file to indicate the new location of the control files.
4. Issue the STARTUP MOUNT command.
5. Issue the STARTUP NOMOUNT command.
6. Issue the RECOVER DATABASE command.
7. Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME FILE command.
8. Specify a new location for each affected online log by issuing the command:

RECOVER DATABASE UNTIL CANCEL -
9. Open the database in RESETLOGS mode.
Identify the minimum steps required in the correct sequence to recover your database.

A. 1, 3, 5, 8, 9
B. 1, 4, 7, 8, 9
C. 1, 3, 4, 6
D. 2, 5, 6, 7, 9

Show Suggested Answer

Suggested Answer: B 🗳️

by x_fedex at April 5, 2021, 9:52 p.m.

Comments

Submit Cancel

x_fedex

4 years, 2 months ago

B for me is not suitable, due to the fact that this starts from the assumption that USERS datafile was never modified after the cold backup. https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/osrecov010.htm

upvoted 1 times

...