At which SCN The Logical Standby became Primary (equivalent of STANDBY_BECAME_PRIMARY_SCN in V$DATABASE in Physical Standby setup)
Last updated on MARCH 19, 2012
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 126.96.36.199 - 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms