What is a recovery catalog?
What is a recovery catalog?
Rating:
A recovery catalog is a set of tables and views that Recovery Manager (RMAN) uses to store metadata (information about a database structure, archived redo logs, backup sets, and data file copies) about a target database (database that RMAN backups or restores). RMAN uses this metadata to conduct its backup, recovery, and maintenance operations. Recovery catalog is optional, i.e., if a recovery catalog is not created, RMAN uses the target database's control file to store the metadata about the target database. Although RMAN can conduct all major backup and recovery operations by using the control file, some RMAN commands work only if a recovery catalog exists.
A recovery catalog is solely managed by RMAN. RMAN propagates information about the database structure, archived redo logs, backup sets, and data file copies into the recovery catalog from the target database's control file.
A recovery catalog can be used to store metadata about multiple target databases. The tables and views constituting a recovery catalog are owned by a recovery catalog schema. Oracle recommends creating a recovery catalog schema in a separate dedicated database and not in the target database. A database containing a recovery catalog schema is called a recovery catalog database.
Rating:
Other articles
- What is Memory Manager (MMAN)?
- What is Oracle Net Manager?
- What is ORAPWD?
- What is Fine Grained Access Control (FGAC)?
- What is a backup set?