Oracle 参数 DG_BROKER_START 官方解释,作用,如何配置最优化建议

本站中文解释

DG_BROKER_START参数可用于指示 Oracle 数据库实例是否启动数据库引擎,用于双机故障转移/复制/异步复制等。有三个可选的值:

(1)TRUE:开启数据库引擎,可以做镜像库或用于双机故障转移/复制/异步复制;

(2)FALSE:关闭数据库引擎,不能做镜像库,其他用途照常;

(3)SKIP:跳过,不启动/关闭数据库引擎。

要设置DG_BROKER_START参数,可以在sql *plus中执行alter system命令,格式如下:

ALTER SYSTEM SET DG_BROKER_START = true | false | skip;

最后,要完成设置,需要重启实例

官方英文解释

DG_BROKER_START enables Oracle to determine whether the Oracle Data Guard broker should be started.

Property Description

Parameter type

Boolean

Default value

false

Modifiable

ALTER SYSTEM...SID=’*’

Modifiable in a PDB

No

Range of values

true | false

Basic

No

The Oracle Data Guard broker consists of background processes, foreground processes, and the system global area (SGA). The background and foreground processes are non-fatal processes that exist as long as the instance exists, whenever this parameter is set to true.

If the database is never going to be configured in an Oracle Data Guard broker configuration, then you can leave this parameter unspecified and accept the default value of false. If the database is part of an Oracle Data Guard broker configuration, then you can simplify automatic startup of the broker by setting this parameter to true in the initialization parameter file.

See Also:

Oracle Data Guard
Broker
for examples of using this parameter to start the Oracle Data Guard broker


数据运维技术 » Oracle 参数 DG_BROKER_START 官方解释,作用,如何配置最优化建议