V$DG_BROKER_PROPERTY

V$DG_BROKER_PROPERTY displays information about Oracle Data Guard broker properties.

Column Datatype Description
MEMBER VARCHAR2(31)

Broker configuration member to which the property applies

This column displays the DB_UNIQUE_NAME initialization parameter for the member. If the member role is CONFIGURATION, then the configuration name is displayed.

INSTANCE VARCHAR2(17) If the member is an Oracle RAC database, indicates whether the property is an instance-specific property. Otherwise, null.
DATAGUARD_ROLE VARCHAR2(18)

Member role:

  • CONFIGURATION

  • FAR SYNC INSTANCE

  • LOGICAL STANDBY

  • PHYSICAL STANDBY

  • PRIMARY

  • RECOVERY APPLIANCE

  • SNAPSHOT STANDBY
PROPERTY VARCHAR2(31) Property name
PROPERTY_TYPE VARCHAR2(12)

Property type:

  • CONFIGURABLE

  • MONITORABLE
VALUE VARCHAR2(4000)

Property value

If PROPERTY_TYPE = MONITORABLE, then this column displays (monitorable).

VALUE_TYPE VARCHAR2(11)

Property value type:

  • BYTE STRING

  • INTEGER

  • STRING

  • UNDEFINED

  • XML
SCOPE VARCHAR2(31)

Property scope:

  • CONFIGURATION - The property affects the entire configuration

  • INSTANCE - The property affects a single instance

  • MEMBER - The property affects a single member

VALID_ROLE VARCHAR2(31)

The role a member must have in order for the property to take effect:

  • PRIMARY - The property takes effect when the member is in the primary role

  • STANDBY - The property takes effect when the member is in the standby role

  • BOTH - The property takes effect regardless of the member role

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