1Z0-083 practice question 5 of 35
Choose three. Which three capabilities require the use of the RMAN recovery catalog?
Full set: 286 questionsA 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.
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.
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.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
- Question 7Choose two. Which two are true about the automatic execution of operating system scripts …
