8.177 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

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 Database 23ai, Release Update 23.5.