Start of Content Area

Procedure documentation Cataloging the Emergency Save Set (ON-Archive)   Locate the document in its SAP Library structure

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

  1. Enter the following command at the command line:
  2. $ 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.

  3. Write down the second request ID (in the example, 106), because you need it for some of the later steps.

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