Creating Recovery Catalog in RMAN

Generic filters
Exact matches only
Filter by Custom Post Type

Steps by Step Instructions For  Creating Recovery Catalog

 Recovery catalog is an optional schema which stores the backup information. The recovery catalog contains a set of tables which stores the backup information. In this article  we discuss the steps for creating recovery catalog in RMAN.

Note : target database controlfile will keep the backup information irrespective  of whether recovery catalog used or not.Which also means that , RMAN can be used with or without recovery catalog.

The recovery catalog contains information about both RMAN backups and the target database. More specifically, the recovery catalog contains the following:

  • RMAN configuration settings
  • RMAN-stored scripts that you create
  • Target database tablespace and data file information
  • Information pertaining to data file backup sets and backup pieces
  • Information pertaining to archived redo log backup sets and backup pieces
  • Information pertaining to data files and archived redo log copies

We can restrict the access to recovery catalog by creating Virtual Private Recovery Catalog

As recovery catalog is schema , it can created in an existing database or a new database. Creating the Recovery Catalog in a new database is the preferred method.
[adrotate banner=”3″]

Creating Recovery Catalog

In this example , i have created a new database ‘rcatlog’ as my recovery catalog database. The name of my target database is ‘mydb’. I have already made the required entries in the tnsnames.ora file for remote connectivity to the catalog  database.

  • Create recovery catalog owner

Connect to the database as sys user where recovery catalog has to be created

SQL >  connect sys/[email protected] as sysdba

Create the tablespace for the recovery catalog

SQL > create tablespace  catalogtbs datafile ‘/wysheid/db/recoverytbs.dbf’ size 2000M;

Create the recovery catalog owner

SQL > create user rcowner identified rcowner tablespace catalogtbs quota unlimited on catalogtbs;

Grant recovery catalog ownership to the user

SQL >  grant recovery_catalog_owner to rcowner;

  • Create the recovery catalog

Connect to recovery catalog as the recovery catalog owner

RMAN >  connect catalog rcowner/[email protected]

RMAN> create catalog;

 Connecting to the  catalog from command line

 The connection to the recovery catalog  will always be with TNS Names.

RMAN > connect  target / catalog rcowner/[email protected];

[adrotate banner=”3″]

Registering Target Database

 Connect to target database and recovery catalog database

RMAN > connect  target / catalog rcowner/[email protected];

RMAN > register database;

RMAN > report schema;

Unregister Target Database

Connect to target database and recovery catalog database

RMAN > connect  target / catalog rcowner/[email protected];

RMAN > unregister database;

RMAN> unregister database mydb;

RMAN> run


set dbid 1316762622;

unregister database mydb;


This command will not delete the backups, we can still access the backup information using  target database controlfile

Updating the recovery catalog with new information of the target database

RMAN > connect  target / catalog rcowner/[email protected];

RMAN > resync catalog;

[adrotate banner=”3″]

Dropping the Recovery Catalog

RMAN > connect target / catalog rcowner/[email protected];

RMAN > drop catalog;



Hope this helps ..


Happy Learning .. Wysheid Team

Liked this Article.?

We have lot more interesting posts like this!  Join more than 5000 subscribers who stays ahead on technology.

By entering your email, you agree to the Terms and Conditions and Privacy Policy and cookies usage

You Make like the below posts

About The Author

Share on

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest

Leave a comment

Your email address will not be published. Required fields are marked *

Can't Find What You Are Looking For?.

Please enter the details below. We will try our best for you :-)

We have more amazing posts

Try searching here

lick edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve