RMAN: CREATE THE RECOVERY CATALOG

RMAN

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.

Login to SQL with SYSDBA privileges

[email protected] > 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.

[email protected] > 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.

[email protected] > 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

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

RMAN> connect catalog rman/[email protected]

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created