Your production database is running in archivelog mode and you are using recovery manager
(RMAN) with recovery catalog to perform the database backup at regular intervals. When you
attempt to restart the database instance after a regular maintenance task on Sunday, the
database fails to open displaying the message that the data file belonging to the users tablespace
are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
A.
2, 4, 3
B.
1, 4, 3, 2
C.
2, 5, 4, 3, 6
D.
5, 2, 4, 3, 6
E.
1, 5, 4, 3, 6, 2
Explanation:
http://ss64.com/ora/rman_recover.html
Steps for Media Recovery:
1. Mount or open the database.
Mount the database when performing whole database recovery, or open the database when
performing online tablespace recovery.
2. To perform incomplete recovery, use the SET UNTIL command to specify the time,
SCN, or log sequence number at which recovery terminates.
Alternatively, specify the UNTIL clause on the RESTORE and RECOVER commands.
3. Restore the necessary files with the RESTORE command.
4. Recover the datafiles with the RECOVER command.
5. Place the database in its normal state.
For example, open it or bring recovered tablespaces online.
Restore and recover a datafile
what about B?
B is incorrect because, in this case, database ALREADY mounted. E is incorrect to, you don’t need to mount database.
There are 2 ways in this case, the first one:
1. restore corrupted datafile
2. recover corrupted datafile
3. open database
The second one:
1. offline corrupted datafile
2. open database
3. restore corrupted datafile
4. recover corrupted datafile
5. online corrupted datafile
Thats why the correct answer is D