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:
- If the need arises, you can restore archived data
to the production database so that your application can access the
information.
- If archived data is required for analysis or reporting,
you can restore the data to a staging database.
- If the data model has changed, you can restore archived
data to the new model or to a different database.
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:
- Open the Restore Request Editor.
- Define Restore Process options.
- Locate the Archive File that contains the customer's
orders and add it to the Restore Request.
- Define the subset of data to restore by applying
local selection criteria and modifying the Access Definition.
- Select the Insert Process as the restore method.
- Create an Insert Request.
- Run the Restore Process.
- Open the Restore Request Editor
To
restore archived data, first open the Restore Request Editor.
- Locate the Archive File
After
you have specified the options for restoring information, locate the
Archive File that contains the customer's orders and add it to
the Restore Request.
- Apply Local Selection Criteria
After
you locate the Archive File from which you want to restore data, refine
the subset of data to restore by applying local selection criteria
and modifying the Access Definition.
- Modify the Access Definition
Define
the subset of data to rstore by applying local selection criteria
and modifying the Access Definition.
- Choose a Restore Method — Insert or Load
After
adding the Archive File name, establishing local selection criteria,
and modifying the Access Definition, you must select the method used
to restore the data to the database.
- Specify Insert Process Parameters
In
the Restore Request Editor, select Insert as the Restore Process option.
- Run the Restore Process
After
you specify the insert process parameters for the Restore Process,
you are ready to run the Restore.