nerdexam
Oracle

1Z0-060 · Question #82

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…

The correct answer is A. Place the root container in ARHCHIVELOG mode. RMAN online tablespace backups require the CDB root container to be in ARCHIVELOG mode so archived redo logs are available to recover the backup to a consistent state.

New Features for Availability

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

(14 responses)
  • A
    71% (10)
  • B
    14% (2)
  • C
    7% (1)
  • D
    7% (1)

Why each option

RMAN online tablespace backups require the CDB root container to be in ARCHIVELOG mode so archived redo logs are available to recover the backup to a consistent state.

APlace the root container in ARHCHIVELOG mode.Correct

For RMAN to perform an online hot backup of a tablespace within any PDB, the root container of the CDB must be in ARCHIVELOG mode. ARCHIVELOG mode ensures redo data is preserved in archived logs, which RMAN uses to roll the backup forward to a transactionally consistent point; without it, online tablespace backups cannot proceed and the BACKUP TABLESPACE command will fail.

BTake the user data tablespace offline.

Taking the tablespace offline is a prerequisite for user-managed cold backups, not for RMAN online backups, which are explicitly designed to operate while the tablespace remains online.

CPlace the root container in the nomount stage.

The NOMOUNT stage is used when restoring or recreating a control file or SPFILE, not as a prerequisite for backing up a tablespace in an open, running database.

DEnsure that HR_PDB is open.

Although HR_PDB must be open for a PDB tablespace backup, ARCHIVELOG mode on the root container is the foundational prerequisite that is the most likely missing condition implied by the scenario.

Concept tested: RMAN PDB tablespace backup ARCHIVELOG mode requirement

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/backing-up-pluggable-databases.html

Topics

#RMAN backup#CDB PDB backup#ARCHIVELOG mode#tablespace backup

Community Discussion

No community discussion yet for this question.

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