My Oracle Support Banner

Demystifying the RMAN Recovery Catalog (Doc ID 1362501.1)

Last updated on MAY 13, 2020

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

******************************************************************************

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner. For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Oracle SID - Database Release
------------------------------------
RCAT - 11.2.0.3 database
ORA112 - 11.2.0.3 database
ORA102 - 10.2.0.5 database

******************************************************************************

What is the function of the recovery catalog?

'What are the advantages and disadvantages of having a recovery catalog?

Why do you need an RMAN recovery catalog when backups are first written to the controlfile, then resync'd to the catalog anyway?

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1. What is the RMAN Catalog Schema, Repository and Database?
 2. Why Do You Need a Recovery Catalog?
 2.1 Long Retention Period
 2.2 Report schema as at a certain date
 2.3 RMAN Stored Scripts
 2.4 Dataguard Configuration
 3. What are the Disk Space and Memory Requirements?
 3.1 Backup Considerations
 3.2 Performance Considerations
 4. Implicit vs Explicit Resync
 5. How Do You Create The Recovery Catalog?
 6. Does a Target Upgrade also Mean a Catalog Upgrade?
 6.1 Which RMAN Executable to Use
 7. How do you Upgrade the RMAN Catalog?
 8. When Not to Use a Recovery Catalog
 8. 1 Test Restore
 8.2 Network Issues
 8.3 Catalog Issues
 9. Can You Query the RMAN Backend Views?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.