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
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
-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
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
If the Catalog tablespace is default just type
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:
%rman TARGET / CATALOG rman@catdb
If the target database is not mounted, then mount or open it:
Register the target database Recovery Catalog
Verify that the registration was successful by running