Start of Content Area

Procedure documentation Performing a Continuous Logical-Log Backup (ontape)  Locate the document in its SAP Library structure

Use

This procedure tells you how to perform a continuous logical-log backup on your Informix database using ontape .

Procedure

Note

Do not run the backup as a background process (that is, using the UNIX & operator on the command line or using cron ) because then you cannot respond to the prompts to mount new tapes.
  1. Place a write-enabled tape in your tape drive.
  2. Log on as user informix and enter the following command:

    3. $ ontape -c

  3. When ontape prompts you, mount a tape on the drive specified by LTAPEDEV .
  4. When a logical-log backup tape is full, ontape prompts you, as in the following example:

    5. Tape is full...

    Please label this tape as number 1 in the log tape sequence.

    This tape contains the following logical logs:

    843 - 912

    Remove the tape and label it. Refer to Completing Logical-Log Backup (ontape).

  5. Mount a new tape when ontape prompts you. For example:

    6. Please mount tape 2 on /dev/rmt/0m and press Return to continue...
  6. To end continuous backup, press the interrupt keys CTRL-C .

If you press the interrupt keys while a logical-log file is being backed up to a local device, all files that were completely backed up before you pressed the interrupt keys are captured on tape and are marked as backed up.

However, this is not guaranteed when you use a remote tape device. Therefore, you should not use a remote tape device for continuous backup.

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