RMAN Catalog Setup

Steps to configure RMAN catalog

Always its a good practice to setup RMAN catalog in a dedicated separate machine.  Login to a new database dedicated for RMAN recovery catalog:

set oracle_sid = rman

sqlplus / as sysdba

create tablespace catts
datafile '/u01/rman/catts01.dbf'
size 50m
autoextend on;

create user rman identified by rman
default tablespace catts;

grant connect, resource, recovery_catalog_owner to rman;

quit;

Now login to rman to create recovery catalog

$rman catalog rman/pass@torman

create catalog;
(recovery catalog created)
(this will create set of tables and views to store RMAN metadata information)

quit;

We need to connect to both the rman database and the target database at the same time to register production database in catalog.

export ORACLE_SID=prod

rman target / catalog rman/pwd@torman

rman target sys/manager@toprod catalog rman/pwd@torman

rman target=sys/manager@toprod catalog=rman/pwd@torman

RMAN> register database;

(this will link the production database with RMAN catalog)

Now login to both RMAN Recovery Catalog and Production database

rman target / catalog rman/pwd@torman (OS Authentication)

rman target sys/manager@toprod catalog rman/pwd@torman (pwd file authentication)

To see the basic datafiles for backup:

report schema;

If we have more than one database, one at a time we need to register.

Once in a while we can take the backup of RMAN catalog database.  User managed (cold or hot) backup will be good enough.