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 withthe noredo option.
11) Recover the data file with the noredo option.
Identify the required steps in the correct order.
A.
4, 8, 11, 5
B.
1, 3, 8, 11, 9
C.
1, 2, 6, 3, 7, 10, 9
D.
1, 3, 7, 10, 9
E.
1, 2, 6, 3, 8, 11, 9
C
C
Why not D??
In question 34, you say that if the control file isn´t lost, it isn´t necessary restore it.
I´m sorry. It´s C.
Same as Q34.
Should be D. (https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV008)
Hi Guys !
I have the same doubt of JJ and Ismaelv90, so i made a test in the enviroment a little diferent.
My configuration:
Oracle 12c enterprise
Database in noarchivelog
Backup Rman Full (Not incremental)
So, i made the step of letter D and i get the error:
ORA-01190: control file or data file 1 is from before the last RESETLOGS
The database did not open because the controlfile being used was ahead from the backup.
After made the steps from Letter C, the database opened.
Then, the correct is C
C