Start of Content Area

Procedure documentation Salvaging Logical Logs for a Full-System Cold Restore (ON-Bar)  Locate the document in its SAP Library structure

Use

This is the first stage in a full-system cold restore of the Informix database if you use ON-Bar as your data recovery tool (that is, for your database and logical-log backups). It makes sure that you have as up-to-date logical-log backups as possible for the restore. This means that your database is as up-to-date as possible when the restore is finished.

Note

If you perform a physical restore with onbar -r , you do not need to perform this step, because it implicitly executes onbar -l -s (see "Procedure" below). Otherwise, SAP recommends you to perform this step.

Prerequisites

Procedure

  1. Enter the following at the operating system command line:
  2. $ onbar -l -s

  3. Check the results in the ON-Bar activity log, the name of which is specified by the BAR_ACT_LOG parameter in the ONCONFIG file. For more information about looking in the ONCONFIG file, see Listing System Information with SAPDBA.
  4. Here is an example of salvaging the logical log:

    1998-12-18 15:45:55 16674 16672 /.../bin/onbar_d -l -s

    1998-12-18 15:45:57 16674 16672 Successfully connected to Storage Manager.

    1998-12-18 15:45:58 16674 16672 Begin salvage for log 9.

    1998-12-18 15:45:59 16674 16672 Completed salvage of logical log 9.

  5. Note the number of the logical log for use in the logical restore phase.
  6. Physically label the storage media with the logical-log number and the current date, if possible.

Result

You have salvaged the logs for use in the logical restore. You can now continue with the next stage, Performing Physical Restore for a Full-System Cold Restore (ON-Bar).

 

See also:

Informix documentation