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 MARCH 19, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Goal

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).


Solution

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