Oracle 参数 ENABLE_GOLDENGATE_REPLICATION 官方解释，作用，如何配置最优化建议
本站中文解释
参数
ENABLE_GOLDENGATE_REPLICATION参数是Oracle数据库的一个系统参数，可以控制是否允许使用Golden Gate来实现数据库之间的复制功能。如果该参数设置为FALSE，则表示不允许使用Golden Gate来实现数据库之间的复制功能。正确设置该参数要做以下几步:
1. SQL*Plus 连接Oracle数据库，并以系统管理员的身份登录；
2. 使用命令ALTER SYSTEM来修改ENABLE_GOLDENGATE_REPLICATION参数的取值，把它修改为TRUE，即：ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE;
3. 使用命令ALTER DATABASE来提交改动，即：ALTER DATABASE COMMIT;
4. 验证改参数生效，使用命令SELECT name, value FROM v$parameter WHERE name = ‘ENABLE_GOLDENGATE_REPLICATION’;
5. 查询结果，如果返回参数name为ENABLE_GOLDENGATE_REPLICATION，value为TRUE，则表示参数设置成功。
官方英文解释
ENABLE_GOLDENGATE_REPLICATION controls services provided by the RDBMS for Oracle GoldenGate (both capture and apply services).
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
false |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
All instances must have the same setting |
Set this to true to enable RDBMS services used by Oracle GoldenGate.
This parameter primarily controls supplemental logging required to support logical replication of new data types and operations. The redo log file is designed to be applied physically to a database, therefore the default contents of the redo log file often do not contain sufficient information to allow logged changes to be converted into SQL statements. Supplemental logging adds extra information into the redo log files so that replication can convert logged changes into SQL statements without having to access the database for each change. Previously these extra changes were controlled by the supplemental logging DDL. Now the ENABLE_GOLDENGATE_REPLICATION parameter must also be set to enable the required supplemental logging for any new data types or operations.
All enhancements to supplemental logging required to support logical replication are also controlled by this parameter.
The RDBMS services controlled by this parameter also include (but are not limited to):
-
Transparent Data Encryption (including Tablespace Encryption) utilities used by GoldenGate Extract
-
Service to read redo logs used by GoldenGate Extract
-
Service to suppress triggers used by GoldenGate Replicat
-
Service to handle transient duplicate handling used by GoldenGate Replicat
-
Service to bypass referential integrity checking used by GoldenGate Replicat
-
Services required to run Oracle GoldenGate in Integrated Extract and Integrated Replicat
