You are administering a database that supports 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. You want to recover
the data file. Examine the steps involved in the recovery process: 1.Shut down the database
instance. 2.Start up the database instance in nomount state. 3.Mount the database. 4.Take
the data file offline. 5.Put the data file online. 6.Restore the control file. 7.Restore the
database. 8.Restore the data file. 9.Open the database with the resetlog option. 10.Recover
the database with the noredo option. 11.Recover the data file with the noredo option.
Identify the required steps in the correct order.
A.
1, 2, 6, 3, 8, 11, 9
B.
4, 8, 11, 5
C.
1, 3, 8, 11, 9
D.
1, 2, 6, 3, 7, 10, 9
E.
1, 3, 7, 10, 9
Explanation:
d
D
“Because the online redo logs are lost, you must specify the NOREDO option in the RECOVER command” – D and E are incorrect
cannot offline datafile in noarchivelog – B incorrect
doesn’t make sense to recover only one datafile – C incorrect
my mistake,should be:
D
“recover DATABASE noredo” should be applied according do docs -A,B,C incorrect
“RESTORE CONTROLFILE” is needed – E incorrect
https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm -similar scenario described