SAP Scripts for ON-Archive (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

SAP Scripts for ON-Archive

Definition

The SAP scripts simplify configuration of ON-Archive and data recovery with ON-Archive for the Informix database. You do not need to enter ON-Archive commands manually if you use these scripts. Entering ON-Archive commands manually can be complex and error-prone. However, for more information if you want to do this, see Entering ON-Archive Commands Manually.

Use

The following SAP scripts are for use with ON-Archive :

arcprep defines the following default volume sets, all of which are defined on tape:

DBTAP for database archives

LOGTAP for logical-log backups

ONDATARTRLOG for salvage logs and emergency backup of logical-log files

arcprep also helps you define volumes for these volume sets. Refer to Setting Up Volume Sets and Volumes for ON-Archive with SAP Scripts.

arcvolum lets you define additional volumes for an existing volume set.

logevent.sh runs in the background and detects when the logical log has reached the predefined level. It then performs the logical-log backup.

arcauto performs automatic backup of the logical-log files at predefined times.

For more details on how to use the scripts logevent.sh and arcauto in logical-log file backup, see Automatic Logical-Log Backup (ON-Archive).

arcpanic is used for emergency backup of the logical-log files, that is, when the logical log has filled up and the database has suspended processing. This should not be necessary if arcauto and logevent.sh are installed since these routinely back up the logical logs. As an additional safety precaution, you must set the parameters ALARMPROGRAM and LBU_PRESERVE . Refer to Editing the File ONCONFIG for ON-Archive.

For more information on how to use the scripts in emergency logical-log backup, see Preparing for Emergency Logical-Log Backup with ON-Archive using SAP Scripts,

archive_control and backup_control are used to control the production of a recovery report. The report lists the volumes you need to use for a database restore. If you use the scripts continually, the recovery report is always up-to-date. You can view the report in SAPDBA. Refer to Recovery Report with SAPDBA.

You do not need to enter ON-Archive commands manually if you use these scripts. Entering ON-Archive commands manually can be complex and error-prone.

Note

Instructions for the SAP scripts assume that you archive sequentially. If you wish to perform parallel database archive, you can still use the SAP scripts but you need to meet some additional requirements. Refer to Define Devices for ON-Archive Without SAP Scripts and Setting Up Volume Sets and Volumes for ON-Archive Without SAP Scripts.

Integration

To see how the SAP scripts fit into the wider picture of configuring ON-Archive for data recovery, see Configuration of ON-Archive.