Purpose of Catalog Database

A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.

Catalog Database can be two types

  • Base recovery catalog
  • Virtual private catalog.

For more details


Create the tablespace for catalog user

SQL> create tablespace rman_cat datafile ‘D:\oracle\product\10.2.0\oradata\cat_01\rman_cat02.DBF’ SIZE 100M;

Tablespace created.

SQL> create user anuradha identified by anuradha default tablespace rman_cat temporary tablespace temp_1;

User created.

SQL> grant connect,resource,recovery_catalog_owner to anuradha;

Grant succeeded.

Now connect to RMAN with Catalog user

RMAN> connect catalog anuradha/anuradha@cat

connected to recovery catalog database

RMAN> create catalog tablespace rman_cat

recovery catalog created

Take a backup with Catalog database.

C:\>rman target sys/sys@dba_01 catalog Anuradha/anuradha@cat01

Recovery Manager: Release – Production on Mon Jul 12 16:08:21 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=847839442)

connected to recovery catalog database

RMAN> run


allocate channel c1 type disk;

allocate channel c2 type disk;

backup database;


RMAN> report schema;

If any physical structure changes in target database then this command required for resynchronization.

RMAN> resync catalog;

starting full resync of recovery catalog

full resync complete

RMAN> reset database;

database incarnation already registered

This command required only when incomplete recovery occurred in the target database. Remove the one or more datafiles and try to restart the database

SQL> shutdown immediate;

Database closed.

Database dismounted.

Delete some Datafile

SQL> startup;

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1247876 bytes

Variable Size 75498876 bytes

Database Buffers 83886080 bytes

Redo Buffers 7139328 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 – see DBWR trace file

ORA-01110: data file 1: ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSTEM01.DBF’

Restore the deleted file with catalog

C:\>rman target sys/sys@dba_01 catalog anuradha/anuradha@cat01

RMAN> run


allocate channel c1 type disk;

allocate channel c2 type disk;

restore database;

recover database;


SQL> alter database open;

Database altered.

Today’s thought

“Act confident, even when you’re not.” Larry Ellison

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.