Restoring Informix Instance to a Different Location (Out of Place)

You can restore Informix data to a different location (out of place).

Before You Begin

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.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Instances page appears.

2. In the row for the database instance to restore, click the action button , and then click Restore.

   Alternatively, click the instance, and then on the Recovery points tile, select Restore.

   The Backup content page appears.

3. To perform restore from a secondary copy, select the Change source option in the top-right corner of the page. From the Restore from copy list, select the copy.

4. Click Restore.

   The Restore options dialog box appears.

5. Select the Out of place option.

6. From the Destination Client box, select a client to restore the instance to.

7. From the Destination Instance box, select an instance.

8. From the Restore type list, you can select the following two options:

   • Entire Instance

   • Whole Instance

9. Under Restore database option, select the data to restore:

   • Select the Physical check box to restore the physical data.

   • Select the Logical check box to restore the logical data.

   • Select the Restore config files check box to restore the emergency boot file (ixbar), oncfg and ONCONFIG files.

   Note

   Ensure that the required log entries are available in the ixbar file. If the required logs are not present, use a backup that includes those logs. First, restore only the configuration files from the backup. Browse the backup job and select the Restore config files option. After the configuration restore completes, restore the database data by selecting the Physical and Logical options.

10. Under Recover to option, select the time to restore data from:

    • Select Most recent backup to restore data from the most recent backup.

    • Select Point in time to restore data from a specific date and time.

      You can restore dbspaces from the full backup created at or before the point in time based on the date and time that you specify.

    • Select Up to logical log to restore data up to a specific logical log, and then select the logical log number from the backed up log.

      You can view the last log number from ixbar or bar_act.log files.

      You can restore all of the data for committed transactions up to and including the logical log that you specify.

11. Select the date and time of recovery using the Date and time calendar.

12. From the Media agent list, select a MediaAgent server name.

13. Select the Notify user on job completion checkbox to send a notification email when the restore job is completed.

14. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       • Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

15. Click Submit.

What to Do Next

To view the application logs of the jobs, see Viewing the Application Logs.

Related Topic

Viewing and Editing Database Restore Schedule.