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.
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.
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.
Specifies that datafiles will be restored from the latest full backup.
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 archived redo log files.
When cleared, the system does not restore the archived redo log files.
Specifies that the archived redo log files will be restored based on the specified dates and times that you specify.
When selected and used without the End Log Time option, specifies that the system will restore all archived redo 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 archived redo 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.
When selected and used with the Start Log Time option, specifies that the system will restore archived redo 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 archived redo log files from the oldest active backed up archived redo 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.
Specifies that the system will restore the archived redo log files based on the specified Log Sequence Numbers (LSNs) that you specify.
When selected and used without the END LSN option, specifies that the system will restore archived redo 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 archived redo 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.
When selected and used without the START LSN option, specifies that the system will restore archived redo log files from the oldest available archived redo 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.
Use this space to type the specified destination directory to which the archived redo log files will be restored. Alternatively, click Browse for this purpose.
If you leave this field blank, the archived redo log files are restored to the LOG_ARCHIVE_DEST location.
Click to establish the directory for restoring the archived log files.