Configure Oracle Database RMAN Catalog and Register Database to RMAN catalog

To configure RMAN CATALOG and Register any Oracle Database to RMAN CATALOG follow below steps:-

Definition:-
RMANDB = RMAN CATALOG database name
ORCL = Target Database we will register with RMAN CATALOG
  • Step 1 Create tablespace, create user and grant permissions on RMANDB.

SQL> create tablespace rmancatalog
          2 datafile ‘<PATH>/rmancat.dbf’ size 500M
          3 ONLINE;
Tablespace created.

SQL> CREATE USER rmancatalog IDENTIFIED BY rmancat
          2 DEFAULT TABLESPACE rmancatalog
          3 QUOTA UNLIMITED ON rmancatalog;
User created.

SQL> GRANT recovery_catalog_owner TO rmancatalog;
Grant succeeded.

SQL> commit;
Commit complete.

  • Connect to RMAN prompt and create RMAN CATALOG.

[oracle@scspr0138867001 ~]$ export ORACLE_SID=rmandb

[oracle@scspr0138867001 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 – Production on Mon Sep 26 06:08:55 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: RMANDB (DBID=3149350366)

RMAN> CONNECT CATALOG rmancatalog@rmandb
recovery catalog database Password:
connected to recovery catalog database

RMAN> CREATE CATALOG;
recovery catalog created

  • RMAN CATALOG is ready. Now Register database to RMAN CATALOG.

[oracle@scspr0138867001 ~]$ export ORACLE_SID=orcl

[oracle@scspr0138867001 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 – Production on Mon Sep 26 10:59:37 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=3149370409)

RMAN> connect catalog rmancatalog@rmandb/netapp
connected to recovery catalog database

RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> exit

Now, we have successfully create RMAN CATALOG on RMANDB and registered a Database ORCL with RMAN CATALOG.
If you have to keep RMAN CATALOG and Target Database on separate hosts/OS’es then, you need to make below settings on Target Database hosts.

  • Add RMANDB database information in tnsnames.ora file and reload listener.

[oracle@rhel66-rac2 ~]$vi $ORACLE_HOME/network/admin/tnsnames.ora
RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rhel66-rac1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RMANDB)
)
)

  • validate the settings be running TNSPING to RMANDB database name. If you do not see any response, please recheck tnsnames.ora entries.

[oracle@rhel66-rac2 dbhome_2]$ tnsping rmandb
TNS Ping Utility for Linux: Version 11.2.0.4.0 – Production on
14-SEP-2016 00:47:14
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_2/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rhel66-rac1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = RMANDB)))
OK (30 msec)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s