Backup Options   «Prev  Next»

Infrequent Recovery Situations - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. An ARCHIVELOG database loses a datafile from an ordinary USERS tablespace. The file was created in this database, was never backed up, and is recorded in the current control file. Assume all changes were fully logged. Which condition permits RMAN to reconstruct the file and completely recover it?
Please select the best answer.
  A. Only the current online redo log is available, even though earlier required logs have been overwritten.
  B. All required redo from file creation through the recovery endpoint is available, including archived and any required online redo.
  C. A required archived log is missing and no other copy or recovery source exists.
  D. An empty replacement file is created, without applying redo.

2. Which dynamic performance view shows whether online datafiles are currently in user-managed backup mode after BEGIN BACKUP?
Please select the best answer.
  A. V$BACKUP_DATAFILE
  B. V$RECOVER_FILE
  C. V$BACKUP
  D. V$BACKUP_REDOLOG

3. An ARCHIVELOG database has halted. Flashback Database and standby failover are unavailable. Which situation requires restoring suitable backups and performing incomplete recovery because complete recovery cannot be achieved?
Please select the best answer.
  A. One redo member is lost, but another valid member in the same group preserves all required redo.
  B. A read/write datafile is lost, but its backup and all redo needed for complete recovery are available.
  C. All members of an unarchived current redo group are permanently lost, its redo is required for recovery, and no other copy exists; backups and redo support recovery to an earlier consistent point.
  D. A control-file copy is lost, but an intact current multiplexed copy remains and all datafiles and redo logs are intact.

4. A query of V$BACKUP returns STATUS = NOT ACTIVE for an online datafile. What can you conclude from this value alone?
Please select the best answer.
  A. The datafile is not currently in user-managed backup mode.
  B. The datafile has never been backed up.
  C. The latest RMAN backup failed.
  D. A valid backup exists and has passed a restore test.

5. All current control-file copies are lost. You restore a backup control file with RMAN, and all redo needed for complete recovery is available. What must you do before returning the database to normal use?
Please select the best answer.
  A. Open immediately without recovery because the datafiles are intact.
  B. Recover the database and always open with NORESETLOGS.
  C. Clear every online redo log group before attempting recovery.
  D. Recover the database and then open with RESETLOGS, even if recovery applies all required redo.