My Oracle Support Banner

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: to - Release: 10.2 to 11.2
Information in this document applies to any platform.


In Physical Standby Dataguard setup, We can use V$DATABASE.STANDBY_BECAME_PRIMARY_SCN 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.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.