Exam 1z0-063 topic 1 question 118 discussion

Actual exam question from Oracle's 1z0-063

Question #: 118
Topic #: 1

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on
Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
C. Restore all the data files, recover them by using the recover database command, and open the database.
D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Show Suggested Answer

Suggested Answer: B 🗳️

by Sherry at Aug. 31, 2019, 9:25 a.m.

Comments

Submit Cancel

mikom80

2 years, 5 months ago

B is correct. Please read example "3-6 Recovering a NOARCHIVELOG Database" from: https://docs.oracle.com/en/database/oracle/oracle-database/21/rcmrf/RECOVER.html#GUID-CA98040F-9865-4F4F-BAF2-91C518612E95 STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; # restore control file from consistent backup ALTER DATABASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS;

upvoted 1 times

...