
-- create a guarantee restore point
SQL> create restore point {name} guarantee flashback database;


> sqlplus / as sysdba;
> select current_scn from v$database;
> shutdown immediate;
> startup mount;
> select * from v$restore_point;
> flashback database to restore point CLEAN_DB;