Step 7. Specify Point in Time

At this step of the wizard, do 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:
  • Select the Date option to specify the date and time of the required state.
  • 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 about RMAN point-in-time restore settings, see the Oracle documentation.

Specifying Point-in-Time

Page updated 12/13/2024

Page content applies to build 12.3.0.310