Oracle 参数 DG_BROKER_CONFIG_FILEn 官方解释，作用，如何配置最优化建议
本站中文解释
DG_BROKER_CONFIG_FILEn 参数是Oracle Dataguard的配置参数，用于指定DataGuard的配置文件名，数据字典中对该参数的定义为：”指定Data Guard经理在断开服务器之间进行流量时使用的文件。该文件包含所有服务器之间同步设置的详细信息。 该文件必须位于Oracle 补丁集中，默认文件路径位于$ORACLE_HOME /dbs/，且文件名格式为dg_broker_[instace_name]_[net_service_name]_config.ora”。
在正确设置DG_BROKER_CONFIG_FILEn时，需要先在对应的服务器环境中创建配置文件，并确保其路径正确，然后在数据库实例中设置相应的参数即可，具体的操作步骤为：
1．在$ORACLE_HOME/dbs/目录下创建dg_broker_[instace_name]_[net_service_name]_config.ora文件，其中instance_name为数据库实例的名称，net_service_name为连接数据库的网络服务的名称。
2．在文件中设置对应变量的值：
dg_broker_start=TRUE
3．设置数据库参数：
ALTER SYSTEM SET DG_BROKER_CONFIG_FILEn=’/dg_broker_[instace_name]_[net_service_name]_config.ora’ SCOPE=SPFILE;
4．数据库重启：
SHUTDOWN IMMEDIATE
STARTUP
官方英文解释
DG_BROKER_CONFIG_FILEn (where n = 1, 2) specifies the names for the Data Guard broker configuration files.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
Operating system-dependent |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
One filename |
|
Basic |
No |
Every database that is part of a Data Guard broker configuration has two broker configuration files, which contain entries that describe the state and properties of the configuration (such as the sites and databases that are part of the configuration, the roles and properties of each of the databases, and the state of each of the elements of the configuration). Two files are provided to always maintain the last known good state of the configuration.
If DG_BROKER_CONFIG_FILEn is not explicitly defined, then it is set to an operating system-specific default value at instance startup. This parameter can be altered only when the Data Guard broker is not running. See “DG_BROKER_START” for information on how to stop and start the broker.
See Also:
Oracle Data Guard
Broker for more information about setting this parameter
