Backup Options   «Prev  Next»

Recovering a NOARCHIVELOG Database - Quiz

Select the best answer or answers for each question.
1. After media failure, to which state can an Oracle 26ai NOARCHIVELOG database normally be restored and recovered?
Please select the best answer.
  A. Any point in time selected by the DBA
  B. The exact point at which the media failure occurred
  C. The latest usable consistent backup state, optionally advanced by applicable consistent incremental backups
  D. The current database state by applying online redo alone

2. Which are disadvantages or recovery limitations of operating a database in NOARCHIVELOG mode?
Please select all the correct answers.
  A. RMAN cannot be used to back up or restore the database.
  B. Committed work after the latest usable consistent backup chain may have to be reconstructed from another source.
  C. A whole-database backup requires a consistent shutdown and a mounted database, which creates an outage.
  D. After loss of a current datafile, the complete consistent database backup normally must be restored when the required redo is unavailable.

3. A media failure leaves the database instance running, but a clean shutdown cannot complete. Which command may be required before starting the instance in MOUNT state for restoration?
Please select the best answer.
  A. SHUTDOWN IMMEDIATE
  B. SHUTDOWN RESTRICTED
  C. SHUTDOWN ABORT
  D. SHUTDOWN RECOVERY

4. Which statements correctly describe an RMAN backup and recovery strategy for an Oracle 26ai NOARCHIVELOG database?
Please select all the correct answers.
  A. A database backup must be taken after a consistent shutdown while the database is mounted but not open.
  B. A consistent incremental level 0 backup can serve as the base for later consistent incremental backups.
  C. An online backup of active datafiles can be recovered without archived redo if the control file survives.
  D. The recovery plan must preserve access to required control-file metadata, backup media, and encryption material.

5. What is the purpose of RECOVER DATABASE NOREDO when recovering a NOARCHIVELOG database?
Please select the best answer.
  A. It applies applicable consistent incremental backups without attempting to apply archived redo logs.
  B. It reconstructs every committed transaction that occurred after the last backup.
  C. It converts an inconsistent online backup into a consistent backup.
  D. It validates backup pieces without restoring or recovering datafiles.