V$DG_BROKER_CONFIG

V$DG_BROKER_CONFIG provides a summary of an Oracle Data Guard broker configuration.

This is similar to the DGMGRL CLI’s SHOW CONFIGURATION command. It provides a view of the entire Oracle Data Guard broker configuration from any database in the configuration.

Column	Datatype	Description
DATABASE	VARCHAR2(30)	Database unique name
CONNECT_IDENTIFIER	VARCHAR2(512)	Net connect identifier used to reach the database
DATAGUARD_ROLE	VARCHAR2(20)	Oracle Data Guard role of the database: FAR SYNC INSTANCE LOGICAL STANDBY PHYSICAL STANDBY RECOVERY APPLIANCE REMOTE CONFIG MEMBER PRIMARY SNAPSHOT STANDBY
REDO_SOURCE	VARCHAR(30)	The database unique name of the redo source
ENABLED	VARCHAR2(5)	Indicates whether the database is managed by Oracle Data Guard broker (TRUE) or not (FALSE)
STATUS	NUMBER	An Oracle error number denoting the database’s current status
SEVERITY	VARCHAR2(30)	Severity of the Oracle error. Possible values: FAILURE SUCCESS WARNING
STATUS_MESSAGE	VARCHAR2(256)	Error message associated with the Oracle error number in the STATUS column
SWITCHOVER_READY	VARCHAR2(7)	Indicates whether the database is ready for switchover (YES, NO, or UNKNOWN)
FAILOVER_READY	VARCHAR2(7)	Indicates whether the database is ready for failover (YES, NO, or UNKNOWN) If DATAGUARD_ROLE = PRIMARY, then this column displays UNKNOWN.
CURRENT_STATE	VARCHAR2(17)	Reserved for future use
VERSION	VARCHAR2(30)	Version of the broker configuration
TRANSPORT_MODEFoot 1	VARCHAR2(30)	Transport mode of the standby databases
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.5.