Advanced Restore (Restore)

Advanced Restore (Restore)

Use this dialog box to restore data and archive logs. Note that all the options described in this help may not be available and only the options displayed in the dialog box are applicable to the agent or feature for which the information is being displayed.

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.

  • Tag

    Specifies that the backup tag assigned to the specific backup that you want to restore will be entered. Tags are constructed at the time of backup. Since data is restored from full backups only, ensure that the tag you select is the tag for a full backup. Use the space to type the backup tag.

  • From the Latest Backup

    Specifies that datafiles will be restored from the latest full backup.

  • Check READ ONLY

    Specifies whether the read-only tablespaces are checked for consistency. If the tablespaces are not consistent, or if they are missing, they are restored. Otherwise, they are not restored.

    When cleared, the read-only tablespaces are not checked for consistency and restored from the backup.

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

    Restore to the log time.

    Select By Log Time and enter the Start and End time in the boxes.

    If you are including the database in the restore, see Restoring to a Point-in-Time for Oracle to restore the database to a specific point-in-time.

  • Start

    Select the start time and start date.

    If you only specify the start log time and not the end log time, the system restores all logs from the start time to the current time.

  • End

    If you specify the end time, the all logs are restored from  the start to the end 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 for 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 for 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.

  • By Tag

    Specifies that the system will restore the archive log files based on the tag name that you specify. Use the space provided to enter the tag name.

  • 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.