Oracle Database 12c: Advanced Administration — Question 33

You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
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 CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
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 REPAIR FAILUER command.
• D. The command executes successfully, performs recovery, and opens PDB_1.

Correct answer: D

Explanation

The correct answer is D because the REPAIR FAILURE command in RMAN is designed to handle issues related to specific data files and will successfully execute the necessary recovery processes to resolve the failure. Options A, B, and C are incorrect because A does not specify that PDB_1 is opened, B is wrong since RMAN can interact with the CDB$ROOT, and C is incorrect as the ADVISE FAILURE command is not a prerequisite for the REPAIR FAILURE command.