First page Back Continue Last page Graphics

...Restore Points...

Notes:

Creating a restore point is done with the CREATE RESTORE POINT statement. In this example, a guaranteed restore point is created, requiring SYSDBA privilege.
Details concerning restore points are recorded in a new view V$RESTORE_POINT.
Refer to Chapter 5 of the Backup and Recovery Basics manual for more information and examples of this feature. Also refer to the Oracle10g SQL Reference manual for the syntax of the CREATE RESTORE POINT statement.
Refer to the supplied script v$restore_point.sql for a copy of this code.