Incomplete Recovery   «Prev  Next»

Basic Concepts Incomplete Recovery[Backup] - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which situations may justify restoring backups and performing incomplete recovery of an ARCHIVELOG CDB? Assume that suitable earlier backups and the recovery information needed to reach a consistent earlier target are available.
Please select all the correct answers.
  A. Accidental logical changes must be reversed, and suitable Flashback or more targeted recovery options are unavailable.
  B. An archived redo log required for complete recovery is corrupt, and no usable copy or other recovery source can supply the required changes.
  C. Only the startup parameter file is damaged; the datafiles, control file, and required redo remain usable.
  D. All usable copies of current unarchived redo required for complete recovery are irretrievably lost.

2. Which scenario provides the clearest basis for selecting time-based whole-CDB recovery?
Please select the best answer.
  A. One member of a multiplexed redo log group has failed, but another valid member remains available and database processing continues.
  B. The SPFILE is damaged, while the database files and required redo remain intact.
  C. The last usable redo log sequence is known, but no recovery timestamp has been established.
  D. Whole-CDB point-in-time recovery has been selected after a logical error, and a target timestamp before the first unwanted change has been verified.

3. Which statements are correct for ordinary RMAN whole-CDB point-in-time recovery using datafile backups and redo?
Please select all the correct answers.
  A. The CDB must be in ARCHIVELOG mode, and its restore and recovery are performed with the CDB mounted rather than open.
  B. The restore must use backups suitable for the selected target, and the required recovery information must be available to recover the necessary datafiles to that target.
  C. The entire CDB remains open for normal application updates while its datafiles are restored and recovered to an earlier point.
  D. A newly completed whole-database backup immediately before recovery and another immediately after recovery are mandatory for every operation.

4. In an RMAN RUN block, SET UNTIL SCN 1418901 is issued before RESTORE DATABASE and RECOVER DATABASE. How is this recovery boundary interpreted?
Please select the best answer.
  A. Recovery includes changes at SCN 1418901 and stops immediately afterward.
  B. SCN 1418901 is an exclusive upper boundary, so recovery stops before changes at that SCN.
  C. The database SCN is reset to 1 when recovery reaches SCN 1418901.
  D. Only the archived redo log whose sequence number is 1418901 is applied.

5. Which actions help an authorized DBA monitor and verify whole-CDB RMAN point-in-time recovery from a separate administrative session?
Please select all the correct answers.
  A. Correlate RMAN output with alert-log timestamps, redo file names, thread and sequence information, and reported errors.
  B. Check available media recovery metrics in V$RECOVERY_PROGRESS and progress for instrumented RMAN operations in V$SESSION_LONGOPS.
  C. Treat a media recovery completion message as proof that the CDB and all PDBs are open and application data is correct.
  D. After successful recovery and OPEN RESETLOGS, verify the recovered application data and the required CDB and PDB open states.