How do we ensure all log are applied before flashback?

[shrinika]

Tim,

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.

[Tim...]

Hi.

Once you have failed over to the standby and started that up, that is your new primary database, so any logs that were missed before starting up the standby as the primary server are now irrelevant. That data is lost.

Cheers

Tim...

[shrinika]

Thanks!!

[Tim...]