The RESTORE Statement

This is an optional command used to specify a single point in time the tables specified in the command file should be restored to.

Syntax

>>-RESTORE--+----------------------------------+---------------><
            '-TO--+-"time"--+--+-------------+-'
                  '-CURRENT-'  '-WITH NO LOG-'
 

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.

Example

RESTORE TO CURRENT WITH NO LOG;