A number of new database fixed V$ views have been added in Oracle Data Guard 23ai that are very useful in monitoring an Oracle Data Guard environment.
V$DG_BROKER_CONFIG view provides an overall summary of an Oracle Data Guard broker configuration.
The view provides the similar information which the Data Guard BrokerSHOW CONFIGURATION command provided. It provides a view of the entire Oracle Data Guard broker configuration while connected to any database which is a part of the configuration.
Note the definition of the V$DG_BROKER_CONFIG view as it existed in Oracle 19c.
In Oracle Database 23ai, a number of additional columns have been added to the V$DG_BROKER_CONFIG view like SWITCHOVER_READY, FAILOVER_READY, CURRENT_STATE etc.
SQL> select database, dataguard_role, status, severity, switchover_ready, failover_ready, transport_mode
from v$dg_broker_config;
DATABASE DATAGUARD_ROLE STATUS SEVERITY SWITCHOVER_READY FAILOVER_READY TRANSPORT_MODE
___________ ___________________ _________ ___________ ___________________ _________________ _________________
orcl PRIMARY 0 SUCCESS YES UNKNOWN -N/A-
orcl_sb PHYSICAL STANDBY 0 SUCCESS YES YES ASYNC
The V$DG_BROKER_PROPERTY view provides information about the entire Data Guard configuration at both the individual member level as well as the top level configuration level.
SQL> select member,instance,DATAGUARD_ROLE,PROPERTY, value from V$DG_BROKER_PROPERTY;
MEMBER INSTANCE DATAGUARD_ROLE PROPERTY VALUE
------------------------------- ----------------- ------------------ ------------------------------- ----------------------------------------------------------------------------------------------------
ORCL_DG N/A CONFIGURATION FastStartFailoverThreshold 30
ORCL_DG N/A CONFIGURATION OperationTimeout 30
ORCL_DG N/A CONFIGURATION TraceLevel USER
ORCL_DG N/A CONFIGURATION FastStartFailoverLagLimit 30
ORCL_DG N/A CONFIGURATION CommunicationTimeout 180
ORCL_DG N/A CONFIGURATION ObserverReconnect 0
ORCL_DG N/A CONFIGURATION ObserverPingInterval 0
ORCL_DG N/A CONFIGURATION ObserverPingRetry 0
ORCL_DG N/A CONFIGURATION FastStartFailoverLagGraceTime 0
ORCL_DG N/A CONFIGURATION FastStartFailoverAutoReinstate TRUE
ORCL_DG N/A CONFIGURATION FastStartFailoverPmyShutdown TRUE
ORCL_DG N/A CONFIGURATION BystandersFollowRoleChange ALL
ORCL_DG N/A CONFIGURATION ObserverOverride FALSE
ORCL_DG N/A CONFIGURATION ExternalDestination1
ORCL_DG N/A CONFIGURATION ExternalDestination2
ORCL_DG N/A CONFIGURATION PrimaryLostWriteAction CONTINUE
ORCL_DG N/A CONFIGURATION ConfigurationWideServiceName orcl_CFG
ORCL_DG N/A CONFIGURATION ConfigurationSimpleName ORCL_DG
ORCL_DG N/A CONFIGURATION DrainTimeout 0
ORCL_DG N/A CONFIGURATION FastStartFailoverLagType APPLY
ORCL_DG N/A CONFIGURATION PrimaryDatabaseCandidates
orcl_sb N/A PRIMARY DGConnectIdentifier sydney:1521/orcl_sb
orcl_sb N/A PRIMARY ObserverConnectIdentifier
orcl_sb N/A PRIMARY FastStartFailoverTarget
orcl_sb N/A PRIMARY PreferredObserverHosts
orcl_sb N/A PRIMARY LogShipping ON
orcl_sb N/A PRIMARY RedoRoutes
orcl_sb N/A PRIMARY LogXptMode ASYNC
orcl_sb N/A PRIMARY DelayMins 0
orcl_sb N/A PRIMARY Binding OPTIONAL
orcl_sb N/A PRIMARY MaxFailure 0
orcl_sb N/A PRIMARY ReopenSecs 300
orcl_sb N/A PRIMARY NetTimeout 30
orcl_sb N/A PRIMARY RedoCompression DISABLE
orcl_sb N/A PRIMARY PreferredApplyInstance
orcl_sb N/A PRIMARY ApplyInstanceTimeout 0
orcl_sb N/A PRIMARY ApplyLagThreshold 30
orcl_sb N/A PRIMARY TransportLagThreshold 30
orcl_sb N/A PRIMARY TransportDisconnectedThreshold 30
orcl_sb N/A PRIMARY ApplyParallel AUTO
orcl_sb N/A PRIMARY ApplyInstances 0
orcl_sb N/A PRIMARY ArchiveLocation
orcl_sb N/A PRIMARY AlternateLocation
orcl_sb N/A PRIMARY StandbyArchiveLocation
orcl_sb N/A PRIMARY StandbyAlternateLocation
orcl_sb N/A PRIMARY InconsistentLogXptProps (monitor)
orcl_sb N/A PRIMARY LogXptStatus (monitor)
orcl_sb N/A PRIMARY SendQEntries (monitor)
orcl_sb N/A PRIMARY RecvQEntries (monitor)
orcl_sb N/A PRIMARY LsbyFailedTxnInfo (monitor)
orcl_sb N/A PRIMARY UserManagedParams
orcl_sb N/A PRIMARY StaticConnectIdentifier (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sydney.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME
=orcl_sb_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))
orcl_sb N/A PRIMARY TopWaitEvents (monitor)
orcl_sb N/A PRIMARY SidName (monitor)
54 rows selected.
V$DG_BROKER_ROLE_CHANGE displays information about the last ten role changes across a Data Guard broker configuration.
We can see when was the last time a Data Guard Switchover and Failover has been performed as well as information about the start and end time of the role change operations.
The Data Guard switchover in Oracle Database 23ai now shows additional information about stages in the switchover (like timestamp of various stages in the role change).
DGMGRL> switchover to orcl;
2025-04-25T03:45:10.535+00:00
Performing switchover NOW, please wait...
2025-04-25T03:45:10.542+00:00
Operation requires a connection to database "orcl"
Connecting ...
Connected to "orcl"
Connected as SYSDBA.
2025-04-25T03:45:10.629+00:00
Continuing with the switchover...
2025-04-25T03:45:17.135+00:00
New primary database "orcl" is opening...
2025-04-25T03:45:17.135+00:00
Operation requires start up of instance "orcl" on database "orcl_sb"
Starting instance "orcl"...
Connected to an idle instance.
ORACLE instance started.
Connected to "orcl_sb"
Database mounted.
Database opened.
2025-04-25T03:45:29.627+00:00
Switchover succeeded, new primary is "orcl"
2025-04-25T03:45:29.630+00:00
Switchover processing complete, broker ready.
SQL> select EVENT, OLD_PRIMARY, NEW_PRIMARY, BEGIN_TIME, END_TIME from V$DG_BROKER_ROLE_CHANGE; EVENT OLD_PRIMARY NEW_PRIMARY BEGIN_TIME END_TIME ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- ---------------------------------------- Switchover orcl_sb orcl 25-APR-25 03.45.10.000000000 AM 25-APR-25 03.45.22.000000000 AM
