Configurable Properties
Configurable properties control the behavior of broker configuration members.
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.
These properties control certain database initialization parameters and SQL statements that the broker uses to manage an Oracle Data Guard broker configuration. Therefore, you should not manually set those initialization parameters or issue those SQL statements on a broker configuration.
In most cases, the configurable property is said to apply to the entire member, meaning the value you set for the property applies to each instance of the member (that is, database or far sync instance). However, in a few cases, the configurable property is said to have instance-specific scope which means that for a multiple-instance database or far sync instance, it is possible that the values of some particular properties may differ between instances. The following table lists each configurable property and indicates whether the scope of the property is member-wide or instance-specific. If the Scope column contains:
-
Member—The value of the property is database or far sync instance-wide, not instance or configuration specific.
-
Instance—The value of the property is instance specific.
If there is an asterisk (*) present, it indicates that the property value can be set for all instances of an Oracle RAC database using the
EDIT INSTANCE * ON DATABASEcommand. -
Configuration—The value of the property is configuration wide, not instance or member specific.
Table 12-1 Configurable Properties
| Configurable Property Name | Scope | Pertains To |
|---|---|---|
| AlternateLocation | Member | Redo transport services |
| ApplyInstances | Member | Redo Apply |
|
Member |
Redo Apply and SQL Apply |
|
| ArchiveLocation | Member | Redo transport services |
|
Member |
Redo Apply |
|
|
Member |
Redo transport services |
|
|
Member |
Redo Apply and SQL Apply |
|
|
Member |
Broker communication, Redo transport services |
|
| Encryption | Member | Redo transport services |
|
Member |
Fast-start failover |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Fast-start failover |
|
|
Member |
Redo Apply and SQL Apply |
|
| PreferredObserverHosts | Member | Fast-start failover |
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
|
|
Instance |
Instance Startup and Shutdown |
|
|
Member |
Redo transport services |
|
|
Member |
Redo transport services |
Note:
Starting with Oracle Database Release 19c, configurable properties that map directly to database initialization parameters and logical standby attributes are not maintained within the broker configuration file. See the "Deprecated Features" section in Changes in Oracle Database Release 21c for Oracle Data Guard Broker for a list of deprecated initialization parameters and logical standby attributes.
Note:
When a broker configuration with its primary database is created and members are added to the configuration, the broker imports existing settings from the members to set many of the properties. If importing an existing setting fails, or if a property value is not imported, then the broker uses a broker default value. The default values and whether or not a property is imported is indicated within each property description.
See Also:
Managing the Members of a Broker Configuration for more information about property management
Broker Controlled Database Initialization Parameters and SQL Statements
The following database initialization parameters are controlled by broker configurable properties. Therefore, you should not set these parameters manually:
-
LOG_ARCHIVE_DEST_n -
LOG_ARCHIVE_DEST_STATE_n
Note:
If theSERVICE clause is not included, it is not subject to
broker control and can be changed.
The broker also uses configurable property settings to manage how apply is to be started. Therefore, the following SQL statements are managed automatically by the broker:
-
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE -
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE