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.
For each Archive Process, Archive stores the Archive File in the file system location you specify. In addition, Archive creates an Archive Directory entry for the Archive File. The Archive Directory entry is in the Optim™ Directory and includes the:
For the Restore Process, you can locate Archive Files and associated Archive Indexes automatically, on the basis of information in the Archive Directory, or you can manually browse the file system. You can then add the Archive Files to the Restore Request.
The first step in locating an Archive File that contains a customer's orders is to right-click the Archive Files grid in the Restore Request Editor and click .
The Select Archive File(s) and Archive File Filters dialogs open at the same time, with the Archive File Filters dialog on top.
The Archive File Filters dialog is the same as that described in page Display Archive File Entries. In this case, however, it is used to limit the list of Archive File entries displayed in the Select Archive File(s) dialog. By entering patterns and text in the appropriate boxes, you can list entries for Archive Files that meet all filter criteria. Type ORDERS in the Group filter. Accept the wildcard entered by default for the remaining filters and click OK. The Select Archive File(s) dialog is displayed.
You use this dialog to select entries for Archive Files that contain the data to restore. When you select an entry, the Archive File is listed on the Restore Request.
In addition to the information from the Archive Directory, the status of the associated Archive File and the search status of the entry are displayed. Archive File status indicates whether the Archive File or the Archive Index File is accessible. Search status indicates the result of searching the file or index.
Moreover, you can further refine the list of entries by specifying Archive File Filter parameters at the bottom of the dialog, or by searching Archive Files using selection criteria for values within the archived data.
You can search Archive Files for which entries are listed on the Select Archive File(s) dialog. By entering column criteria or SQL Where clauses for a table, you can find Archive Files that contain specific data.
In the Select Archive File(s) dialog, right-click the grid and select Search All from the shortcut menu. The Index Search Selection Criteria dialog is displayed.
The Table drop-down list provides the names of tables in the Archive Files for which entries are listed on the Select Archive File(s) dialog. Because you want to restore orders for a specific customer, select CUSTOMERS.
In this scenario, you want to restore data for an order placed by Pick‑a‑Flick, which is identified by customer ID 00026. To locate the Archive File(s) that contain the orders, you will use this value as search criteria. For CUST_ID, click the Operator column and select =. Then type 00026 in the Selection Criteria column.
In addition, to obtain the disputed order and related details, select ORDERS from the Table drop-down list. For ORDER_ID, select = as the operator and type 375, without delimiters, in the Selection Criteria column.
To begin the search, click from the menu. Archive searches Archive Indexes for the Archive Files listed on the Select Archive File(s) dialog. If an Archive Index is inadequate for the search, the Archive File is also searched. In this scenario, Archive locates customer ID 00026 using the Archive Index File but must search the Archive File to determine if order ID 375 is present.
When the search is finished, Archive Files with data that meets the search criteria are listed on the Select Archive File(s) dialog.
Only one Archive File, the file created earlier in this scenario, contains data that matches the search criteria. If, however, you searched indexes for a list of Archive Files as described in List Archive File Entries and matching data was found in two or three files, entries for those files would remain on the list.
Selecting the Automatically Trim Search List check box in Personal Options causes Archive to remove entries from the list for which no match is found.