Performing Automatic Logical-Log Backup (ON-Archive) (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Performing Automatic Logical-Log Backup (ON-Archive)

Use

This procedure describes how to perform an automatic logical-log backup on the Informix database with ON-Archive outside CCMS, as follows:

Using the script logevent.sh

Entering your own ON-Archive commands

Although SAP recommends using CCMS, the methods outside CCMS are described here in case you want to use them. For more information about automatic logical-log backup, including the methods recommended by SAP, see Choosing Automatic Logical-Log Backup (ON-Archive).

Caution

For any of the procedures in which you use tape media, you must always make sure that the correct tape volume is mounted in the appropriate tape device. If not, the operation fails. If your logical logs have filled completely, see Emergency Logical-Log Backup.

Prerequisites

You have defined the parameters MAX_PCT and BACKUP_VSET in the logevent.sh script and the ALARMPROGRAM parameter in the ONCONFIG file. Refer to Additional Logical-Log Backup Requirements (ON-Archive).

You have defined tape devices as well as volume sets and volumes.

You have determined the volume required for the logical-log backup and loaded it into your tape drive. If you are not sure which volume to use for the next logical-log backup, you can enter the following command (assuming you have defined BACKUP_VSET to be LOGTAP ):

./arcauto -v LOGTAP -d

Procedure

Using the Script logevent.sh

Note

You do not have to explicitly start logevent.sh because it is automatically started when the Informix database server comes online. It triggers logical-log backups when required. All you have to do is make sure that the correct volume is available.

Check the log backup status, if required.

Entering your own ON-Archive Commands

Enter a command like the following at the command line:

$ onarchive 'BACKUP/LOGFILE/AUTOMATIC/VSET=LOGTAP'

For more information, see the Informix documentation.

Check the log backup status, if required.

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 and check the tapes. Finally, be sure to complete the logical-log backup.

See also:

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