Restoring Informix Out of Place

You can perform an out-of-place restore of Informix database.

Perform a cross-machine restore when the original database host has been damaged or destroyed, and you need to restore the data to a different host from the backup.

Notes

  • The data is restored to the same path as the host and overwrites existing data.

  • Cross-machine restores do not support partial or log only restores.

Before You Begin
  1. Full instance restore initiates salvage log backup that requires backup activity to be enabled at the destination instance level.

    To avoid salvage log backup, perform physical restore followed by logical restore.

  2. Perform a full backup of source Informix server and include the emergency boot file (ixbar) file and ONCONFIG file in the backup.

  3. Verify the source and destination Informix servers:

    • Have the same dbspaces name and paths

    • Have the same SERVERNUM number in ONCONFIG file

    • Are configured on the same CommCell Console

Procedure
  1. From the CommCell Browser, navigate to Client Computers | <Client> | Informix.

  2. Right-click the <Instance>, point to All Tasks and then click Browse and Restore.

  3. Click View Content.

  4. From the Browse window, navigate and then select the database to be restored and click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab:

    1. Select the destination client that you want to restore to, from the Destination Client list.

    2. Select the destination Informix server that you want to restore to, from the INFORMIX SERVER list.

    3. To perform an entire instance restore, in the Restore Mode section, select either the Entire Instance Restore option or the Whole Restore option.

    4. Select both the Physical and Logical check boxes.

    5. Select the Restore Emergency Boot File(ixbar) and Restore ONCONFIG File check boxes.

    6. Click OK.

  6. Click OK.

Loading...