Recovery with Archiving  «Prev 

Complete Database Recovery - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. An open, single-instance CDB is running in NOARCHIVELOG mode. A pre-change backup and archive-destination preparation are complete. Using a suitably privileged connection to CDB$ROOT, which sequence changes the mode and takes a new RMAN backup of the database and current control file before reopening the CDB?
Please select the best answer.
  A. STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; take the new backup; ALTER DATABASE OPEN
  B. SHUTDOWN IMMEDIATE; STARTUP MOUNT; take the new backup; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN
  C. ALTER DATABASE ARCHIVELOG while the CDB is open; take the new backup; SHUTDOWN IMMEDIATE
  D. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; take the new RMAN backup of the database and current control file while mounted; ALTER DATABASE OPEN

2. An ARCHIVELOG CDB has one datafile in its root SYSTEM tablespace. That file suffers physical damage requiring restoration. A usable online backup exists, the current control file and other datafiles are intact, and all required archived and online redo are available. Which approach achieves complete recovery of the damaged file?
Please select the best answer.
  A. With the CDB mounted and not open, restore only the damaged SYSTEM datafile, perform complete media recovery using all required recovery information, including archived and surviving online redo as needed, and open normally after recovery succeeds.
  B. Issue ALTER DATABASE ARCHIVELOG to reconstruct the damaged file.
  C. Restore every datafile from the online backup and open the CDB without applying recovery information.
  D. Perform whole-CDB point-in-time recovery to an earlier target, discarding later changes even though complete recovery is possible.

3. In an ARCHIVELOG CDB, only two permanent user datafiles are lost. The current control file, startup configuration, other datafiles, and required redo remain usable, and suitable backups exist. Which restore action is normally appropriate for complete recovery of the lost files?
Please select the best answer.
  A. Restore every datafile, the control file, and the server parameter file, including undamaged files.
  B. Restore all online redo log members from backup instead of restoring the lost datafiles.
  C. Restore only the lost datafiles, then recover them using the required recovery information.
  D. Restore only archived redo logs without restoring or otherwise reconstructing the lost datafiles.

4. You are performing complete media recovery of an eligible permanent user datafile while its CDB and PDB remain open in ARCHIVELOG mode. Before restoring a backup over the affected file, what must you verify?
Please select the best answer.
  A. The entire CDB has been shut down with SHUTDOWN ABORT.
  B. The affected datafile is offline, either individually or because its tablespace is offline.
  C. The affected datafile remains online so applications can access it during replacement.
  D. Flashback Database has been enabled to permit restoration of the datafile.