Backup Options   «Prev 

 

Recovering Control and File Read-only Tablespace - Quiz

Recovering Control file and read-only tablespace

Each question is worth one point. Select the best answer or answers for each question.
1. If the control file is damaged, which of the following methods will recreate the control file?
Please select all the correct answers.
  A. Restore the control file by copying the mirrored control file if you have one
  B. Use the backup made via the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
  C. Use the backup made via the ALTER DATABASE BACKUP CONTROLFILE TO <filename> command
  D. Recreate the control file manually by issuing the CREATE CONTROLFILE command with the appropriate options

2. Suppose you made a backup after the tablespace STUDENT was changed to read-only. At a later time, you changed it back to read-write, but you did not make a backup after this change. Now this tablespace is damaged in a media failure and needs recovery. Which of the following are steps you need to take to recover the tablespace?
Please select all the correct answers.
  A. Restore the datafiles belonging to the tablespace STUDENT from the backup
  B. Recover the tablespace by applying logs up to the time that the tablespace was made read-only
  C. Recover the tablespace by applying logs from the time the tablespace was made read-write
  D. Restore the backup datafiles belonging to the tablespace STUDENT when it was read-write

3. What should you pay attention to when you perform a recovery via the USING BACKUP CONTROLFILE option and you have a read-only tablespace in your database?
Please select all the correct answers.
  A. Take the read-only tablespace offline before you start the recovery to avoid error messages
  B. The status of the tablespace recorded in the controlfile can be either READ WRITE or READ ONLY.
  C. Match the backup control file to the state of the read-only tablespace you are recovering to.
  D. Recreate the control file if you do not have the appropriate backup