Re: Flashback guaranteed restore point in primary and DR

Posted by ErmanArslansOracleBlog on Jan 03, 2021; 8:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Flashback-guaranteed-restore-point-in-primary-and-DR-tp9214p9221.html

What counter are you talking about?

This is what resetlogs does: "Archives the current online redo logs (or up to the last redo record before redo corruption if corruption is found), clears the contents of the online redo logs, and resets the online redo logs to log sequence 1. So it is based on log sequence numbers.
You on the other hand, equalize the SCNS, by taking the actions in the document "How To Flashback Primary Database In Standby Configuration (Doc ID 728374.1)" .

->

Flashback primary database to a specified scn
SQL>FLASHBACK DATABASE TO SCN <scn_number>;

Open primary database with reset logs.
SQL> ALTER DATABASE OPEN RESETLOGS;

Check current_scn on the standby database
SQL> SELECT CURRENT_SCN FROM V$DATABASE;

Flashback Standby database ((if it is greater than the scn of the primary flashback scn)
SQL>FLASHBACK STANDBY DATABASE TO SCN <scn_number -2>; (on standby database)

Start managed recovery on the standby database
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION