Backup Options   «Prev  Next»

Recovering the Database with inactive Redo Logs - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statements about ALTER DATABASE CLEAR LOGFILE are correct?
Please select all the correct answers.
  A. It reconstructs missing redo required for recovery.
  B. It reinitializes an online redo log group without requiring the group to be dropped and added again.
  C. It can be used when only two redo log groups exist for the thread, provided clearing restrictions are satisfied.
  D. It can always clear the current log immediately, regardless of recovery requirements.

2. A media failure damages online redo. Which findings establish that the redo in the affected log sequence remains available from another copy? Assume no other damage.
Please select all the correct answers.
  A. The affected group has STATUS = INACTIVE, with no other information.
  B. A complete, valid, accessible archived copy of the affected sequence has been verified.
  C. Multiplexing was configured, but every member of the affected group was destroyed.
  D. Another valid, accessible member of the same group contains the affected sequence.

3. What does STATUS = INACTIVE in V$LOG mean?
Please select the best answer.
  A. The group has necessarily been archived.
  B. The group is no longer needed for instance recovery, but its redo may still be needed for media recovery.
  C. The group contains only uncommitted transactions.
  D. The group is the one LGWR is currently writing.

4. All members of group 3 are corrupt. The group is INACTIVE, its archived copy is verified usable, and no recovery requires the damaged online copies. Storage is repaired. Which command reinitializes the group? Assume an authorized connection to CDB$ROOT.
Please select the best answer.
  A. ALTER DATABASE OPEN RESETLOGS;
  B. ALTER SYSTEM SWITCH LOGFILE;
  C. ALTER DATABASE CLEAR LOGFILE GROUP 3;
  D. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

5. An approved repair clears a damaged INACTIVE, unarchived group using CLEAR UNARCHIVED LOGFILE. No other copy of its redo exists. Which statements describe the consequences and follow-up?
Please select all the correct answers.
  A. Older backups that require the missing sequence cannot support complete recovery through that gap.
  B. Oracle automatically reconstructs the cleared sequence from current datafiles.
  C. Every earlier backup is permanently unusable for every recovery target.
  D. Take a new database backup and back up the control file after the repair.