Performing a Continuous Logical-Log Backup (ON-Bar) (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

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

Use

This procedure tells you how to perform a continuous logical-log backup on your Informix database using ON-Bar .

Prerequisites

You have defined your storage devices (for example, tape drives). With continuous logical-log backup, you need to reserve a dedicated storage device.

You have set the required parameters in the ONCONFIG file and restarted the database server for the changes to take effect.

Procedure

Make sure that your backup medium is ready to receive data. For example, place a write-enabled tape in your tape drive.

Note

For more information about media handling, see the documentation for your storage manager.

As soon as it starts, the database server automatically runs the program log_full.sh to back up each logical-log file as soon as it fills.

Change the backup medium (for example, the tape) as required.

Result

The logical log is backed up, as soon as each logical-log file fills. Therefore, you can use the logical-log backup for a restore in the event of database failure.

Make sure that you check the logical-log backup result. Finally, be sure to complete the logical-log backup.

See also:

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