Configuring RMAN Recovery Catalog Using Enterprise Manager DB Console

1)  Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example:

$ sqlplus '/ as sysdba'

SQL> CREATE USER rman IDENTIFIED BY rman
DEFAULT TABLESPACE apps_ts_tools
TEMPORARY TABLESPACE temp1
QUOTA UNLIMITED ON apps_ts_tools;

SQL> GRANT CONNECT, RECOVERY_CATALOG_OWNER TO rman;

2)  Creating the Recovery Catalog

Log in to rman and create the catalog schema.Look at this example:

In the below example " prod " is the catalog database connection string. Before creating the recovery catalog make sure to have the tnsnames.ora entry for the catalog database in the target server and the listener must be up and running in the catalog database server.You must be able to connect to the catalog database from sqlplus from the target server.

$ rman catalog rman/rman@prod

RMAN> CREATE CATALOG;

The catalog should be created manually before configuring the recovery catalog through EM.

3)  Login to Enterprise manager dbconsole as SYSDBA user

4)  Recovery catalog can be configured using the RECOVERY CATALOG SETTINGS tab.

The Navigation path is :
-> Availability
-> Backup/Recovery
-> Recovery Catalog Settings

5)  Click on ADD RECOVERY CATALOG and provide the below information

   Host :  yourhost.yourdomain
   Port : 1521
   SID : PROD
   Recovery Catalog Username : rman
   Recovery Catalog Password : rman

6)  Once the above information is processed the database will be registered in the Recovery Catalog.

7)  Now select the option 'USE RECOVERY CATALOG' on the RECOVERY CATALOG SETTINGS page. This will enable the usage of recovery catalog for rman backups.

8)  Now you can schedule a rman backup.This backup will be done using the recovery catalog.

Reference: How To Configure RMAN Recovery Catalog Using Enterprise Manager DB Console. [ID 467969.1]