Which option identifies the correct sequence that you must use to recover the data files?

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
RMAN> SQL ‘ALTER DATABASE DATAFILE 64 OFFLINE’;
RMAN> RESTORE DATAFILE 64;
RMAN> RECOVER DATAFILE 64;
RMAN> SQL ‘ALTER DATABASE DATAFILE 64 ONLINE’;