RMAN: CREATE THE RECOVERY CATALOG

It is always recommended to have the recovery catalog to store RMAN related information. In absence of recovery catalog RMAN stores the information in the database control files. If the target database control files are lost recovery can become difficult if not impossible.Having recovery catalog makes the DBA life easier at the time of critical scenario.

As a best practice make sure to have a separate database for the recovery catalog always .

You have already created a recovery catalog database, and want to create a recovery catalog in that database.

STEP 1 CREATE A DEFAULT TABLESPACE FOR RMAN

Create a default tablespace for the RMAN recovery catalog owner you’re about to create. Otherwise, the system tablespace may be used by default to hold the recovery catalog structures, which is not a good idea. 500MB is good enough space for a medium size database being backed up daily.

SYS@rmandb > create tablespace catalogtbs datafile ‘/u03/oracle/DBRMAN/oradata/rmandb/catalogtbs_01.dbf’ size 500M;

Tablespace created.

STEP 2 CREATE THE RECOVERY CATALOG OWNER

You need to create a rman user with default tablespace which we created in the previous step.

SYS@rmandb > create user rman identified by rman
temporary tablespace temp
default tablespace catalogtbs
quota unlimited on catalogtbs;

User created.

STEP 3 GRANT ‘recovery_catalog_owner’ PRIVILEGE

You must grant rman user the recovery_catalog_owner privilege in order for it to have the authority to work with the recovery catalog.

SYS@rmandb > grant recovery_catalog_owner to rman;

Grant succeeded.

STEP 4 CREATE THE RECOVERY CATALOG

Connect to the RMAN catalog database by starting up the RMAN client and using the connect catalog command. You must connect as the recovery catalog owner you created in the previous steps.

$ rman

Recovery Manager: Release 11.2.0.4.0 – Production on Wed Feb 12 17:10:33 2014

RMAN> connect catalog rman/rman@rmandb

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

RMAN: CREATE THE RECOVERY CATALOG

Related posts: