Sometimes, varity business data need create restore point for differ performance test. So how to manange restore point and how to flashback, see the below ->
Restore Point
1 2
#Login sqlplus use sysdba Sqlplus / as sysdba
1 2 3 4 5 6 7 8 9 10 11 12
--list all restore points: SELECTNAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;
-- also simple syntax selectscn, GUARANTEE_FLASHBACK_DATABASE,TIME,namefrom v$restore_point;
--drop old restore point: DROPRESTORE POINT ICC_20160824;
--create new restore point: CREATERESTORE POINT ICC_20160830 GUARANTEEFLASHBACKDATABASE;
Flash Back
1 2 3 4 5 6 7 8
-- flashback.sql
spool flashback.log startup mount; flashback database to restore point "ICC_20161014" alterdatabaseopenresetlogs; spool off exit