Recovery Catalog

Recovery Catalog is a database schema that contains RMAN metadata for a set of target databases. Recovery catalog needs separate database or we can create one of the databases on the server. For creating catalog follow these steps.

On the Remote Database (Catalog Database): 

1. Create a user and grant connect,resource and recovery_catalog_owner privileges.
2. Create a tablespace or make a tablespace as default to the user and give unlimited quota on the tablespace.
3. Create a listener in Catalog database and TNS in target database.

On the Target Database (Local Database):

1. Connect to rman target database as $rman target / catalog rcat/rcat@tns
2. Create catalog as rman>create catalog;
3. Register database as rman>register database;
4. Then take the backup RMAN metadata will be stored in the Catalog Database which we have created.