Catalog Maintenance   «Prev  Next»

Register Resynch Reset - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statements are true about registering a target database in an RMAN recovery catalog?
Please select all the correct answers.
  A. Connecting a new primary target to a recovery catalog automatically registers it without a REGISTER DATABASE command.
  B. RMAN obtains the information needed for registration from the target database and records it in the recovery catalog.
  C. RMAN must be connected to the recovery catalog and to a target database that is mounted or open.
  D. RMAN assigns a new DBID to the target database during registration.

2. LIST INCARNATION OF DATABASE shows DB Key 100, prior Inc Key 1, current Inc Key 10, and DBID 1234567890. Which command selects the prior incarnation?
Please select the best answer.
  A. RESET DATABASE TO INCARNATION 1;
  B. RESET DATABASE TO INCARNATION 10;
  C. RESET DATABASE TO INCARNATION 100;
  D. RESET DATABASE TO INCARNATION 1234567890;

3. Which statement correctly describes the default RESYNC CATALOG operation?
Please select the best answer.
  A. It scans storage for unrecorded backup files and automatically catalogs them.
  B. It uses a snapshot control file for a read-consistent view and updates the recovery catalog from target control-file metadata.
  C. It removes recovery-catalog records for files that are missing from disk or tape.
  D. It replaces the target control-file repository with all metadata stored in the recovery catalog.

4. Which situations can justify an explicit RESYNC CATALOG operation?
Please select all the correct answers.
  A. The recovery catalog was unavailable while RMAN operations updated the target control-file repository.
  B. The target runs in ARCHIVELOG mode and the catalog needs current log history and archived redo log records.
  C. The target database physical structure changed and the catalog needs the updated schema metadata.
  D. Every catalog-aware backup completed successfully and automatic resynchronization already occurred.

5. When is RESET DATABASE TO INCARNATION required?
Please select the best answer.
  A. Before every database restore, regardless of the recovery destination.
  B. When restoring or recovering to an SCN before the current incarnation's RESETLOGS boundary, or flashing back to an orphaned incarnation.
  C. After every successful OPEN RESETLOGS so RMAN can create the new incarnation.
  D. Whenever a copied database needs a new DBID before registration.