1Z0-083 practice question 5 of 35

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

Full set: 286 questions
Answer options
A: using RMAN stored scripts Correct answer
B: creating encrypted backups
C: creating customized reports about a single database's backups
D: using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past Correct answer
E: using the KEEP FOREVER clause with the BACKUP command Correct answer
F: using the REPORT SCHEMA command to list a database's current data files and tablespaces
Correct Answer:
A. using RMAN stored scripts; D. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past; E. using the KEEP FOREVER clause with the BACKUP command
Explanation

A recovery catalog is a centralized metadata repository that extends RMAN's capabilities beyond what is stored in a target database's control file. Three key features that specifically require a catalog are: using RMAN stored scripts (A), which are defined and saved within the catalog itself; using the REPORT SCHEMA command with an AT TIME or AT SCN clause (D) to see the database structure at a past point in time, as the control file only tracks the current schema; and using the KEEP FOREVER clause (E) to create long-term archival backups that are exempt from the retention policy, which requires the persistent storage of the catalog.

Why Incorrect

B. Creating encrypted backups is a function of the Oracle Advanced Security Option and is managed by RMAN regardless of catalog use.
C. RMAN can generate comprehensive reports for a single database using only the metadata stored in its control file.
F. Reporting the current database schema (REPORT SCHEMA) is a standard operation that reads directly from the target database's control file.

References

1. Oracle Database Backup and Recovery User's Guide 19c, "Managing RMAN Stored Scripts". It states, "A stored script is a sequence of RMAN commands that is stored in the recovery catalog." This supports A.

2. Oracle Database Backup and Recovery User's Guide 19c, "Overview of RMAN Reporting". It mentions that REPORT SCHEMA AT TIME requires a recovery catalog to access historical metadata not present in the control file. This supports D.

3. Oracle Database Backup and Recovery Reference 19c, "BACKUP". In the description of the KEEP clause, it states, "You must use a recovery catalog when you specify KEEP FOREVER." This supports E.

Scroll to Top