nerdexam
Oracle

1Z0-060 · Question #178

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases. You issue the following…

The correct answer is B. 1,2,5,6,7,8 C. 1,2,10,5,6,9. Recovering a PDB in a CDB running in ARCHIVELOG mode requires a precise sequence - connecting to RMAN targeting the CDB, placing the PDB offline, restoring and recovering, then reopening the PDB correctly.

New Features for Availability

Question

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases. You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

Exhibits

1Z0-060 question #178 exhibit 1
1Z0-060 question #178 exhibit 2

Options

  • A1,2,3,4,7,8
  • B1,2,5,6,7,8
  • C1,2,10,5,6,9
  • D10,3,4,8,9

How the community answered

(42 responses)
  • A
    29% (12)
  • B
    60% (25)
  • D
    12% (5)

Why each option

Recovering a PDB in a CDB running in ARCHIVELOG mode requires a precise sequence - connecting to RMAN targeting the CDB, placing the PDB offline, restoring and recovering, then reopening the PDB correctly.

A1,2,3,4,7,8

Sequence 1,2,3,4,7,8 uses steps 3 and 4 in place of the restore and recover operations, which are not the correct RMAN commands for this recovery scenario, causing the recovery to be incomplete before the PDB open is attempted.

B1,2,5,6,7,8Correct

Sequence 1,2,5,6,7,8 follows the correct order by first establishing the RMAN connection to the CDB (1,2), then performing the restore (5) and recover (6) operations on the PDB, and finally opening the PDB and making data available (7,8).

C1,2,10,5,6,9Correct

Sequence 1,2,10,5,6,9 is also valid - after connecting (1,2), step 10 handles placing the PDB in the required state before the restore (5) and recover (6) operations, and step 9 properly opens the PDB with the necessary options to complete recovery.

D10,3,4,8,9

Sequence 10,3,4,8,9 begins without first establishing the proper RMAN connection to the CDB root (steps 1 and 2), and applies subsequent commands in an order that skips the required restore step, making a successful recovery impossible.

Concept tested: Oracle CDB PDB ARCHIVELOG mode RMAN recovery sequence

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovery-cdb.html

Topics

#CDB recovery#PDB recovery#RMAN ARCHIVELOG#multitenant recovery sequence

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice