Oracle Database Administration II — Question 30

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.)

Answer options

• A. Data file 24 can be recovered only while connected to PDB2.
• B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
• C. Data file 24 can be restored only while connected to CDB$ROOT.
• D. Data file 24 can be restored only while connected to PDB2.
• E. Data file 24 can be recovered while connected to PDB2.
• F. Data file 24 can be recovered while connected to CDB$ROOT.

Correct answer: B, E, F

Explanation

The correct statements are B, E, and F because data file 24 can be restored and recovered while connected to CDB$ROOT, utilizing the RMAN backup taken at that level. Option A is incorrect since recovery can occur from CDB$ROOT, and option C is wrong because restoration is also possible while in CDB$ROOT. Option D is incorrect as it limits restoration to PDB2 only.