RMAN Recovery Catalog Configuration

 Consider the recovery catalog Dbname is cln and tns entry is cln. Kindly follow the below steps in recovery catalog database.

Tablespace name              =>   RMAN

Temporary tablespace name    =>   TEMP

User name                    =>   rman

 1.Create tablespace.

   SQL> create tablespace RMAN datafile '/test/oracle/uatdata/rman1.dbf' size 2048M;

Tablespace created.

2.Create user.

   SQL> create user rman identified by rman

  2  default tablespace RMAN

  3  temporary tablespace TEMP

  4  quota unlimited on RMAN;

User created.

3.Granting Privilege.

   SQL> Grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

4.Recovery catalog Creation

           Please check the recovery catalog IP address in production whether pinging is happening or not. Then put the tns entry of recovery in production database. Follow the steps in production.

[oracln@test dbs]$ rman catalog=rman/rman@cln

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to recovery catalog database

recovery catalog is not installed

RMAN> create catalog;

recovery catalog created

5. Register the Target Database with Recovery Catalog

[oracln@test dbs]$ rman catalog=rman/rman@cln target /

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: CLN (DBID=4233744721)

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN>

6. Final Step

 Now the recovery catalog will successfully created and try to connect with recovery catalog in production.

[oracln@test dbs]$ rman target / catalog=rman/rman@cln

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: CLN (DBID=4233744721)

connected to recovery catalog database

RMAN>

Now we can change all the RMAN parameters as per our database requirement using show all command.

Rman>show all;

After the successful Catalog configuration we can schedule the RMAN backup in crontab as per the backup location if required.

I hope the above mentioned steps will assist you to configure the Recovery Catalog easily.

Regards,

Vijay