Step 7. Specify Point in Time

At this step of the wizard, do either of the following:

Select the Restore to the latest available state option to restore data as of the latest available state.
Select the Restore to the following point in time option to select a state as of which you want to restore data:

Note

The behavior of the wizard depends on the option you selected at the Specify Oracle Settings step:

If you selected the Restore with different name and settings option, you can proceed to the next step after you select a point in time with control file autobackups.
If you selected the Restore with the original name and settings option, you can proceed to the next step regardless of the date and time you specify. However, consider the following:

If a backup exists for the selected point in time, Veeam Explorer for Oracle uses this backup for the restore operation.
If no backup exists for the selected point in time, Veeam Explorer for Oracle uses the latest available backup for the restore operation.
If no backup exists for the selected point in time and no earlier backups are available, the restore operation fails.

Select the SCN option to specify the SCN (System Change Number) of the required state.
Select the Sequence option to specify the log sequence number of the required state.

Select the Generate new DBID check box to generate a new DBID in addition to the new database name.

This check box is available only when using the Restore with different name and settings option at the Specify Oracle Settings step.

Select the Suppress RESETLOG command and do not bring the database online check box to skip the OPEN RESETLOGS operation if it was required by the database. The database in this case remains in the mount state.

This check box is available only when using the Restore with the original name and settings option at the Specify Oracle Settings step.

Tip

For more information on RMAN point-in-time restore settings, see the Oracle documentation.

Step 7. Specify Point in Time