How to create recovery catalog and register database in catalog



Last updated on December 21st, 2015 at 04:46 am

Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem

Also it provides a central repository where you can find all the backup information.

Here are the steps on How to create recovery catalog  and register database in catalog

Creating catalog

1) Create a Recovery Catalog Tablespace
CREATE TABLESPACE R_CATALOG
LOGGING
DATAFILE ‘/u00/R_CATALOG.dbf’ SIZE 200M

2) Create the rman schema
CREATE USER rman IDENTIFIED BY cat TEMPORARY TABLESPACE temp DEFAULT TABLESPACE R_CATALOG QUOTA UNLIMITED ON R_CATALOG;
3) Grant RECOVERY_CATALOG to the schema rman
GRANT RECOVERY_CATALOG_OWNER TO rman;
4)Connect to Oracle with either SQLPlus or
RMAN
sqlplus rman/pass@db
$ORACLE_HOME/bin/rman TARGET / CATALOG  rman/pass@db
5) Run the CREATE CATALOG script to create the recovery catalog

RMAN> CREATE CATALOG

6) Connect into the Oracle database as rman and
select from user_tables
sqlplus rman/pass@db
SELECT table_name from user_tables

7) Connect into RMAN
$ORACLE_HOME/bin/rman TARGET / CATALOG
rman/pass@db
Note “connected to recovery catalog database”

Registering a Target Database in the Recovery Catalog

1) Connect into RMAN
$ORACLE_HOME/bin/rman TARGET / CATALOG
rman/pass@db

2) register database

3) report schema

How to take store backup information in Recovery catalog

There are two ways.

  1. when you take backup , connect to catalog also

$ORACLE_HOME/bin/rman TARGET / CATALOG  rman/pass@db

backup database;

2) You can take backup using control file, then run rsync  catalog to sync the control file to catalog repository

Connect into RMAN
$ORACLE_HOME/bin/rman TARGET / CATALOG rman/pass@db

rsync database;


Leave a Reply