Incomplete Recovery   «Prev  Next»

Recovery Through Control File in Oracle - Quiz

This quiz discusses 1) recovery without current redo logs and 2) recovery through the control file Each question is worth one point. Select the best answer or answers for each question.
 
1. In which of the following situations do you need to perform recovery with a backup control file?
Please select all the correct answers.
  A. An important table with thousands of rows of data was dropped.
  B. Some of the archived logs needed for recovery are damaged.
  C. The current control file is lost and there is a backup of the older control file.
  D. A tablespace containing an important table was dropped.

2. Which of the following are true about recovery with a backup control file?
Please select all the correct answers.
  A. You must put offline datafiles online before issuing the recovery command.
  B. At the end of the process, you have to reissue the recovery command using the current control file.
  C. You must combine this method with time-based, cancel-based, or change-based recovery.
  D. You must perform a backup of the current control file before issuing the recovery command.

3. When the current redo log is lost, the database could be:
Please select all the correct answers.
  A. Still open, but only in a restricted mode
  B. Still open, but not functioning properly
  C. Closed due to media failure
  D. Closed yet in a "hung" state

4. What do you need to do to fix the open database in the "hung" state after the current redo log is lost?
Please select all the correct answers.
  A. Determine which log file is the current one
  B. Perform an incomplete recovery
  C. Recreate the lost online redo log
  D. Clear the damaged or lost current redo log