At which SCN The Logical Standby became Primary (equivalent of STANDBY_BECAME_PRIMARY_SCN in V$DATABASE in Physical Standby setup)
(Doc ID 1432993.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 220.127.116.11 - 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).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document