nerdexam
Oracle

1Z0-083 · Question #13

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to…

The correct answer is B. Data file 24 can be restored and recovered while connected to CDB$ROOT. E. Data file 24 can be recovered while connected to PDB2. F. Data file 24 can be recovered while connected to CDB$ROOT. Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question. https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb- 12cr1#tablespace-and-datafile-backups

Perform Backup and Recovery

Question

A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it. The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT. Which three are true? (Choose three.)

Options

  • AData file 24 can be recovered only while connected to PDB2.
  • BData file 24 can be restored and recovered while connected to CDB$ROOT.
  • CData file 24 can be restored only while connected to CDB$ROOT.
  • DData file 24 can be restored only while connected to PDB2.
  • EData file 24 can be recovered while connected to PDB2.
  • FData file 24 can be recovered while connected to CDB$ROOT.

How the community answered

(59 responses)
  • A
    3% (2)
  • B
    81% (48)
  • C
    3% (2)
  • D
    12% (7)

Explanation

Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question. https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb- 12cr1#tablespace-and-datafile-backups

Topics

#CDB recovery#PDB data file restore#shared undo#RMAN CDB backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice