Flashback db using restore point - oracle database script

Flashback db using restore point - Oracle Database Script.

--- Below are the steps for flashback database to a guaranteed restore point;  1. Get the restore point name:  SQL> select NAME,time from v$restore_point;  NAME                                                            TIME --------------------------------          ----------------------------------------------- GRP_1490100093811                         21-MAR-17 03.41.33.000000000 PM  2. Shutdown database and start db in Mount stage:  shutdown immediate; startup mount;  3. flashback db to restore point:  flashback database to restore point GRP_1490100093811;  4. Open with resetlog:  alter database open resetlogs: