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?
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.
Explanation:
In Oracle 11g answer is D (https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199) In Oracle 12c answer is C
(https://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199)