Browse and Restore – PostgreSQL iDataAgent

Restore Data Browse and Restore
Table of Contents

Understanding the Restore Options Window

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

You can open the browse and restore window from the:

  • DumpBasedBackupSet - backupset and subclient levels
  • FSBasedBackupSet - backupset level

The sub levels displayed in the result window is based on where you start the browse operation.

Selecting Objects from the Restore Window for Restore

The restore window displays objects and consists of two parts:

  • The left pane displays the object tree at the selected level.
  • The right pane displays the contents of the selected object.

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:
  • All selections are recursive.
  • Clicking a box again causes the selection to be cleared.
  • If you select an object in the left pane, then all of its contents are selected.
  • You can select a specific object in the right pane.

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 and Restore 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> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. Click View Content.

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

Browse and Restore Data before a Specified Backup Time

Follow the steps given below to browse the data backed up before specified time. This will display data from all cycles that fall under the specified time range.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. Select Time Range.
  2. Under Absolute Time do the following:
    1. Select the Time Zone.

      For Oracle agents the default Time Zone is the client's time zone. For all other agents the default Time Zone is the CommServe time zone.

    2. Select End Time and enter a date and time to browse and restore data before it.
  3. Click View Content.

Browse and Restore Data between a Specified Backup Time

You can select Start Time and End Time to browse and restore data between a specified backup time.

Follow the steps given below to browse data between specified time:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. Select Time Range.
  2. Under Absolute Time do the following:
    • Select Start Time and enter a date and time.
    • Select End Time and enter a date and time.

    Data in between the time specified here will be browsed and restored.

  3. Click View Content.

Note: Start Time check box is disabled for FSBasedBackupSet. So you will not be able to browse and restore data between a specified backup time for FSBasedBackupSet.

Browse and Restore Data Backed Up in the Past n Days

You can specify a relative time for Browsing data for Restores. This provides flexibility in trawling backed up data from a wider time span rather than the need to remember an exact time range in which something was backed up.

Follow the step given below to Browse Data from a relative time:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. Select Time Range and click Relative Time.
  2. Enter a number in the Last field and select Day, Week, Month or Year to browse and restore data.
  3. Click View Content.

Note: Relative Time check box is not present for FSBasedBackupSet. So you will not be able to browse and restore data backed up in the past n days for FSBasedBackupSet.

Browse and Restore 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:      

  • The media containing protected data for a particular copy has been removed from the storage library, you can choose to browse from a copy whose media are inside the library.
  • Allows browsing from a copy that accesses faster disk media rather than slower tape media.
  • When media drives used by a particular copy are busy with another operation, this helps in browsing from a different copy to avoid resource conflicts.
  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  3. From the Restore Options dialog box, click the Advanced Options tab.
  4. Select the Browse from copy precedence check box.

    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.

  5. Specify the precedence number in Copy Precedence.
  6. Click View Content.

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.

This option is also used to list media associated with data protection operations up to the specified date and time range.

The following section describes how to perform this operation.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  3. Click List Media.
  4. The appropriate media is listed in the Media dialog box.
  5. Click Close.

Image and No-Image Browse and Restore

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 and show deleted files across cycles.

For PostgreSQL iDataAgent, Show Deleted Items is always selected by default and is grayed out.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. From the Restore Options dialog box, click the Advanced Options tab and 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 View Content.

Browse and Restore 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.

If a MediaAgent is selected for browse, the library and media that are required for restore operation must be accessible to this MediaAgent for restore. The Restore may fail if it is not accessible.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. From the Restore Options dialog box, click the Advanced Options tab and choose the MediaAgent that must be used to perform the browse.
  2. Click View Content.

Browse Database Tables

During the browse operation, selecting the Table View check box displays the backup data as database tables of each user in a tree view. It allows selecting multiple tables to restore them to a destination location.

Note: Table View check box is not present for FSBasedBackupSet. So you will not be able to browse database tables for FSBasedBackupSet.

  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL | <Instance>.
  2. Right-click the <BackupSet>, and then click All Tasks | Browse and Restore.
  1. From the Restore Options dialog box, select the Table View check box.
  2. Click View Content.