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;