Configuration Properties

Configuration properties control the behavior of the broker configuration.

You can view and dynamically update the values of these properties using either DGMGRL or Cloud Control. However, some properties can only be updated through DGMGRL.

A configuration property has configuration-wide scope; meaning that the value you set for the property applies uniformly to each member in the configuration.

Configuration properties are set using the EDIT CONFIGURATION SET PROPERTY command, as shown in the following examples.

Example 1

This example sets the FastStartFailoverThreshold configuration property to 90 seconds.

DGMGRL> EDIT CONFIGURATION SET PROPERTY FastStartFailoverThreshold=90;

Example 2

This example sets the ExternalDestination1 configuration property to point to a redo transport destination with a service name of Sales and a DB_UNIQUE_NAME of chicago.

EDIT CONFIGURATION SET PROPERTY ExternalDestination1='SERVICE=Sales DB_UNIQUE_NAME=chicago';

Note:

In general, quotation marks are not necessary around property values unless the case you specify needs to be preserved. By default, DGMGRL lowercases any string you supply, unless it is placed within quotation marks.

Quotation marks are required for any property values that include spaces or punctuation characters. For example, RedoRoutes.

The following sections describe the configuration properties:

• BystandersFollowRoleChange

• CommunicationTimeout

• ConfigurationWideServiceName

• ExternalDestination1

• ExternalDestination2

• FastStartFailoverAutoReinstate

• FastStartFailoverLagGraceTime

• FastStartFailoverLagLimit

• FastStartFailoverLagType

• FastStartFailoverPmyShutdown

• FastStartFailoverThreshold

• ObserverOverride

• ObserverPingInterval

• ObserverReconnect

• ObserverRetry

• OperationTimeout

• PreferredObserverHosts

• PrimaryDatabaseCandidates

• PrimaryLostWriteAction

• TraceLevel

• BystandersFollowRoleChange
  The BystandersFollowRoleChange configuration property establishes whether bystander standby databases are evaluated during failover (value = ALL) or after failover (value = NONE).
• CommunicationTimeout
  The CommunicationTimeout configuration property allows you to decide how many seconds the broker should wait before timing out its network communication between members in the configuration.
• ConfigurationSimpleName
  The ConfigurationSimpleName configuration property is used to specify the directory that contains the observer runtime data file (fsfo.dat), observer log files, and callout configuration files that correspond to a specific broker configuration.
• ConfigurationWideServiceName
  The ConfigurationWideServiceName configuration property is used to change the name of the configuration-wide service.
• DrainTimeout
  The DrainTimeout configuration property specifies the time to wait for sessions to drain before a switchover.
• ExternalDestination1
  The ExternalDestination1 configuration property is used to specify a redo transport destination that can receive redo data from the current primary database.
• ExternalDestination2
  The ExternalDestination2 configuration property is used to specify a redo transport destination that can receive redo data from the current primary database.
• FastStartFailoverAutoReinstate
  The FastStartFailoverAutoReinstate configuration property causes the former primary database to be automatically reinstated if a fast-start failover was initiated because the primary database was either isolated or had crashed.
• FastStartFailoverLagGraceTime
  The FastStartFailoverLagGraceTime configuration property specifies the maximum amount of time (in seconds) that can pass before the lag limit (FastStartFailoverLagLimit) is reached when the primary database requests permission to move to the lagging state.
• FastStartFailoverLagLimit
  The FastStartFailoverLagLimit configuration property establishes an acceptable limit, in seconds, that the standby is allowed to fall behind the primary in terms of redo applied.
• FastStartFailoverLagType
  The FastStartFailoverLagType configuration property specifies the type of lag (apply lag or transport lag) the user wishes to use to specify their data loss threshold.
• FastStartFailoverPmyShutdown
  The FastStartFailoverPmyShutdown configuration property causes the primary database to shut down under certain conditions.
• FastStartFailoverThreshold
  The FastStartFailoverThreshold configuration property defines the number of seconds the master observer attempts to reconnect to the primary database before initiating a fast-start failover.
• ObserverOverride
  The ObserverOverride configuration property, when set to TRUE, allows an automatic failover to occur when the observer has lost connectivity to the primary.
• ObserverPingInterval
  The ObserverPingInterval configuration property specifies how frequently the observer must ping the primary database.
• ObserverPingRetry
  The OberverPingRetry property specifies the number of times that the observer retries a failed ping before it initiates a failover to the target standby database.
• ObserverReconnect
  The ObserverReconnect configuration property specifies how often the observer establishes a new connection to the primary database.
• OperationTimeout
  The OperationTimeout configuration property specifies the maximum amount of time the broker should wait for health check, get monitorable property, and set property operations to complete.
• PrimaryDatabaseCandidates
  The PrimaryDatabaseCandidates configuration property allows the restriction of switchover and failover to a list of databases.
• PrimaryLostWriteAction
  The PrimaryLostWriteAction configuration property determines what action is taken if a primary or standby database detects that a lost write has occurred at the primary database.
• TraceLevel
  The TraceLevel configuration property is used to control the amount of tracing performed by the broker for every member in the configuration.