FLASHBACK RESTORE POINT:
=======================
Restore point plays important role in restore and recovery scenario as it allows to store the state of the database to a certain point.
The database must have a fast recovery area (FRA) set for the guaranteed restore point
The database is in Archive log mode (guaranteed restore point)
— To create a guarantee flashback restore point;
SQL>create restore point BEFORE_TEST guarantee flashback database;
— Check the restore_points present in database
SQL>select * from v$restore_point;
— Drop restore point;
SQL> drop restore point BEFORE_TEST;
— 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
——————————– ———————————————–
RELEASE_15_4_1_136 11-JUN-21 07.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 RELEASE_15_4_1_136;
4. Open with resetlog:
alter database open resetlogs:
