Recovery with Archiving  «Prev  Next»

Oracle Database Recovery Basics - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. An ARCHIVELOG database has lost datafiles in a media failure. The current control file and server parameter file are intact. To restore the lost datafiles from backup and perform complete media recovery, which resources are required?
Please select all the correct answers.
  A. A datafile backup that predates an interval of NOARCHIVELOG operation whose required redo has been overwritten and is no longer available
  B. Every historical backup copy of the control files and parameter files
  C. Usable backups of the lost datafiles that provide a valid starting point for recovery
  D. All redo required to recover the restored datafiles through the time of failure, including the necessary archived redo logs and online redo logs

2. A media failure has permanently destroyed datafiles in the CDB root SYSTEM tablespace and datafiles containing active undo segments. Valid backups and all required redo are available. Which recovery approach should you use?
Please select the best answer.
  A. Re-create the lost SYSTEM datafiles without restoring a backup
  B. Keep the database open and recover the affected datafiles online
  C. Open the database first, then restore and recover the affected datafiles
  D. Restore and recover the affected datafiles with the database mounted but not open

3. In SQL*Plus, connected to the CDB root of a primary database, which recovery commands require the database to be mounted but not open? Assume USERS is an ordinary user tablespace and the example datafile belongs to it.
Please select all the correct answers.
  A. RECOVER AUTOMATIC TABLESPACE users
  B. RECOVER AUTOMATIC DATAFILE '/oradata/users01.dbf'
  C. RECOVER DATABASE
  D. RECOVER FROM '/archive_location/' DATABASE

4. Which dynamic performance view contains recovery-process-specific information about archived redo logs needed to complete media recovery?
Please select the best answer.
  A. V$RECOVER_FILE
  B. V$ARCHIVED_LOG
  C. V$RECOVERY_LOG
  D. V$LOG_HISTORY