DB / Oracle / Oracle 11g - Windows

Creating a Recovery Catalog in a database different from Target Database

Sunil PadmanabhanLeave a comment

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;

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s