To make sure the data from a logical-log backup with ontape can be used quickly and effectively to restore the database, perform the tasks described in this section.

You have checked the logical-log backup result and checked the tape.

1. Write the following information on your tapes to simplify the restore process:

– Date and time of backup

– Tape number from ontape

– Logical-log file numbers from ontape

2. Copy logical-log backup volumes and store copies offsite

Since your logical-log backups are vital to restore your database in the event of failure, you should consider copying the volumes and storing the copies at a different physical location.

3. If you are using automatic logical-log backup, use SAPDBA to display the status of the logical logs. Refer to System Information. If necessary, you might need to increase the frequency of the backup.

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