Oracle
1Z0-062 · Question #75
1Z0-062 Question #75: Real Exam Question with Answer & Explanation
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.
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.
Explanation
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.
Common mistakes.
- B. 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.
- C. 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.
- D. 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
Community Discussion
No community discussion yet for this question.