Applies to Oracle 10g / Oracle 11g

• Create a new database using Oracle Universal Installer or from command line; lets say the new database name is orcl01
• Once completed you will now have 2 ORACLE_HOME
• In command prompt; set the ORACLE_SID=orcl01
• Create a new tablespace say; rcatab. Please ensure you have set the db_create_file_dest parameter appropriately

CREATE TABLESPACE rcatab DATAFILE 1024M

Note: Define the space for your recovery catalog as per your database needs

• Create a User which will be the owner of the recovery catalog

CREATE USER rman IDENTIFIED BY password
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rcatab
QUOTA UNLIMITED ON rcatab;

GRANT RECOVERY_CATALOG_OWNER TO rman;

• Connect to RMAN with the RMAN user and create the catalog

RMAN catalog rman/password@orcl01

CREATE CATALOG;

• Register the Target Database with the Recovery Catalog
  • Before you do this; exit RMAN and set the ORACLE_SID to your target database
  • Login to RMAN connected to Recovery Catalog and Target Database

RMAN target / catalog rman/password@orcl01

Register Database;