Backup Options   «Prev 

Recovering Control and File Read-only Tablespace - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. After control-file damage, which approaches can provide a usable control file when their respective prerequisites are satisfied?
Please select all the correct answers.
  A. With the instance stopped, replace a damaged copy from an intact current multiplexed control file and verify the configured destinations.
  B. Review previously generated control-file trace SQL against the actual database structure, then execute the appropriate CREATE CONTROLFILE statement.
  C. Restore a suitable binary control-file backup and follow the required mounting, recovery, and opening procedure.
  D. Recreate the control file using CREATE CONTROLFILE and a verified database inventory when no usable current copy or backup is available.
  E. Copy the text produced by ALTER DATABASE BACKUP CONTROLFILE TO TRACE directly into a configured binary control-file location.

2. In an ARCHIVELOG database with a usable current control file, STUDENT was backed up after becoming read-only. It later became read-write and received updates, but no newer backup was made. Its datafiles are now damaged. Assume the earlier backup, all required recovery changes, and repaired storage are available, and the files have been appropriately isolated. Which actions are required for complete tablespace recovery?
Please select all the correct answers.
  A. Restore the affected STUDENT datafiles from the usable earlier read-only backup.
  B. Restore the backup and return the tablespace online without applying the subsequent changes.
  C. Recover the restored files through the required state transition and subsequent writable period, then verify recovery before restoring access.
  D. Reject the earlier backup because a later READ WRITE transition automatically makes every read-only backup unusable.

3. You must use backup-control-file recovery. A healthy read-only tablespace resides on physically read-only or slow media and has not suffered media failure. Which alternatives does Oracle document to avoid unnecessary write attempts caused by historical tablespace-state information?
Please select all the correct answers. The alternatives need not both be performed.
  A. Take the healthy read-only datafiles offline before backup-control-file recovery, then bring them online after media recovery under the applicable procedure.
  B. Leave every read-only tablespace online because historical control-file state cannot affect recovery writes.
  C. Use an otherwise suitable control-file backup from a period matching the intended final tablespace state: read-only if recovery ends read-only, or read-write if it ends read-write.
  D. Immediately recreate the control file whenever one available backup records an earlier tablespace state.

4. With a usable current control file, when can a valid backup taken after a tablespace became read-only support restoration without redo application for the subsequent interval? Assume the supported file-isolation and restore prerequisites are met.
Please select the best answer.
  A. Whenever the tablespace is read-only at failure time, regardless of any intervening writable periods.
  B. When the READ ONLY transition completed before the backup and the tablespace remained read-only afterward.
  C. Whenever the tablespace was read-write at backup time but became read-only before the failure.
  D. When the control file has been recreated, regardless of the restored files and their state history.

5. A primary CDB has been successfully recovered using a restored backup control file. All required recovery has completed and opening prerequisites are satisfied. How must the database be opened?
Please select the best answer.
  A. Use ALTER DATABASE OPEN; because successful complete recovery always eliminates the RESETLOGS requirement.
  B. Issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE; instead of opening the database.
  C. Recreate the control file again before every open operation.
  D. Use ALTER DATABASE OPEN RESETLOGS; because recovery used a restored backup control file.