Creating Catalog Database on Oracle10g

Step 1: Create o/s User:

Useradd –u 204 –g 2001 –G 1001 –c “Catdb Catalog User” –m –d /u04/catdb –s /bin/ksh catdb
Passwd : Enter password for catdb user

Group 2001: dba
Group 1001 : oinstall


Step 2: Creating Database
Use DBCA to create Database

Step 3: Create additional tablespaces:
create tablespace catdbtbs datafile '/u03/catdb/oradata/catdbtbs01.dbf' size 1000M reuse extent management local;

Step 4:
Take Backup of the database (if required)

Step 5:
Configure Listener.ora / tnsnames.ora

Step 6: Create RMAN user
Sql> Create user RMAN identified by RMAN
Default tablespace cattbs
Temporary tablespace temp;
Sql> Grant connect, resource, recovery_catalog_owner to RMAN;

Step 7: create catalog
$ rman
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Sep 8 11:16:57 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN> connect catalog rman/rman@catdb
connected to recovery catalog database


RMAN> create catalog tablespace cattbs;
recovery catalog created

RMAN> exit
Recovery Manager complete.


Step 8: Registering database
$ rman target sys/omr1956@omr catalog rman/rman@catdb
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Sep 8 11:19:26 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: OMR (DBID=1312345947)
connected to recovery catalog database

RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u10/catdb/backup/auto_cntrl_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/dbs/snapcf_omr.f'; # default
RMAN>