How to Determine an SCN at which the Logical Standby assumed Primary Role
(Doc ID 1432993.1)
Last updated on AUGUST 26, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 126.96.36.199.0 [Release 10.2 to 20.0]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
In physical standby dataguard environment, the V$DATABASE.STANDBY_BECAME_PRIMARY_SCN can be used to find the SCN at which physical Standby database became Primary database during role transition.
The new primary (former physical standby) will perform further transactions from this SCN onwards.
This is more difficult in a logical standby dataguard environment because the SCN of logical standby, by design, will not be same as the primary.
It may be necessary to determine the start SCN of a new primary (former logical standby) from where further transactions will be initiated
An SCN after failover, for example, may be needed to reinstate a new standby database.
In addition, Golden Gate may need details for where to start 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