Locate the archive file

After you have specified the options for restoring information, locate the file that contains the customer's orders and add it to the restore request.

Each archive file is stored in the file system location specified for the archive process. In addition, an archive directory entry for the file is created. The directory entry is in the Optim™ directory and includes the:

For the restore process, you can locate archive files and associated indexes automatically, on the basis of information in the archive directory, or you can manually browse the file system. You can then add the file names to the restore request.

List archive file entries

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 Add Archive File(s) > Archive Directory Index.

The Select Archive File(s) and Archive File Filters dialogs open at the same time, with the Archive File Filters dialog active.

Select Archive File(s) dialog and Archive File Filters dialog

The Archive File Filters dialog is the same as that described in Display Archive File Entries. In this case, however, the dialog 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 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 to display the Select Archive File(s) dialog.

Note: Using the filter lists only the file created for this scenario. The Select Archive File(s) dialog used for illustration shows files as though the archive process has run quarterly for several years.
Select Archive File(s) dialog

Using this dialog, you can select entries for files that contain the data to restore. When you select an entry, the file is listed in 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. File status indicates whether the archive or the 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 filter parameters, or by searching files using selection criteria for values within the archived data.

Enter Search Criteria

You can search 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 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.

Index Search Selection Criteria dialog with CUSTOMERS table selected and column criteria set to CUST_ID = '00026'

The Table list provides the names of tables in the 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 file or files that contain the orders, you use a 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 list. For ORDER_ID, select = as the operator and type 375, without delimiters, in the Selection Criteria column.

Search the files

To begin the search, click File > Close. Indexes for the archive files listed on the Select Archive File(s) dialog are searched. If an index is inadequate for the search, the file is also searched. In this scenario, customer ID 00026 is located using the index but the archive file must be searched to determine if order ID 375 is present.

When the search is finished, any files with data that meets the search criteria are listed on the Select Archive File(s) dialog.

Select Archive File(s) dialog with search result

Only the file created earlier in this scenario contains data that matches the search criteria. If, however, you searched indexes for a list of 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 removal of entries for which no match is found.

Select the File

Having limited the list to entries for files that contain matching data, click Select All to list the file in the restore request.



Feedback