Cataloging the Emergency Save Set (ON-Archive)
Use
This procedure is part of an emergency logical-log backup on the Informix database with
ON-Archive without the SAP scripts. For an overview, see Emergency Logical-Log Backup without SAP Scripts (ON-Archive).In this step, you make a catalog entry in the sysmaster database for the emergency save set
ONDATARTRLOG . This is a prerequisite for using the backed up log files in a restore.Prerequisites
You have finished
Backing up Logical-Log Files Using ondatartr (ON-Archive).Procedure
$ onarchive 'catalog/vset=ONDATARTRLOG/volume=1'
You see the following response from
ON-Archive :Request id 00023370 rebuilt as 00000106.
ON-Archive
always scans volume 1 of ONDATARTRLOG and writes the relevant information to the sysmaster database. The catalog command effectively builds and registers a backup request that would have been executed to create the save sets under normal conditions (for example, while the database is running). This process might take some time to complete.Result
The logical-log backup is now cataloged and can be used in a restore. Make sure you perform the remaining steps to copy the cataloged data to a regular volume set and then free the emergency logical-log volume for future use.
The next step depends on how you normally perform logical-log backup:
See also:
Informix documentation