Home  >  Oracle Database Administration (DBA)  >  Backup & Recovery  >  How to create the RMAN Catalog

RMAN Catalog is one the repository for the RMAN utility. RMAN can also store the backup information in the database control file. In this article I present how the RMAN Catalog is created.

Here are the steps for creating RMAN Catalog::

• Choosing a database for hosting the RMAN

• Planning the size of the Recovery Catalog

• Grant the RECOVERY_CATALOG_OWNER role to the schema owner 

• Create the RMAN Recovery Catalog

• Register a database into Recovery Catalog

• Verify the database registration

Choosing a database for hosting the RMAN

RMAN catalog must be installed in an Oracle database (new or existing). As rule, the RMAN catalog mustn't be created on the same database as the target database, for data security reason (once the database is used, the RMAN catalog cannot be used and so, the database cannot be restored & recovered). Even if the RMAN catalog is installed on the same database as the target database (but is strongly recommended not to do it), RMAN Catalog must be created on a different disk.   

Planning the size of the Recovery Catalog

Here are the Oracle requirements for 1 Year utilization :

Create a RMAN user owner 

This oracle database user will store all the data/ information for the RMAN Recovery Catalog. The name of this user is not important, however rman is the best name we can use for this purpose (will tell us exactly the usage of this schema).4

            1. Create the tablespace for RMAN user (the TOOLS tablespace could be used as well):

                 CREATE TABLESPACE RMAN_DATA_1_TBS

             DATAFILE '/ORA_RMAN/RMAN_data/rman_data_1.dbf'   SIZE 200M AUTOEXTEND ON;

             2. Create the RMAN user:

             CREATE USER rman IDENTIFIED BY r

             TEMPORARY TABLESPACE temp

             DEFAULT TABLESPACE RMAN_DATA_1_TBS

             QUOTA UNLIMITED ON RMAN_DATA_1_TBS;

Grant the RECOVERY_CATALOG_OWNER role to the schema owner (RMAN in our case)

GRANT RECOVERY_CATALOG_OWNER TO rman;

More information about  this subject ( How to create the RMAN Catalog ) you can get from  www.in-oracle.com