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.
D
B right answer(D wrong) experimentally approved
startup force nomount;
restore controlfile from autobackup;
alter database mount;
restore database;
recover database noredo;
alter database open resetlogs;
If you try with condition – the current online redo log file is lost and following commands sequence
restore database;
recover database noredo;
alter database open resetlogs;
You will get the
“ORA-01139: RESETLOGS option only valid after an incomplete database recovery”
after last command.
B
B is the right answer
Reference:
https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140
See Example 3-6 Recovering a NOARCHIVELOG Database
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;
B. When db in noarchived log mode. We must restore controlfile first even controlfile is available.
B