Tuesday, September 20, 2011

How to Configure Recovery Catalog

Recovery catalog creation is done in two parts, first we'd nee to create database user which would be the owner of the recovery catalog objects followed by catalog itself.

So let’s start it

1.Using SQL*PLUS, connect as sys user

[oracle@lab]$ sqlplus / as sysdba

2.Create tablespace and the schema  for the Recovery Catalog owner

SQL> create tablespace cat_ts
 datafile '/u02/oradata/datafiles/cat_ts' size 500M;

Tablespace created.

SQL> create user rman identified by rman
                temporary tablespace temp
                default tablespace cat_ts
                quota unlimited on cat_ts;

User created.

3.Grant required permissions to the user created in step 2

SQL> grant recovery_catalog_owner to rman;

Grant succeeded.

SQL> exit;

Creating Recovery Catalog

Now the recovery catalog owner is created but not the catalog .
 In order to create the catalog,  connect to the RMAN

1.[oracle@lab]$ rman

RMAN> connect catalog rman/rman@database_name

2.Now create the catalog as below, RMAN will automatically create in the schema created

RMAN> create catalog;

recovery catalog created


Connecting to the newly created catalog 

RMAN> connect target /

RMAN> connect catalog rman/rman@database_name

No comments:

Post a Comment