Flashback guaranteed restore point in primary and DR

[baig]

Hi, Erman,

hope you are doing good.

I am in a scenario where i have enabled flashback and set a guaranteed restore point for cutover of adop patching cycle.

I have set it on both primary and DR database.


my question is  when we open the primary database to a guaranteed restore point, we will open the database with open reset logs. then the counter starts from 1.
how to bring the dr database archive log sequence same as primary. because we are not performing reset logs on the dr as per the document ID Note 728374.1 How to Flashback Primary in Standby Configuration
===================
In same doc ID,

In step 6. Check current_scn on the standby database, If flashback scn is greater than current_scn then skip the next step (step 7).

here in step 6 the If flashback scn is greater than current_scn then skip the next step (is it referring to flashback_scn of primary or standby database.) because we didnt observe the current_scn of dr database before setting the primray to guaranteed restore point.

Please advise.
====================

[ErmanArslansOracleBlog]

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...

[baig]

Hi,

Thanks for the clarification.

when we open the primary database to a guaranteed restore point, we will open the database with open reset logs. then the counter starts from 1.
how to bring the dr database archive log sequence same as primary. because we are not performing reset logs on DR database.

can you please explain about how to get the sequence of dr same as primary after reset logs.

thanks again.
 

[ErmanArslansOracleBlog]

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