How To Create a Restore Point On Oracle

dbtut

7 years ago

With the flashback database we can use the restore point to return the database to a time in the past.

For more detailed information about the Flasback Database you can read the article “What is FLASBACK DATABASE And How To FLASHBACK”

With the command below, create a restore point while the database is in mount mode.

create restore point restore_point_name [GUARANTEE FLASHBACK DATABASE];

1	create restore point restore_point_name [GUARANTEE FLASHBACK DATABASE];

You can list existing restore points with the help of the following script.

SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,
GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE 
FROM V$RESTORE_POINT;

SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,

GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE

FROM V$RESTORE_POINT;

You can also delete an existing restore point using the following script.

DROP RESTORE POINT restore_point_name;

1	DROP RESTORE POINT restore_point_name;