Restoring logical files

While restoring a server from an archive, you might want to recover all the work that has been done since the archive took place. If you have performed logical log backups, use this procedure to restore the logical log files.

Server machine stops are normally recovered by an Informix® server mechanism called Fast Recovery. Fast Recovery can recover Informix server data when the Informix server was not shutdown properly. This situation does not require the restore procedure, because it is performed automatically whenever you bring the Informix server to the online state.

You can back up the remaining logical log files that were not yet backed up. Then you can proceed with your regular restore procedure. Near the end of the restore procedure, you can restore logical logs from the backup.

This topic contains steps for Windows and UNIX.

Windows

Procedure

  1. Ensure that you are an Informix-Admin group member and working as the local administrator to perform this command.

    You must run this command on the machine where the Informix server resides.

  2. Run the restore program.

    > ccmsrv restore

    Answer a prompt regarding the type of archive media that was used.

  3. Back up current logical log files. Mount the tape drive and insert a blank tape first. During the restore, you are prompted with the following message:
    Would you like to back up any of logs 11 - 12? (y/n) y
    Logical logs 11 - 12 may be backed up.
    Enter the id of the oldest log that you would like to back up? 11
    Backing up logical logs 11 - 12 ...
  4. Restore the database server from the latest archive.

    This procedure restores the Informix server from various levels of archive performed regularly. Answer the prompts accordingly and restore the Informix server to the latest state.

  5. Restore from the logical log backup.
    Roll forward should start with log number 12
    Is there a logical log tape to restore? (y/n) y
    Please mount tape and press Return to continue ...
    Processing logical logs, please wait ...
    Is there another logical log to restore? (y/n) n
  6. Bring the Informix server online, and verify that the data was restored properly.

    > ccmsrv online

  7. Log off, and then log on as the Rational Synergy administrator.
  8. Check the database to ensure that it was restored successfully to its previous state.

    > ccmdb check dbpath

  9. Log off from the Rational Synergy administrator.
  10. Log on as a member of the Informix-Admin group, and then perform a Level 0 archive.

    > ccmsrv archive /level 0

UNIX

Procedure

  1. Take the database server offline.

    To include logical log file backups in your database server restore procedure, follow the steps shown in Restoring database servers for Informix.

  2. Restore the database server.

    While restoring the database server, the system prompts you to perform the following additional steps if you are restoring from a logical log backup file.

    1. Back up the current logical log files (files that are not backed up already).

      Insert a new tape (or define a new tape device file).

      Respond y to the following prompt, and then type the ID for the oldest log file to back up.

      Would you like to back up any of logs 11 - 12? (y/n) y
      Logical logs 11 - 12 may be backed up.
      Enter the id of the oldest log that you would like to back up. 11
      Backing up logical logs 11 - 12 ...
      
    2. Restore the database server from the latest archive.

      For more information, see step 8 in Restoring database servers for Informix.

      Type y to the following prompt, and then press Enter to mount the tape (or use the file) for the logical log file.

      Roll forward should start with log number 12
      Is there a logical log tape to restore? (y/n) y
      Please mount tape and press Return to continue ...
      Processing logical logs, please wait ...
      Is there another logical log to restore? (y/n) n
  3. Bring the database server online, and then verify that the data was restored properly.
  4. Perform a Level 0 archive.

Feedback