Restore Archived Data

Using the Restore Process, you can easily locate one or more Archive Files that contain data you want to restore and restore the data to the original or a new database.

For example:

To restore data, you run a Restore Process to insert or load data into a database. The Restore Process is controlled by a Restore Request, which you create using the Restore Request Editor. A Restore Request provides the instructions needed to restore data to a database, listing the Archive File or Archive Files containing the desired data, specifications for restoring all or part of the data, and the method used to restore the data—either the Load or Insert Process.

This section explains how to use the Restore Process.

Scenario Overview

At the start of this scenario, your production database included information for out-of-date orders. You archived a relationally intact set of data from the ORDERS, CUSTOMERS, DETAILS, and ITEMS tables and, to streamline the database, deleted the archived rows from the ORDERS and DETAILS tables.

To accomplish these tasks, you created an Archive Request. In the Archive Request, you specified the Archive Process parameters (such as the Archive File to contain the data) and the Access Definition to be used in the Archive Process. In the Access Definition, you defined the data to copy to an Archive File, selected the tables from which rows were to be deleted, and specified other parameters such as Archive Index information. You then ran the Archive Process and, as part of the Archive Process, deleted archived rows from the ORDERS and DETAILS tables.

Recently, Customer 00026 (Pick-a-Flick from Kissimmee, Florida) called to inquire about an order which you researched, using the Browse Utility, and for which you provided order and ship dates to the customer. After reviewing its records, Pick-a-Flick now disputes this order. Consequently, the order must be restored.

To restore the data, you will: