Create Restore point:
% sqlplus “/as sysdba”
SQL> shutdown immediate;
SQL> startup mount;
SQL> CREATE RESTORE POINT 'abc_hg’ GUARANTEE FLASHBACK DATABASE;
SQL> alter database open;
SQL> select scn from v$restore_point where name = 'abc_hg';
SQL> select current_scn from V$database;
% sqlplus “/as sysdba”
SQL> shutdown immediate;
SQL> startup mount;
SQL> CREATE RESTORE POINT 'abc_hg’ GUARANTEE FLASHBACK DATABASE;
SQL> alter database open;
SQL> select scn from v$restore_point where name = 'abc_hg';
SQL> select current_scn from V$database;
No comments