Pankaj Chandiramani's Blog

Few days back i created a RMAN catalog for our Production RAC env which has a 8-node cluster , sharing my experience on the same ........

First we need to understand why we need a Catalog .....
To have a better Back up solutions for large no of db's ; Backup policy is easy to manage  ; Catalog offers enterprise-wide repository ; Reporting is easier ...etc

Basic Architecture shows how this is implemented ....refer below pic

So we will get right to the work & do teh installation & config as below :

Creating a RMAN Catlog is a 3 phase process :
    Create DB that will contain catalog
    Create User , Table space etc
    Create Catalog

Step 1 :Create DB that will contain catalog
Here is what i did :
    Instal 10gR2(without the db ) -> Upgrade to 10.2.0.2
    ->Create a DB
As we were to ues this as just a RMAN Catalog , we created a custom db .

Step 2: Create User , Table space etc
We created a table space for Rman called TRMAN
eg : CREATE SMALLFILE TABLESPACE "TRAMAN" DATAFILE '/u02/oradata/T_02.dbf' SIZE 2000M REUSE , '/u02/oradata/T_01.dbf' SIZE 2000M REUSE LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

We then created a USER called Rman with defalut table space TRMAN & unlimited quota
eg : CREATE USER RMAN PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "TRAMN" TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON "CATTBS" ACCOUNT UNLOCK

Then we gave the required priviledges
GRANT "CONNECT" TO RMAN
GRANT "RECOVERY_CATALOG_OWNER" TO RMAN

Step 3 : Create Catalog

Connect to RMAN & create a catalog like below :
RMAN> connect catalog rman/oracle
RMAN>create catalog TRAMN (tablespacename)

So Rman catalog is created .................
No to register any DB into this we use the below command

./rman target / catalog rman/oracle

RMAN> register database ;

will cover exp + backup details in some of my next posts ........