Last updated on MARCH 19, 2012
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 188.8.131.52 - Release: 10.2 to 11.2
Information in this document applies to any platform.
What is the equivalent for Logical Standby Dataguard setup ? This is because, in Logical Dataguard setup, the SCN of logical standby can not be same as Primary as per design. Column V$DATABASE.STANDBY_BECAME_PRIMARY_SCN indicates the Primary database SCN. However, we need to identify the starting SCN of new primary (former logical standby) from where further transactions would happen.
This SCN may be needed, for example, after switchover, Golden Gate need to be instructed to start from archived log having that SCN from the new primary (former Logical Standby).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms