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/lockdata file 11 – see DBWR trace file ORA-01110:data file 11:’/u01/app/oracle/oradata/cdb1/pdb_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 FAILURE command.
D.
The command executes successfully, performs recovery, and opens PDB_1.
D
C RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
I think C:
RMAN> REPAIR FAILURE;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of repair command at 10/22/2017 14:19:09
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
C
C