RMAN CATALOG

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
rmanpic:
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 ........

Comments:

Very neatly written. Good !!

Posted by Advait Deo on July 23, 2007 at 12:04 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

This blog is authored by Pankaj Chandiramani , Product Manager for Enterprise Manager at Oracle . Main Focus of the blog will be on Enterprise Manager 12c with deep coverage of Database Center Automation including DbaaS , Database Provisioning , Database Patching , Config , Compliance etc .

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today