Recovery Catalog:

What is recovery Catalog?

-A recovery catalog is a database schema used by RMAN Which is used

to stored Metadata of one or more databases

 

Benefits:

I)It creates the redunancy for the RMAN respository(which is thebackup information are stored) in the controlfile of each target database,At the same time Recovery catalog severs the secondary metadata repository(if Suppose the target control file and backups are lost Rman metadata still maintained in recovery Catalog)

II)It's a centralizes metadata of all your target databases


III)It can store metadata history much longer than controlfile


To store this files from target databases:

-This recovery catalog contains metadata of Rman operations of each registered target database

   * Data files and Archived redo log backupset and backup pieces
   * Data file copies
   * Archived redo log and their copies
   * Database structure (tablespace and datafiles)
   * stored Rman scripts which are named user-created sequences of RMAN commands
   * Persistent RMAN configuration settings


Database Registration:

-The  process of enrolling the target database with in a recovery

catalog is called "Registration"

Note:Recommended Practice is to register every target  database into

 a single recovery catalog


Centralization of Metadata in a Base Recovery Catalog:

-Here Base recovery catalog = Normally Can access all the databases

which is registered in Recovery Catalog

-Virtual recovery  catalog = restirced Access of the Own schema Meta

data

 

Recovery Catalog Resynchronization:

-For The RMAN Operations like backup,restore and crosscheck will always first updates the own target control file then it propagates the metadata to recovery Catalog ,the flow of metadata from mounted control file into recovery catalog is called "Resynchronization"

 


Basic steps of Managing a Recovery catalog:

1)Create Recovery Catalog
2)Register your Target  database
3)If needed, catalog any older backups whose records are no longer stored in the target control file.
4)If needed,Create Virtual Private recovery catalog  for specific user to restircted access of database
5)Protect the recovery catalog by including it in your backup and recovery strategy.


Creating Recovery Catalog:

-If we use a recovery catalog ,Rman Requires that to maintain a recovery catalog schema
-The schema of recovery  catalog was created on the default tablespace
-The SYS user can't be owner of recovery catalog

Note: If you are creating recovery catalog for existing database add enough space on the default tablespace or if you are creating a new database for recovery catalog then additionally  space for the recovery catalog schema itself

Creating Recovery Catalog user:

-After choosing the recovery catalog database ,we need to allocate

necessary space you are ready to create the owner of the recovery

catalog and grant this user necessary privilege


SQL> create user RECCAT identified by RECCAT
  2  default tablespace REC_CAT
  3  temporary tablespace temp
  4  quota unlimited on REC_CAT;

User created.


Execute The Create Catalog Command:

-After  creating the catalog owner ,use the create catalog command in RMAN it 'll creates the catalog in the default tablespace of the catalog owner

Connect with Rman

S-1:

If the Catalog tablespace is default  just  type

RMAN>Create CATALOG;


S-2:

Or your are using seprate  tablespace for recovery  catalog

RMAN>CREATE CATALOG TABLESPACE REC_CAT;


Registering a Database in recovery Catalog:

-The process of enrolling of a target database in a recovery catalog is called registration. If a target database is not registered in

the recovery catalog, then RMAN cannot use the catalog to store metadata for operations on this database.

Note :You can use the UNREGISTER command to unregister a database from the recovery catalog.

 In Your Target Database RMAN:

 S-1:
   

    %rman TARGET / CATALOG rman@catdb


 
 S-2:
    
     If the target database is not mounted, then mount or open it:

 
 

 RMAN>Start Mount;

 S-3:
      Register the target database Recovery Catalog

    
 

  RMAN>Register Database;

 S-4:


   Verify that the registration was successful by running

   RMAN>report Schema;