Backup Options   «Prev  Next»

Minimizing Database Downtime[for recovery] - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is the principal purpose of parallel media recovery in Oracle AI Database 26ai?
Please select the best answer.
  A. Require every recovery worker to write to a different physical disk.
  B. Require multiple datafiles so that each worker owns exactly one file.
  C. Allow recovery to omit required redo logs.
  D. Reduce eligible recovery time by distributing redo-apply work among recovery processes.

2. An ARCHIVELOG CDB has a healthy open root and a mounted application PDB. One ordinary application datafile in that PDB is missing. The current control file, usable backups, all required redo, and repaired storage are available. All other opening requirements are satisfied. Which statements describe the supported offline-file recovery approach?
Please select all the correct answers.
  A. The same approach can be used without further assessment for a missing SYSTEM or required active undo datafile.
  B. Take the verified application datafile offline in its owning PDB before opening that PDB for access to unaffected data.
  C. Restore and recover the offline file, verify successful recovery, and return it online; objects dependent on that file remain unavailable until then.
  D. Use this approach even if every current control-file copy is missing, without first establishing a usable control file.

3. For an appropriate whole-CDB media recovery operation in RMAN, connected to the root with the CDB mounted and required files restored, which are supported ways to request parallel media recovery? Assume all recovery prerequisites are satisfied.
Please select all the correct answers. The choices are alternatives, not consecutive commands.
  A. Issue RECOVER DATABASE; and use the default parallel media recovery behavior.
  B. Issue RECOVER DATABASE PARALLEL 2; to request an explicit degree for that operation.
  C. Start several independent client sessions and recover the same files concurrently to create the recovery workers manually.
  D. Set RECOVERY_PARALLELISM to select the degree of RMAN media recovery.

4. Recovery testing shows that retrieving and restoring backup pieces consumes most of the outage, while redo application is brief. What is the best next step to reduce downtime?
Please select the best answer.
  A. Increase the redo-apply degree to the largest possible value without measuring resource use.
  B. Assume that doubling RMAN channels must halve the entire outage.
  C. Investigate backup retrieval and restore bottlenecks, then test appropriate channel and storage changes using comparable workloads.
  D. Omit required redo application so the restored files can be used immediately.

5. Which statements correctly describe how multiplexing control files and online redo members can reduce recovery disruption?
Please select all the correct answers.
  A. If one online redo member fails and another usable member in the group remains, LGWR can continue writing to the usable member while the DBA plans the supported repair.
  B. Losing a configured control-file copy never stops an instance as long as another copy exists.
  C. An intact current control-file copy can be used to replace a failed copy with the instance stopped, potentially avoiding restoration of older control-file metadata.
  D. Multiplexing removes the need for backups and guarantees that copies on different drive letters cannot fail together.