The RMAN Recovery Catalog is a database schema that holds the metadata detailing the RMAN backup operations performed on the target database. The metadata include the following information from about the target database: database structure, RMAN configuration, data file and archive log backups (backup sets, pieces and copies), archived redo logs and their copies. In addition to the metadata the recovery catalog can also store scripts that can be used by all registered target databases.
This document will detail the steps to create RMAN recovery catalog using Oracle Database 11gR2 on OEL OS. The process is the same for other versions of UNIX, Solaris and AIX.
It is recommended that the recovery catalog be in a database separate from any of the target databases. Many organizations store the recovery catalog in the same database as their Enterprise Manager Grid Control repository. It is also recommended that the database that houses the recovery catalog to be in ARCHIVELOG mode.
SQL> create tablespace rman
datafile ‘u01\app\oracle\oradata\rcvcat\rman01.dbf’
size 100M;
Next we should create the recovery catalog owner.
SQL> create user rcat identified by rmancat
default tablespace rman;
User created.
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
The role RECOVERY_CATALOG_OWNER has all of the privileges to maintain the recovery catalog.
The actual creation of the recovery catalog is performed in RMAN while connected to the database in which the catalog is to be created. The command CREATE
CATALOG will create the recovery catalog in the default table space of the user.
rman target / catalog rcat/rmancat@rcvcat
Recovery Manager: Release 11.2.0.1.0 – Production on Mon Jul 8 23:33:23 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: rcvcat (DBID=1234567890)
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
To the new database to be backed up, you have to register it on the rman catalog you just created: (For any new database you can use this catalog after
register database in catalog)
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
Cheers..!!
Happy Learning..!!
