By Pankaj on Dec 13, 2006
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
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 ........