Which three steps should you perform to recover the control file and make the database fully operational?

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?

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 the RECOVERcommand, even if no data files have
been restored, and open the database with the RESETLOGS option.
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).



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Ranieri

Ranieri

F, C and D (in this order)

max

max

F,C,D this is perfect!

narendra

narendra

F,C,D this is perfect!