Start of Content Area

Process documentation Approach to Logical-Log Backup (ON-Archive)  Locate the document in its SAP Library structure

Purpose

To make sure that you can back up the logical log of your the Informix database with ON-Archive in the best way, you have to decide on your approach. If your approach is poor, you might later have trouble using the logical-log backups to restore the database.

Prerequisites

You have completed the preparations necessary to set up ON-Archive . Refer to Configuration of ON-Archive.

Process Flow

  1. You develop good practice for logical-log backup.
  2. You decide whether to use automatic or continuous logical-log backup.
  3. You decide whether to use the DBA Planning Calendar in the Computing Center Management System (CCMS) of the SAP System to schedule logical-log backups.
  4. You decide whether to use the SAPDBA recovery report.

Caution

Always perform a logical-log backup after parallel archives. You cannot use a parallel archive later in a restore unless the logical-log files are available to synchronize the different parts of the archive. Therefore, you must back up the logical log straight after the parallel archive.

Result

You can now check the Requirements for a Logical-Log Backup (ON-Archive).

 

See also:

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