Importing Log Backups up to a Specific Time 

You can start the standby instance in a specific state from the past. You may need to do this if, for example, you lose data during an operation in the original instance, and want to restore the state of the data before the error.

Prerequisites

·        You have set up a standby instance.

·        The shadow instance has not been in the operational state ONLINE since it was last initialized.

·        You have imported log backups from the original instance only up to a point in time before your chosen restore time.

Procedure

If the log backups are imported automatically from the original instance into the standby instance, then cancel the imports (recover_cancel), and import manually any log backups that are missing, up until your chosen time. Proceed as follows:

·        When you import the log backup for the relevant point in time in the Database Manager GUI, choose the option Restore until a specific time (see also Restoring Without a Backup History).

·        When you import the log backup for the relevant point in time in the Database Manager CLI, use the command recover_start with the option UNTIL <date> <time> (see also Commands for Restoring).

Result

The log entries are imported into the standby instance up to the chosen time. Any changes you have made after this time in the original instance are ignored by the standby instance.

You can now start operating the standby instance as an active instance.