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
-
Restore the
ixbarandONCONFIGfiles from the source client to the destination client. Use the UI or copy the files between clients. -
If you use
onbar -roronbar -r -wto perform the physical and logical restore in one step, enable backup activity for the destination instance. This allows the salvage log backup to complete.To avoid salvage log backup, perform physical restore followed by logical restore.
-
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
-
From the CommCell Browser, navigate to Client Computers | <Client> | Informix.
-
Right-click the <Instance>, point to All Tasks and then click Browse and Restore.
-
Click View Content.
-
From the Browse window, navigate and then select the database to be restored and click Recover All Selected.
The Restore Options dialog box appears.
-
On the General tab:
-
Select the destination client that you want to restore to, from the Destination Client list.
-
Select the destination Informix server that you want to restore to, from the INFORMIX SERVER list.
-
To perform an entire instance restore, in the Restore Mode section, select either the Entire Instance Restore option or the Whole Restore option.
-
Select the Physical check box.
-
Click OK.
-
-
Click OK.
Restore options
- After the physical restore completes, repeat the restore procedure with Logical selected and Physical cleared. To perform the physical and logical restore in a single job, select both Physical and Logical. Enable backup activity for the destination instance so the salvage log backup can complete.