nerdexam
Oracle

1Z0-062 · Question #75

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You

The correct answer is A. Place the root container in ARHCHIVELOG mode.. RMAN online tablespace backups require the CDB to be in ARCHIVELOG mode so that redo logs can be archived and used for recovery consistency. Without ARCHIVELOG mode, no online backup is possible.

Performing Backup and Recovery

Question

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command:

RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?

Options

  • APlace the root container in ARHCHIVELOG mode.
  • BTake the user data tablespace offline.
  • CPlace the root container in the nomount stage.
  • DEnsure that HR_PDB is open.

How the community answered

(25 responses)
  • A
    84% (21)
  • B
    4% (1)
  • C
    8% (2)
  • D
    4% (1)

Why each option

RMAN online tablespace backups require the CDB to be in ARCHIVELOG mode so that redo logs can be archived and used for recovery consistency. Without ARCHIVELOG mode, no online backup is possible.

APlace the root container in ARHCHIVELOG mode.Correct

RMAN relies on archived redo logs to ensure that online (hot) tablespace backups are recoverable, which requires the CDB root to be operating in ARCHIVELOG mode. If the CDB is in NOARCHIVELOG mode, Oracle cannot generate the archived logs necessary to make the backup consistent, and the BACKUP TABLESPACE command will fail. Enabling ARCHIVELOG mode at the root level is the foundational prerequisite for any online RMAN backup of PDB tablespaces.

BTake the user data tablespace offline.

Taking a tablespace offline is necessary only for cold/offline backups; the RMAN BACKUP TABLESPACE command performs an online backup and does not require the tablespace to be offline.

CPlace the root container in the nomount stage.

The root container must be fully open with ARCHIVELOG mode enabled to support an online RMAN backup; placing it in nomount stage would prevent the backup from running at all.

DEnsure that HR_PDB is open.

While HR_PDB must also be open for an online tablespace backup, this alone is insufficient - the missing and more foundational prerequisite is ARCHIVELOG mode being enabled at the CDB level.

Concept tested: RMAN online PDB tablespace backup and ARCHIVELOG mode requirement

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/backing-up-cdb-tablespaces-and-data-files.html

Topics

#RMAN backup#multitenant#PDB#ARCHIVELOG mode

Community Discussion

No community discussion yet for this question.

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