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 datafile noredo 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.
B
D restore of controlfile is not necessary if it wasn’t lost
I think B.
I’m not sure. To start any RMAN recovery, you must have a control
file but in this question is not specified that all control files are lost.
Instead in some example (https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV008) this step is not considered.
Could someone give me some further details to clear this point?
B
https://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmrecov.htm#i1006821
pipiyou gave good example from documentation but difference from B and D is restore of CONTROLFILE which we don’t know is lost or not.
This is tough one, I would personally go for D but B is not bad and maybe more secure option.
B