This section provides some hints and tips when building vendor products.
A recovery history file can be used as an aid in database recovery operations. It is associated with each database and is automatically updated with each backup or restore operation. A general overview of the file is provided in the Administration Guide. The information in the file can be viewed, updated and pruned through the following facilities:
For information on the layout of the file, see SQLUHINFO.
When a backup operation completes, a record or records are written to the file. If the output of the backup operation was directed to vendor devices, the DEVICE field in the history record will contain a O, and the LOCATION field will contain either:
See "Invoking Backup/Restore Using Vendor Products" for more details about specifying this option. If the vendor file name is not specified, LOCATION will be blank.
The LOCATION field can be updated using any of the above facilities. This capability can be utilized to update the location of the backup information if limited capacity devices (for example, removable media) have been used to hold the backup, and the media is physically moved to a different storage locations (for example, off-site). If this is done, then this file can be utilized to assist in locating the a backup when a recovery is necessary.