nerdexam
Oracle

1Z0-060 · Question #11

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…

The correct answer is C. Mount the CDB and then recover and open the database, with the RESETLOGS option. D. Open all the pluggable databases. F. Start the database instance in the nomount stage and restore the control file from control file auto backup. 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. *RMAN and Oracle…

New Features for Availability

Question

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?

Options

  • AMount the container database (CDB) and restore the control file from the control file auto backup.
  • BRecover and open the CDB in NORMAL mode.
  • CMount the CDB and then recover and open the database, with the RESETLOGS option.
  • DOpen all the pluggable databases.
  • ERecover each pluggable database.
  • FStart the database instance in the nomount stage and restore the control file from control file auto backup.

How the community answered

(42 responses)
  • A
    10% (4)
  • B
    14% (6)
  • C
    50% (21)
  • E
    26% (11)

Explanation

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. *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).

Topics

#RMAN control file recovery#CDB recovery#RESETLOGS#PDB open after recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice