First page Back Continue Last page Graphics
…Recovery Catalog Maintenance
Must re-sync before data in control file overwritten!
- Check control_file_record_keep_time parameter
- Backup or issue RESYNC CATALOG before CFRKT parameter value!
Frequency of manual re-sync?
- Log switches and archiving can occur frequently
- e.g. 1000 log switches before backup taken
- Consider scheduling hourly job to resync catalog
- Inexpensive operation
- Alternative: expensive resync during backup
Notes:
Be sure that a re-sync is performed before the duration specified in the control_file_record_keep_time parameter.
If your database supports high volume of DML operations, you may want to consider frequent manual resynchronizations. For example, assume the database experiences 1000 log switches in between backup operations. In this case, the resync of the catalog could be reasonably time consuming. If you schedule hourly cron jobs to RESYNC CATALOG, you will avoid this situation.