Advanced Restore Options (Restore)

Use this dialog box to choose additional restore options.

Restore Data

Specifies whether to restore the database based on the selected options.

  • To Point In Time

    Specifies whether the system will recover the database to a specific point in time that you specify. To change the date, click one in the list. Also, use the space to enter the appropriate time. The date and time to which the database is recovered must be later than or equal to the date and time of the control files restore.

    Before using the Restore Data option in combination with the Point-In-Time option to recover the Oracle database to a point-in-time, read Caution on the Use of RESETLOGS in Books Online.

    Tag

    Specifies whether to open the database after the restore/recovery operation has completed. Selecting this option will open the database, and enable the Reset Logs option.

  • From the Latest Backup

    Specifies whether to open the database after the restore/recovery operation has completed. Selecting this option will open the database, and enable the Reset Logs option.

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

  • All

    Specifies that all archive log files will be restored.

  • 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 Log Serial Number

    Specifies that the system will restore the archive log files based on the specified Log Serial 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.

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