Start of Content Area

Process documentation Emergency Logical-Log Backup Without SAP Scripts (ON-Archive)  Locate the document in its SAP Library structure

Purpose

If the logical log of your Informix database is full and your normal data recovery tool is ON-Archive but you are not using the SAP scripts, this process describes how to do an emergency logical-log backup. For more information about the SAP scripts, see SAP Scripts for ON-Archive.

Prerequisites

You have defined the following on disk (or on tape if you prefer, although it is normally slower):

For details of defining devices, see config.arc.

For details of defining volume sets, see Setting Up Volume Sets and Volumes Without SAP Scripts.

For details of defining volumes, see Setting Up Volume Sets and Volumes Without SAP Scripts.

It is best to specify the device, volume set, and volume required by ON-Archive for emergency backup before an emergency occurs. The volume set always has the name ONDATARTRLOG (this volume set is also used to salvage logical-log files during a cold restore).

Process Flow

Note

Follow all the steps in the procedure, even though the database resumes processing after the first step. The remaining steps are necessary to allow data from the emergency backup to be easily used for a restore.
  1. You back up the logical log using ondatartr.
  2. You check the results of the emergency logical-log backup.
  3. You catalog the emergency save set.
  4. You copy the backed up logs to a regular volume set.
  5. You copy the emergency save set to a regular volume set.
  6. You delete the emergency save set.

Result

The emergency is over because the logical log is now backed up, allowing the database to continue processing. Also, you can use the backed-up data in a restore without any extra steps.

Note

SAP recommends you to now create a full (level-0) archive of the database. This makes sure that you do not run into problems using the logical-log data that you have just backed up in this emergency, because you can then use a more recent archive instead.

 

See also:

Informix documentation