Re: Flashback guaranteed restore point in primary and DR

Posted by ErmanArslansOracleBlog on Dec 31, 2020; 2:19pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Flashback-guaranteed-restore-point-in-primary-and-DR-tp9214p9216.html

you will check the standby scn.. If it is greater then the flashback scn of the primary, then you flashback to standby database to that scn (scn of the guranteed restore point).

In order to find that SCN.. I mean the flashback SCN, you can use the following query as an alternative;

Just after creating the restore point, issue the following sql in the primary..

select scn,NAME from v$restore_point;

This also will tell you the SCN that you will get, when you will flashback your primary in the next steps...