In Oracle : Create the Oracle RMAN Catalog

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> Create the Oracle RMAN Catalog

 

 Create the Oracle 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

 

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 :

 

SYSTEM tablespace 90 MB
Temp tablespace 5 MB
Rollback or undo tablespace 5 MB
Recovery catalog tablespace 15 MB for each database registered in the recovery catalog
Online redo logs 1 MB each (3 groups, each with 2 members)

 

 

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;

 

 

Create the RMAN Recovery Catalog

 

1. From the OS level execute

    rman CATALOG rman/r    (to connect to the database)

 

2. Create the catalog

    CREATE CATALOG;

 

Oracle RMAN Catalog

 

 

Register a database into Recovery Catalog

 

In order to connect and work with a target database, RMAN must be connected to the catalog and to the target database. 

 

To connect to the target database and the recovery catalog we have to use this command (run on the RMAN database server):

 

rman TARGET sys/s@db1 CATALOG rman/r   

 

To register the target database with the RMAN catalog the command we have to use is REGISTER DATABASE; 

 

Oracle RMAN Catalog

 

Now we can see that the DB table in RMAN schema has one database register (In this table we can see the database identifier of the new registered database). To check this we can run (connected as RMAN)  SELECT DB_ID from DB; 

 

 

Verify the database registration 

 

We can verify the database registration by running REPORT SCHEMA command.

 

Oracle RMAN Catalog

 

 

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> Create the Oracle RMAN Catalog

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.