OCP CBT Question 565

Please solve the following question.

You are a DBA for an Oracle database operating in ARCHIVELOG mode. A critical data file belonging to the USERS tablespace is accidentally deleted. The database is currently open. Which sequence of RMAN commands should you use to perform a complete recovery of the affected data file and bring the database back to its current state?

sql-- Database is currently open and in ARCHIVELOG mode-- The data file for USERS tablespace at '/u01/app/oracle/oradata/ORCL/users01.dbf' has been deleted by OS command.

sqlRMAN> SQL 'ALTER TABLESPACE USERS OFFLINE IMMEDIATE';RMAN> RESTORE DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> RECOVER DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> SQL 'ALTER TABLESPACE USERS ONLINE';

sqlRMAN> RESTORE DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> RECOVER DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf' ONLINE;

sqlRMAN> SHUTDOWN IMMEDIATE;RMAN> STARTUP MOUNT;RMAN> RESTORE DATABASE;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN;

sqlRMAN> SQL 'ALTER DATABASE DATAFILE ''/u01/app/oracle/oradata/ORCL/users01.dbf'' OFFLINE DROP';RMAN> RESTORE DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> RECOVER DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf';RMAN> SQL 'ALTER DATABASE DATAFILE ''/u01/app/oracle/oradata/ORCL/users01.dbf'' ONLINE';