Recovery Catalog   «Prev  Next»

Adding Information to the Oracle Recovery Catalog and Database Backup and Recovery

The recovery catalog stores a great deal of information about your backup and restore operations. Although you will rarely need to use the catalog command, you will use it to add information about your data file copies, archived log files, control files, and any other file that belongs to your target database. You must add this information to your recovery catalog for it to be considered by Recovery Manager (RMAN) in any recovery situation.
A vast amount of information may not be stored in the recovery catalog. For example, you may back up your database without Recovery Manager. If you then install Recovery Manager and a recovery catalog, these files will need to be inserted into the recovery catalog to be considered for restore operations.
Some installations perform operating-system-level backups. Because these are performed outside the scope of Recovery Manager, the recovery catalog has no knowledge of these backups. You would need to use the catalog command to add this information to your recovery catalog. Let us take a look at the basic syntax and some possible catalog commands.

catalog {datafilecopy, archivelog, backup, 
controlfilecopy} 'filename';

This command will update the recovery catalog with a data file copy.
catalog datafilecopy 'C:\backup\usrorc1_001.bak'
This command will update the recovery catalog with an archive log file.
catalog archivelog 'C:\backup\arch_0001.log'

This command will update the recovery catalog with a copy of the control file.
catalog controlfilecopy 'C:\backup\ctl1orc1.ora'

Oracle 11g: backup from standby host to primary host or vice versa

Note: You can transfer a backup from a standby host to a primary host or vice versa, connect as TARGET to the database on this host, and then use the CATALOG command to catalog the backup. After a file is cataloged by the target database, the file is associated with the target database.

You can use the CATALOG command to inspect an existing image copy and enter its metadata into the RMAN repository. However, the CATALOG command does not do the following:
  1. Read all blocks in the data file copy to ensure there are no corruptions
  2. Guarantee that the image copy was correctly made in backup mode
    After you catalog these files, you can use them with the RESTORE or SWITCH commands just as you can for RMAN-generated image copies.

Some sites store their datafiles on mirrored disk volumes, which permit the creation of image copies by breaking a mirror. After you have broken the mirror, you can notify RMAN of the existence of a new user-managed copy, thus making it eligible for a backup. You must notify RMAN when the copy is no longer available by using the


In the next lesson, you will learn how to re-create a recovery catalog.