The RESTORE statement
The RESTORE statement is an optional command to restore tables to a specific point in time.
Syntax
| Element | Description |
|---|---|
| "time" | The date and time the table is to be restored to. |
Usage
The TO clause is used to restore the table to a specific point in time, which is specified by a date and time or the reserved word CURRENT.
Only one RESTORE statement can be specified in a command file. If this statement is not present in the command file, then the system will be restored to the most current time using logical logs.
If the WITH NO LOG clause is present, only a physical restore is performed. In addition, the two extra columns and the index are not added to the destination table. Physical-only restores are based on level-0 archives only.
Tip: Use this option when you do not have logical logs. You
will not receive any messages about logical recovery.
Example
RESTORE TO CURRENT WITH NO LOG;