8.178 V$DG_BROKER_PROPERTY

V$DG_BROKER_PROPERTY displays information about 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 columns 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