Flash-forward Oracle database to restore Point - Moving back and forth with time without resetlogs

We  had  requirement to flashback database to   take export   backup of table having issues 

We All know we can flashback database  to restore point but  less we knew  that we can also flash forward database to restore point .   Thanks to blog posted in reference link  we came to  know we can  also flash forward  database to  restore point . 

We  have performed this steps on  standby  though we can perform same on production too 

 

Below are steps performed  this 

1)   Enable Flashback database  and create restore point One 

2)   Application perform deployment and Notice  they need to flashback 

-->  flashback  

3) Before we flash back database  Create  new restore point Two
4) Flashback to  restore point One

5) Perform sanpshot standby  to   take expdp  of table we need that has incorrect records  .

6) Convert to physical standby once  export is done

--> flash forward 

7) Finally Flash  forward Standby to Restore point Two created in Step 1 
 



Sample Commands :

--> Create restore point 

SQL> create restore point one  guarantee flashback database;

--> Flashback database 

RMAN> flashback database to restore point one ;

Or

SQL> flashback database to restore point one;

--> Flash forward database 

RMAN> recover database to restore point two ;

Or 

RMAN> flashback database to restore point two;

Reference :
https://www.pythian.com/blog/technical-track/flashback-and-forth