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:
--- 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: