Incomplete Recovery   «Prev 

Concepts about Incomplete Recovery - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statements correctly describe incomplete recovery of a whole container database (CDB) in Oracle AI Database 26ai?
Please select all the correct answers.
  A. Committed changes later than the recovered point are excluded from the recovered database, including valid changes made after that point.
  B. After successful whole-CDB incomplete media recovery, the CDB must be opened with RESETLOGS.
  C. RMAN supports recovery boundaries based on time, SCN, or redo log sequence; SQL*Plus also supports cancel-based media recovery.
  D. Incomplete recovery inherently leaves the recovered database inconsistent and disables its integrity constraints.

2. Which statements about ARCHIVELOG mode in Oracle AI Database 26ai are correct? Assume that usable backups and the redo required for the recovery examples are available.
Please select all the correct answers.
  A. An ordinary application datafile can be taken offline, restored, completely recovered, and returned online while the CDB and unaffected tablespaces remain open.
  B. The whole CDB can be restored and recovered to an earlier point using a supported incomplete-recovery method.
  C. ARCHIVELOG mode means that filled online redo logs are always archived automatically, regardless of the archiving configuration.
  D. RMAN can back up the database while it is open and applications are using it.

3. After successful whole-CDB incomplete media recovery followed by ALTER DATABASE OPEN RESETLOGS, which statement is true?
Please select the best answer.
  A. The database system change number (SCN) is reset to 1.
  B. A new database incarnation begins, and redo log sequence numbering restarts at 1.
  C. All datafile backups taken before RESETLOGS become unusable for any subsequent RMAN recovery.
  D. The current control file must always be recreated manually before applications can reconnect.

4. A physical media failure damages the only datafile of the CDB root SYSTEM tablespace. The CDB is in ARCHIVELOG mode. A usable backup of that datafile predates the failure, the current control file and SPFILE are intact, and all required archived and online redo is available. Which action best recovers the database without losing committed changes?
Please select the best answer.
  A. Mount the CDB, restore the damaged datafile, perform complete media recovery using all required redo, and then open the database normally.
  B. Issue ALTER DATABASE ARCHIVELOG to repair the damaged datafile.
  C. Restore the entire database from its last online backup and open it without performing media recovery.
  D. Perform whole-CDB point-in-time recovery to an earlier time and open with RESETLOGS.

5. RMAN must restore datafiles from a parent-incarnation backup and recover into the current incarnation across an earlier OPEN RESETLOGS. Which resources are required for this recovery?
Please select all the correct answers.
  A. Usable datafile backups from the appropriate parent incarnation on the current database incarnation path.
  B. All archived redo logs needed from the selected backup through the RESETLOGS boundary and onward to the recovery target, plus any other redo required to reach that target.
  C. A whole closed-database backup taken after the earlier RESETLOGS operation.
  D. A usable control file and complete relevant incarnation history accessible to RMAN.
  E. Two separate control file backups, one taken immediately before and one immediately after the earlier RESETLOGS operation.
  F. An alert log containing recovery SCNs, which can replace an irretrievably missing archived redo log required for recovery.

6. You plan fully automated RMAN tablespace point-in-time recovery (TSPITR) for an eligible, self-contained set of application tablespaces in one PDB of an ARCHIVELOG CDB. Which preparations are required?
Please select all the correct answers.
  A. Manually create and open a complete clone of the current CDB before starting automated TSPITR.
  B. Provide sufficient storage and memory for the auxiliary instance, restored files, and recovery work.
  C. Verify usable backups for the recovery and auxiliary sets, including the required CDB root and PDB$SEED backups, and all redo needed to reach the chosen target.
  D. Create a new backup of the current control file immediately before every TSPITR operation.