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

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

Use

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

Note

SAP recommends you to use continuous logical-log backup. This is because the problem with manual logical-log backup is that the logs might fill before you have backed them up. You must then perform an emergency backup, which is difficult and time-consuming. For more information about preventing this situation, see Preventing Emergency Logical-Log Backup.

Prerequisites

You have defined your storage devices (for example, tape drives).

You have set the required parameters in the ONCONFIG file.

Procedure

Monitor the logical log to find when a logical-log backup is required. Refer to:

Using the Archive and Backup Monitor in CCMS (Informix)

Monitoring the Database with the Release 4 Alert Monitor (Informix)

Listing System Information with SAPDBA

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.

Enter the following at the command line to perform a manual logical-log backup:

To back up all full logical-log files:

$ onbar -l

To back up only the current logical-log file:

$ onbar -l -c

Change the tape or backup medium as required.

Continue to monitor the logical log, as described above.

Result

The logical log is backed up. 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