Start of Content Area

Process documentation Creation of a Logical-Log Backup (ON-Bar)  Locate the document in its SAP Library structure

Purpose

You have to back up the logical log of your Informix database with ON-Bar for use in a restore in the event of database failure. Also, when the logical log is full, the database stops processing. You can use a number of different approaches for logical-log backup.

Prerequisites

You have worked out an approach and met its requirements. In particular, make sure that you have correctly set up the storage manager and the parameters for logical-log backup.

Before going live with logical-log backup, be sure to test it, including performing a restore with the backed-up data.

Process Flow

  1. You perform the logical-log backup. Refer to one of the following:
  2. - Performing a Continuous Logical-Log Backup (ON-Bar) (recommended by SAP)

    - Performing a Manual Logical-Log Backup (ON-Bar)

    For more information, see Choosing Continuous or Manual Logical-Log Backup (ON-Bar).

  3. You check the result in either of the following ways:
  4. - Checking Logical-Log Backup Result with Message Log

    - Checking Logical-Log Backup Result with Activity Log (ON-Bar)

  5. You complete the logical-log backup.

Result

The logical log is backed up. Therefore, you have a copy of logical-log data that can be used for a restore in the event of database failure.

 

See also:

Informix documentation at http://www.informix.com