# Restoring Informix Instance to Current Location (In Place)

You can restore Informix data to the current location (in place).

## Before You Begin

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

## 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 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 In place.

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

   - Entire Instance

   - Whole Instance

7. Under Restore database, select the data you want to restore:

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

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

   - Select both the Physical and Logical check boxes to restore both the physical and logical data.

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

   Note

   - To prevent a salvage log backup, submit a restore job with only the Physical checkbox selected. After the job completes, submit a second restore job with only the Logical checkbox selected.

   - 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.

8. Under Recover to, 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, and then specify the time.

   - Select Up to logical log to restore data up to a specific logical log, and then specify the logical log number.

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

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

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

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

12. 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.

13. 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.

×

Loading...