I am using oracle11g R2 active data guard. I am testing the manual(no broker) failover scenario. After failover,
i need to flashback to SCN where it was failed over and convert the failed primary to standby database.
I can use the below query to find the scn and flashback to this SCN and restart the database as standby database.
SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;
My question is, I need to ensure, there is no archive logs missing when i failover before i flashback. How do i check this ?
For instance, Primary is crashed at archive log sequence#10 and failed over to standby. At the time of failover, the max log sequence in standby(new primary)
database is 8. After failover, if we flashback to SCN 8, then we will miss the two log sequence.In this case, i don't want to flashback. I manually, find the missing data
in failed primary database.
Any input is highly appreciated.