Advanced Restore Options (Browse and Restore)

Use this dialog box to restore data and archive logs.

Restore Data

Specifies whether to restore datafiles from the specified full backup. When cleared, the system does not restore datafiles.

Data is restored from the latest full backup only. If you have performed incremental backups and need to apply this data to the full backup, see the description of the Recover option below.

  • To Point In Time

    Specifies that the system will restore data files from the full backup created at or before the point-in-time based on the date and time that you specify. For a Point-in-Time recovery, you should have all log files available up to that time.

    To change the date, click one in the list. Also, use the space to set the appropriate time. Ensure that the date/time that you enter is equal to or later than the date and time that the backup completed. Also, ensure that the date/time to which the datafiles are restored is earlier than or equal to the date and time of the control files restore.

Restore Archive Log

Specifies whether to restore the archive log files.

  • If the archived log files exist in the LOG_ARCHIVE_DEST location and are not corrupted, the backed up archive log files are not restored.
  • If the archive log files do not exist or are unusable, the backed up archive log files are restored to the directory specified in LOG_ARCHIVE_DEST.

When cleared, the system does not restore the archive log files.

  • By Log Time

    Specifies that the archive log files will be restored based on the specified dates and times that you specify.

  • Start

    When selected and used without the End Log Time option, specifies that the system will restore all archive log files starting from the date and time that you specify and up to the current date. When selected and used with the End Log Time option, specifies that the system will restore all archive log files starting from the date and time that you specify and up to the date specified by End Log Time.

    To change the start date, click one in the list. Also, use the space provided to enter a new start time.

  • End

    When selected and used with the Start Log Time option, specifies that the system will restore archive log files starting from the date and time specified by Start Log Time up to the date and time specified by End Log Time. When selected and used without the Start Log Time option, specifies that the system will restore archive log files from the oldest active backed up archive log file up to the date and time specified by End Log Time.

    To change the end date, click one in the list. Also, use the space provided to enter a new end time.

  • By LSN

    Specifies that the system will restore the archive log files based on the specified Log Sequence Numbers (LSNs) that you specify.

  • Start

    When selected and used without the END LSN option, specifies that the system will restore archive log files starting from the log file with the sequence number that you specify in START LSN and ending with the current log file.

    When selected and used with the END LSN option, specifies that the system will restore archive log files starting from the log file with the sequence number that you specify in START LSN and ending with the log file sequence number that you specify in END LSN. Use the space to enter the start LSN.

  • End

    When selected and used without the START LSN option, specifies that the system will restore archive log files from the oldest available archive log file and ending with the sequence number that you specify in END LSN. All the Log Sequence Numbers from log #1 must be backed up to tape. Use the space to enter the end LSN.

  • Auto Detect Device

    For SAP Oracle, specifies whether the system should automatically detect the device that was used for the backup. This field is selected by default. If you have old data, you may need to use the SAP Device Type field below as an alternative.

  • SAP Device Type

    For SAP Oracle, click to manually select the device that was used for backup. If you have old data, you may need to use this field as an alternative to the Auto Detect Device field above.

  • Target Directory

    Use this space to type the specified destination directory to which the archive log files will be restored. Alternatively, click Browse for this purpose.

    If you leave this field blank, the archive log files are restored to the LOG_ARCHIVE_DEST location.

  • Browse

    Click to establish the directory for restoring the archived log files.