Command Line Interface - Restore - Informix Data Agent

Use XML to restore databases.

Procedure

1. If you are not logged on to the CommServe computer, run the qlogin command.

2. Download the restore.xml file to the computer where you will run the command.

3. On the command line, go to Software_Installation_Directory/Base, and then and type the following command:

    
   qoperation execute -af restore.xml -appName '$[Informix Database]' -clientName '$[client1]' -instanceName '$[instance1]' -backupsetName '$[default]' -subclientName '$[default]' -informixRestoreType '$[ENTIRE_INSTANCE_RESTORE]' -physical '$[True]' -logical '$[True]'

   Notes

   • For information on supported instance XML parameters, see Available XML Parameters for Informix.

   • You can define the XML parameters in the xml file, instead of on the command line. For information on command line parameters and XML elements, see Command Line - Syntax.

4. To log off the CommServe computer, run the qlogout command.

Examples

Restoring from the Latest Backup

Example of physical restore for the entire instance:

 
qoperation execute -af restore.xml -appName '$[Informix Database]' -clientName '$[client1]' -instanceName '$[instance1]' -backupsetName '$[default]' -subclientName '$[default]' -informixRestoreType '$[ENTIRE_INSTANCE_RESTORE]' -physical '$[True]' -logical '$[False]' 

Example of logical restore for the entire instance:

 
qoperation execute -af restore.xml -appName '$[Informix Database]' -clientName '$[client1]' -instanceName '$[instance1]' -backupsetName '$[default]' -subclientName '$[default]' -informixRestoreType '$[ENTIRE_INSTANCE_RESTORE]' -physical '$[False]' -logical '$[True]'

Restoring Files to a Point in Time

Example of point-in-time restore for the entire instance:

 
qoperation execute -af restore.xml -appName '$[Informix Database]' -clientName '$[client1]' -instanceName '$[instance1]' -backupsetName '$[default]' -subclientName '$[default]' -informixRestoreType '$[ENTIRE_INSTANCE_RESTORE]' -physical '$[True]' -logical '$[False]' -informixRestoreOptionType '$[TIME]' -timeValue '$[2021-07-21 18:47:18]' -TimeZoneName '$[(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi]'

Restoring Files to Another Client or Instance (Cross Machine)

Example of cross-machine physical restore for the entire instance:

 
qoperation execute -af restore.xml -appName '$[Informix Database]' -clientName '$[client1]' -instanceName '$[instance1]' -backupsetName '$[default]' -subclientName '$[default]' -informixRestoreType '$[ENTIRE_INSTANCE_RESTORE]' -physical '$[True]' -logical '$[False]' -destClient/clientName ‘$[client2]’ -destinationInstance/instanceName '$[instance2]'