Catalog Maintenance   «Prev  Next»

Recovery Catalog Maintenance - Quiz

Each question is worth one point. Select the best answers for each question.
1. In a Linux or Unix shell, which statements are true about rman TARGET '"backup_admin@prodcdb AS SYSBACKUP"' CATALOG rco@catpdb LOG /var/log/oracle/rman/catalog-maintenance.log APPEND?
Please select all the correct answers.
  A. RMAN connects to the target service prodcdb as SYSBACKUP and prompts for its password.
  B. RMAN connects to the catalog as rco@catpdb and prompts for the catalog password.
  C. RMAN appends new output to the named message log instead of overwriting that file.
  D. RMAN automatically duplicates all command output to both the terminal and the named log file.

2. An RMAN data-file copy was manually removed from disk outside RMAN. Which statements describe the correct repository maintenance?
Please select all the correct answers.
  A. CROSSCHECK can change the inaccessible copy's repository status from AVAILABLE to EXPIRED.
  B. After investigating temporary storage problems, DELETE EXPIRED can remove the confirmed expired record.
  C. VALIDATE reconciles the repository with disk and removes the missing-file record.
  D. CHANGE ... DELETE is the current command for removing the record after an operating-system deletion.

3. Which statement correctly distinguishes RESYNC CATALOG from CROSSCHECK?
Please select the best answer.
  A. RESYNC CATALOG transfers RMAN metadata from a target control-file source, while CROSSCHECK tests whether recorded objects are accessible through their device type.
  B. RESYNC CATALOG scans storage for unknown files, while CROSSCHECK registers them.
  C. RESYNC CATALOG reads every backup block, while CROSSCHECK repairs corrupt blocks.
  D. The two commands perform the same operation, but CROSSCHECK is the newer syntax.

4. What is the primary effect of RESET DATABASE TO INCARNATION?
Please select the best answer.
  A. It creates a new DBID for the target database.
  B. It selects an existing previous database incarnation in the RMAN repository for subsequent recovery work.
  C. It restores and recovers the database and then opens it with RESETLOGS.
  D. It removes every target database record from the recovery catalog.

5. Which statement correctly compares VALIDATE BACKUPSET with CROSSCHECK?
Please select the best answer.
  A. CROSSCHECK reads every backup block, while VALIDATE BACKUPSET checks only the file header.
  B. VALIDATE BACKUPSET marks missing repository records EXPIRED and deletes them.
  C. VALIDATE BACKUPSET reads every block in the selected set to assess restorability, while CROSSCHECK checks accessibility through disk headers or the media manager.
  D. Both commands prove that the complete database can meet its recovery-point and recovery-time objectives.