Backup Options   «Prev 

Infrequent Recovery Situations and Redo Log Maintenance - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Media failure destroys the only datafile of EMPLOYEE_HISTORY, an ordinary permanent tablespace created locally two days ago in an ARCHIVELOG database. There is no datafile backup. The current control file records the file, all changes were fully logged, and all required redo since file creation is available. Which recovery approach can reconstruct its contents?
Please select the best answer.
  A. Open the database with RESETLOGS without applying redo.
  B. Re-create the missing datafile and recover it using the complete required redo chain.
  C. Create an empty replacement tablespace and assume the previous rows are restored.
  D. Run END BACKUP to reconstruct the lost file.

2. For user-managed recovery of an ordinary application datafile with no backup, the database remains open in ARCHIVELOG mode. The control file records the file, all required redo exists, and there were no unrecoverable NOLOGGING changes. Which are valid steps? Assume suitable privileges and the correct container.
Please select all the correct answers.
  A. Take the affected datafile offline before re-creating it.
  B. Copy the datafile from a backup that does not exist.
  C. Use ALTER DATABASE CREATE DATAFILE with an AS clause to re-create the file at an appropriate replacement location.
  D. Apply all required redo from file creation through the recovery endpoint before bringing the recovered file online.

3. An approved repair successfully executes ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3 for a damaged INACTIVE group. No other copy of that redo exists, and no offline datafile needs it to return online. Which statements are correct?
Please select all the correct answers.
  A. The group is reinitialized without first archiving its contents.
  B. The command creates an archived copy of the lost sequence.
  C. Recovery to every earlier point becomes impossible.
  D. Backups that require the cleared sequence cannot support complete recovery through that missing redo.

4. A power outage interrupts a user-managed BEGIN BACKUP operation. The CDB is now mounted but cannot open because files remain in backup mode. All current datafiles and the control file are intact, none were restored, and required redo is available. Which are alternative ways to resolve the backup-mode condition before opening?
Please select all the correct answers.
  A. Use SQL*Plus RECOVER DATABASE to perform complete recovery.
  B. Drop the affected tablespaces.
  C. Open immediately with RESETLOGS to bypass backup mode.
  D. Issue ALTER DATABASE END BACKUP while mounted, using an authorized connection to CDB$ROOT.

5. Which two views respectively contain per-datafile status for a RECOVER statement and statistics of the current recovery process, with useful information restricted to the Oracle process performing recovery?
Please select all the correct answers.
  A. V$RECOVERY_PROGRESS
  B. V$RECOVERY_FILE_STATUS
  C. V$RECOVER_FILE
  D. V$RECOVERY_STATUS