Oracle
1Z0-083 · Question #66
Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)
The correct answer is A. It can be recovered while CDB while PDB2 is opened, as it belongs to PDB1. C. the datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state. Datafile 24 belongs to PDB1.
Perform Backup and Recovery
Question
Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true? (Choose two.)
Exhibits
Options
- AIt can be recovered while CDB while PDB2 is opened, as it belongs to PDB1.
- BData file 24 must be recovered while the CDB is opened.
- Cthe datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state.
- DData file 24 cannot be recovered while the CDB is opened.
- EData file 24 must be recovered while PDB2 is closed.
How the community answered
(26 responses)- A81% (21)
- B4% (1)
- D4% (1)
- E12% (3)
Explanation
Datafile 24 belongs to PDB1.
Topics
#PDB recovery#data file recovery#CDB mount state#multitenant recovery
Community Discussion
No community discussion yet for this question.

