nerdexam
Oracle

1Z0-060 · Question #214

Your multitenant container database (CDB) is running in ARCHIVELOG mode. Examine this command and its output: You issue this command in RMAN: RMAN>BACKUP PLUGGABLE DATABASE "CDB$ROOT", pdb2_1; What…

The correct answer is C. The backup succeeds and all the data files belonging to both the root container and PDB2_1 are. In Oracle RMAN, the BACKUP PLUGGABLE DATABASE command accepts both CDB$ROOT and named PDBs in a single operation, backing up all associated data files for each.

New Features for Availability

Question

Your multitenant container database (CDB) is running in ARCHIVELOG mode. Examine this command and its output:

You issue this command in RMAN:

RMAN>BACKUP PLUGGABLE DATABASE “CDB$ROOT”, pdb2_1; What is the outcome?

Options

  • AThe backup succeeds, but only the SYSTEM and SYSAUX tablespaces in the root container are
  • BThe backup fails because the root container cannot be backed up with PDB2_1.
  • CThe backup succeeds and all the data files belonging to both the root container and PDB2_1 are
  • DThe backup fails because PDB2_1 should be placed in the mount stage.

How the community answered

(41 responses)
  • A
    10% (4)
  • B
    2% (1)
  • C
    71% (29)
  • D
    17% (7)

Why each option

In Oracle RMAN, the BACKUP PLUGGABLE DATABASE command accepts both CDB$ROOT and named PDBs in a single operation, backing up all associated data files for each.

AThe backup succeeds, but only the SYSTEM and SYSAUX tablespaces in the root container are

RMAN does not restrict a BACKUP PLUGGABLE DATABASE operation to only SYSTEM and SYSAUX tablespaces; it backs up every data file associated with the specified containers, including user-defined tablespaces.

BThe backup fails because the root container cannot be backed up with PDB2_1.

There is no Oracle restriction preventing CDB$ROOT from being backed up in the same command as a PDB; RMAN treats both as valid targets for the BACKUP PLUGGABLE DATABASE command.

CThe backup succeeds and all the data files belonging to both the root container and PDB2_1 areCorrect

The BACKUP PLUGGABLE DATABASE command fully supports mixing CDB$ROOT with one or more PDBs in a single statement. When the CDB is in ARCHIVELOG mode, RMAN performs an online backup of all data files belonging to both the root container and PDB2_1, producing a complete and valid backup of both without restriction.

DThe backup fails because PDB2_1 should be placed in the mount stage.

A PDB does not need to be in mount stage for an RMAN backup when the CDB is in ARCHIVELOG mode; online hot backups of open PDBs are fully supported.

Concept tested: RMAN backup of CDB root container alongside a PDB

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html

Topics

#RMAN CDB backup#PDB backup#root container backup#pluggable database recovery

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-060 Practice