Recovery Catalog Setup

1.Connect to the recovery catalog database

 . oraenv
ORACLE_SID = [CVRCAT] ? CVRCAT
The Oracle base remains unchanged with value /u01/app/oracle
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed May 28 03:05:36 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL>

2.Create the user , tablespace and their privileges to be used as recovery catalog owner

SQL> create tablespace rcat_tbs datafile '+DATA' SIZE 100M AUTOEXTEND ON;

Tablespace created.

SQL> create user rcat_owner identified by rcat_owner default tablespace rcat_tbs quota unlimited on rcat_tbs;

User created.

SQL> grant recovery_catalog_owner to rcat_owner;

Grant succeeded.

SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

3.Connect as catalog owner and create catalog

 rman catalog="rcat_owner/rcat_owner@cvrcat"

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 28 03:34:47 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;
recovery catalog created

4. Register the database to the recovery catalog database

 export ORACLE_SID=CVRMAN
$ rman target / catalog="rcat_owner/rcat_owner@cvrcat"

Recovery Manager: Release 11.2.0.4.0 - Production on Wed May 28 03:42:27 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CVRMAN (DBID=657566608)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete