Browse Data – Oracle iDataAgent

Table of Contents

Understanding the Browse Window

Browse Data

Latest Data

Data Before a Specified Time

Browse from Copies

List Media

Image/No-Image Browse

Establish the Page Size for a Browse

Browse Database Tables

Browse Using MediaAgent

Understanding the Browse Window

Browse provides an easy-to-use convenience to search and restore data.

You can open the browse window from client, agent, instance or subclient level. The sub levels displayed in the browse window is based on where you start the browse operation.

Selecting Objects From the Browse Window for Restore

The browse window displays objects and consists of two parts:

Note that the window displays only the data that was obtained by a backup. Data that is excluded by a filter, or data which did not exist as of the specified browse time does not appear in the window.

Selections follow these rules:

Selection status is revealed by the selection icons as follows:

Indicates that the object is not selected for restoration.
Indicates that a portion of the object is selected for restoration. i.e., only some of the child object(s) within the selected object.
Indicates that the entire object, including all of its child objects, are selected for restoration.

Browse Data

The option to browse the backup data provides the facility to view and restore the data that was backed up. The following sections explain how to browse the backup data.

Latest Data

Follow the steps given below to view the latest data backed up by a backup set:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. Click OK.

The latest data backed up by all the subclients is displayed in the Client Browse tab.

Data Before a Specified Time

Follow the steps given below to browse the data backed up before specified time:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. Select Specify Browse Time.
  2. Select a date and time to Browse Data Before it.
  3. Click OK.

Browse from Copies

By default, when a browse operation is requested, the software attempts to browse from the storage policy copy with the lowest copy precedence. If the data that you want to browse was already pruned from the primary copy, the software searches the other copies of the storage policy, starting from the copy with the lowest copy precedence to a copy with the highest copy precedence.

This feature is useful in the following conditions:      

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, click Advanced.
  2. In the Advanced Browse Options dialog box select the Browse from copy precedence option.
    If you specify a copy precedence number for a browse operation, the software searches only the storage policy copy with that precedence number in all storage policies used for securing the data. If data does not exist in the specified copy, the browse operation fails even if the data exists in another copy of the same storage policy.
  3. Specify the precedence number in Copy Precedence.
  4. Click OK in the Advanced Browse Options dialog box .
  5. Click OK in the Browse Options dialog box.

List Media

List media option is useful to predict media required to restore the index required to browse data. This is useful when the index is not available in the index cache.

The following section describes how to perform this operation.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, if required, select the following options:
    • Click Browse the Latest Data to list media associated with the most recent data protection cycle.
    • Click Specify Browse Time to list media associated with data protection operations up to the specified date and time range. Use the Browse Data Before box to specify the end date and time.
    • Click Advanced and then click Exclude Data Before and then select the date and time from which you wish to list media associated with data protection operations.
  2. Click List Media.
  3. From the List Media dialog box, select the media you wish to recall and click Recall Media.
  4. From the Recall Media dialog box General tab, select the following:
    • The time until which the media would be retained in the library for read operations.
    • A reason for recalling the media.
  5. From the Destination tab, configure the following destination options:
    • Click the Track Transit option and select the transit location from the list, to track the transit information.
    • Select the desired Destination.
    • If desired, select the Move Media to Overwrite Protection Pool option along with the desired pool to which the media will be moved.
    • Select Acknowledge the action as Reached Destination automatically if desired.
  6. Click OK.

Image/No-Image Browse

Image browse displays the structure of the entity as it existed as of some specified time. When you browse data in the image mode, the system by default returns the requested data based on the latest image available. The image browse can only restore the latest version. If the requested version was deleted before the most recent full backup, the default browse will not find the data.

The no-image browse is useful for retrieving data that may have been deleted at some unknown time. It is also useful to retrieve a previous backup version.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, select one of the following options:
    • Click and select the Show Deleted Items option to perform a no-image browse of the data.
    • Clear the Show Deleted Items option to perform an image browse of the data.
  2. Click OK.

Establish the Page Size for a Browse

The Page Size option allows you to specify the number of objects to be displayed in the browse window. You can browse through each page list by selecting the appropriate page number in the Browse window. This field reverts back to the default setting after use.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, enter a value for Page Size.
  2. Click OK.

Browse Database Tables

This option displays the backup data as database tables of each user in a tree view during the browse operation and allows selecting multiple tables to restore them to a destination location.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, click and select Table View.
    In order to browse and restore the database tables, you must run a full backup of the entire database with the Enable Table Browse option enabled at the Subclient level.

    See, Enabling Table Browse for Restores for more information.

  2. Click OK.

    You can restore the data as database tables as described in Restoring Tables to a different Host.

Browse Using MediaAgent

Data can be restored from any compatible library and drive type in the CommCell. By default, the system automatically identifies and restores data from any configured library in the CommCell, even if the media is not available in the original library in which the data protection operation was performed. Use this procedure to Browse using a specific MediaAgent.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle
  2. Right-click a Instance and click All Tasks | Browse/Browse Backup Data.
  1. From the Browse Options dialog box, choose the MediaAgent that must be used to perform the browse.
  2. Click OK.