Introduction to Oracle Recovery Catalog Maintenance Basics
The basic concepts of (RMAN) Recovery Manager and how to create a recovery catalog were previously discussed.
This lesson will discuss the commands you will encounter when performing basic maintenance on your recovery catalog.
Furthermore, you will learn how to start Recovery Manager with and without a recovery catalog and basic maintenance commands that you can use on the recovery catalog.
In the module, you will learn to:
Issue the command to start RMAN
Demonstrate how to start RMAN without a recovery catalog
Register a target database into your recovery catalog
Discuss the use of the
Demonstrate how to resynchronize a target database using the
Identify other situations where the
resynch command is needed
change command to alter the information in your recovery catalog
delete command to remove data from your recovery catalog and the
validate command to check the validity of your
You will find that the information presented in this module will be used infrequently. Some commands will be executed once or twice,
while others not at all. You need to know this information for those infrequent times, and you will be tested on this information during the database administrator Oracle certification exams.
In the next lesson, you will learn about starting RMAN with a recovery catalog.
Recovery Catalog Maintenance
Use of the recovery catalog involves some additional maintenance activities, which include upgrading the catalog during a database upgrade or migration, manually resetting
the database incarnation, and resynchronizing the recovery catalog after certain database operations. This section describes those activities, as well as other maintenance
considerations, including removing a database from the recovery catalog and using the Oracle EXP/IMP utilities to back up the recovery catalog. Finally, this section reviews the
different recovery catalog views and what they are used for.
Unregistering a Database in RMAN
Prior to Oracle Database 10g, unregistering a database from the recovery catalog was a manual process.
Now, Oracle makes removing a database from the recovery catalog as easy as issuing the command unregister database. Here is an example:
RMAN> Unregister database mydb;
When this command is executed, the metadata for the database in the recovery catalog is removed completely. Also, any metadata older than
CONTROL_FILE_RECORD_KEEP time is removed from the control file. All local scripts for that database will also be removed from the recovery catalog.