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

Now connect to RMAN with Catalog user

Take a backup with Catalog database.

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

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

Restore the deleted file with catalog

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.