Restore an IDS Database

Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Informix › Using the Agent for IBM Informix › Restore an IDS Database

Restore an IDS Database

You can restore an IDS database including logical logs, dbspaces and blobspaces.

To restore an IDS database

From the Restore Manager, select the items to be restored. This can be either the entire Informix server, individual dbspaces, or blobspaces.
Note: Only one dbspace can be restored at a time.

Note: Do not restore the #LOGFILE#. The Informix server restores the logical logs automatically when a logical restore is performed.
On the Source tab, right-click the Informix server.
The Restore Options dialog opens.

The following table indicates the available restore methods and restore options:

Arcserve Backup Option		ON-Bar Option	Description
Restore Methods	Physical and Logical	-r	Restores all dbspaces, blobspaces, and logical logs.
	Physical Only	-p	Restores all dbspaces and blobspaces.
	Logical Only	-l	Restores logs only.
Restore Options	Last Logical	-n log	The number of the last log to be restored. If any logs exist after this one, they are not restored.
	Point in Time	-t time	The point in time at which to stop the restore.

Important! The Point in Time option is for Informix server-level restores and cannot be combined with any individual dbspace or blobspace restore job. Do not select the Logical Only restore method and the Point in Time restore option at the same time. If the Logical Only method is combined with any dbspaces or blobspaces, IDS ignores the objects and executes an Informix server-level logical restore.

Note: For information about the different options and requirements available for performing cold restores, warm restores, physical restores, and logical restores, see the Informix ON-Bar documentation.

Click the Destination tab.
Select the option, Restore Files to their Original Locations. (The destination must be the original location.)
The Security dialog opens.
Enter the Informix server user account details which has restore privileges, and click OK.
Select the preferred restore method and options. Click OK.
The Session User Name and Password dialog opens.

Arcserve Backup restore options are equivalent to the following ON-Bar options:
```
onbar_d -r -t 2003-9-5 13:31:17
```
Verify the user name and password for the computer to which the files are being restored. If the restore session needs to access media or any other computer that requires a user name and password different than those used for IDS or Arcserve Backup, then enter that user name and password here.
Click OK.
The Submit Job dialog displays the job details.
Click OK.
The job is submitted to the Arcserve Backup queue. You can verify the restore process from the Arcserve Backup Job Status window.

When the job is complete, a message appears indicating that the restore was successful. The first restore message results from the creation of the ON-Bar process. Depending on the progress of the restore procedure, other messages from actual (not test) restore jobs will follow.

Note: Do not interrupt the restore procedure by browsing IDS objects from the Backup Manager, or do not attempt to stop the restore operation. Wait until the BAR_INFORMIX SERVER.log shows that the restore is complete.