Upgrade Oracle DBA 11g to Oracle Database 12c — Question 5

You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile
ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDBSROOT. You execute the following as the first command:
RMAN>REPAIRFAILURE;
Which statement describes the consequence of the command?

Answer options

• A. The command performs the recovery and closes the failure.
• B. The command produces an error because RMAN is not connected to the target database pdb_1.
• C. The command produces an error because the advise failure command was not executed before the REPAIRFAILUER command.
• D. The command executes successfully, performs recovery, and opens PDB_1.

Correct answer: D

Explanation

The correct answer is D because the REPAIRFAILURE command in RMAN is designed to handle recovery for the specified failure and can successfully open the PDB once the repair is complete. Options A and B are incorrect; A does not specify that the command opens PDB_1, and B incorrectly states that RMAN's connection to pdb_1 is necessary. Option C is also incorrect because the REPAIRFAILURE command can be executed without running the advise failure command first.