Oracle Database Administration II — Question 83

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

Answer options

• A. using the KEEP FOREVER clause with the BACKUP command
• B. using RMAN stored scripts
• C. using the REPORT SCHEMA command to list a database's current data files and tablespaces
• D. creating customized reports about a single database's backups
• E. creating encrypted backups
• F. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

Correct answer: A, B, F

Explanation

The RMAN recovery catalog is essential for features like the KEEP FOREVER clause, stored scripts, and reporting historical data about a database's files and tablespaces. Options C, D, and E do not require the catalog; the REPORT SCHEMA command for current data files and tablespaces, customized backup reports, and encrypted backups can be executed without it.