Backing up logical log files for UNIX®

Informix® uses logical log files for data recovery and consistency. Backing up the logical log files provides a means of restoring database servers to their last committed transactions. If the server becomes corrupted, the system performs a fast recovery after an unexpected server shutdown, which frees space for new logical log records. You can restore a database server to the last server archive. With logical log backups, you can restore work done between the last archive and the time the database server was shut down or corrupted. Before backing up logical log files, you must perform the following steps.

Procedure

  1. Establish a backup plan, and update it periodically.

    Create and test a plan for scheduled backups to ensure that the plan works and does not affect your current production environment. Include in the plan scheduled database server archives and logical log file backups.

  2. Plan to have users log out of their Rational® Synergy sessions during backups.

    When the backup is in progress, users might still be working in the file system while the database activities are suspended, which can cause data inconsistencies.

    To help avoid data inconsistencies when the server is restored, ensure that users do not make changes in the file system while the logical log files are being backed up.

    Note: You can restore from logical log backups only while restoring the database server. See the comment at the end of step 8 in Restoring database servers for Informix.

Feedback