Flashback RAC Standby Database to SCN

This was happened on One of the Production database where non guaranteed restore point was created on Primary database without keeping DR on delay/Apply-off. 

We did below steps to bring standby sync with production after flashback to restore point on primary database.

First we need to flashback production database to restore point, We have to make standby to same as production restore point created.

production database Flashback :

SELECT NAME,SCN,TIME,DATABASE_INCARNATION#,GUARANTEE_FLASHBACK_DATABASE,STORAGE_SIZE FROM V$RESTORE_POINT;

NAME                                         SCN     TIME                              DATABASE_INCARNATION# GUA STORAGE_SIZE
------------------------------ ---------- ----------------------------------------------------------------------
DGB_RP_01292021_074242       1270795312 29-JAN-21 07.42.42.000000000 AM  1                       NO   0

• Whenever you do flashback production at that time stop MRP and shutdown standby.

               dgmgrl > EDIT DATABASE 'orcldr' SET STATE='APPLY-OFF';

• Shutdown all standby instances and bring only one node in mount mode.

                        srvctl stop database -d orclpr

                        srvctl start instance -d orclpr -i orclpr1 -o mount

                        srvctl status instance -d orclpr -i orclpr1

• Connect SQLplus and execute below statement for flashback database.

                 FLASHBACK STANDBY DATABASE TO SCN 1270795312;

• Restart db and start database on all nodes.

                 srvctl stop database -d orclpr

         srvctl start database -d orclpr       

So, once we succesfully flashback the primary database , we need to  flashabck the standby database to same scn.

• Shutdown all standby instances and bring only one node in mount mode.      

                        srvctl stop database -d orcldr

                        srvctl start instance -d orcldr -i orcldr1 -o mount

                        srvctl status instance -d orcldr -i orcldr1

• Connect SQLplus and execute below statement for flashback database. (Primary database SCN-2 )

                 FLASHBACK STANDBY DATABASE TO SCN 1270795310;

• Restart db and start database on all nodes.

                 srvctl stop database -d orcldr

                 srvctl start database -d orcldr
      

• Start MRP service and check dr sync status.

                     EDIT DATABASE 'orcldr' SET STATE='APPLY-ON';

NOTE :  If archivelog not present in Primary database then we need to restore it from the Backup  first then need to follow all above steps.