Your multitenant container database (CDB) contains three pluggable database (PDBs). You find
that the control file is damaged. You plan to use RMAN to recover the control file. There are no
startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully
operational?
A.
Mount the container database (CDB) and restore the control file from the control file auto
backup.
B.
Recover and open the CDB in NORMAL mode.
C.
Mount the CDB and then recover and open the database, with the RESETLOGS option.
D.
Open all the pluggable databases.
E.
Recover each pluggable database.
F.
Start the database instance in the nomount stage and restore the control file from control file
auto backup.
Explanation:
Step 1: F
Step 2: D
Step 3: C: If all copies of the current control file are lost or damaged, then you must restore and
mount a backup control file. You must then run theRECOVERcommand, even if no data files have
been restored, and open the database with theRESETLOGSoption.
Note:
* RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for
backup and recovery in a multitenant environment. You can back up and recover a whole
multitenant container database (CDB), root only, or one or more pluggable databases (PDBs).
IMHO it’s B, D and F
Its C,D,F
There is no need to open database with RESETLOGS option after such restore, so “C” is invalid option. So, I agree with Fabio.
RESETLOGS is required.
Looks like RESETLOGS is required:
http://docs.oracle.com/database/121/BRADV/glossary.htm#BRADV526
“An ALTER DATABASE OPEN RESETLOGS statement is required after incomplete recovery or recovery with a backup control file.”
http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta007.htm#i78652
STARTUP NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
CDF
F C and D
F.
Start the database instance in the nomount stage and restore the control file from control file auto backup.
C.
Mount the CDB and then recover and open the database, with the RESETLOGS option.
D.
Open all the pluggable databases.
FCD – OK
control file is a part of CDB not PDB we no need to recover PDB
we canot mount if we dont have control file
RESETLOGS is needed in
alter database open resetlogs;
CDF
F,C and D is correct order.
CDF
It is definitely C, D, F. Whenever a controlfile is restored, the database has to be restored/recovered and then opened with ‘RESETLOGS’ option. Only when you relocate a controlfile from one place to another, you don’t have to use the ‘RESETLOGS’ option. That is the only exception.
A – Incorrect because you can’t mount the database and then recover the corrupted controlfile.
B – Incorrect because you can’t open the CDB in NORMAL mode after restoring/recovering the controlfile.
E – Incorrect because recovering each PDB is unnecessary. As the CDB is restored/recovered, all the PDBs are mounted and ready to go.
Therefore CDF is correct.
CDF
D is not required as of 12.1.0.2 if pdb has saved state. and in general it’s wrong – maybe you want to keep some PDBs closed intentionally… but for the test this answer is ok.
Correct Sequence
F restore controlfile in nomount
C mount the cdbs, recover, open resetlog
D open all pdbs
CDF – doesn’t tell anything about control file restoration, but directly to mount the CDB. So C should not be the first option.
FCD is correct.