Creation of a Logical-Log Backup (ON-Bar)
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
-
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).-
Checking Logical-Log Backup Result with Message Log-
Checking Logical-Log Backup Result with Activity Log (ON-Bar)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