oracle中ENABLE_GOLDENGATE_REPLICATION参数

gg版本为:112101,数据库版本为:11204

一、在部署ogg时目标端出现如下错误:

2015-03-31 00:49:34 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repcal01.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XXXXX"."XXXXX" 
source database version 11.2.0.3.10 (aix) ogg version 11.2.1 
target database version 11.2.0.4 (linux) ogg version 11.2.1

二、错误分析:

查询文档发现oracle 11204不支持replicat进程中的DBOPTIONS DEFERREFCONST参数。如果要使这个参数正常生效必须在数据库中配置ENABLE_GOLDENGATE_REPLICATION = TRUE

I look for this err on network,it say it is a bug,please tell me how can I solve.

Bug 17550807 : ORA-26945: UNSUPPORTED HINT RESTRICT_ALL_REF_CONS ON 11.2.0.4


三、ENABLE_GOLDENGATE_REPLICATION参数说明:

Property

Description

Parameter type

Boolean

Default value

false

Modifiable

ALTER SYSTEM

Range of values

true | false

Basic

No

Oracle RAC

All instances must have the same setting

ENABLE_GOLDENGATE_REPLICATION controls services provided by the RDBMS for Oracle GoldenGate (both capture and apply services). 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

四、解决方案

1.设置ENABLE_GOLDENGATE_REPLICATION参数为true

SQL> ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;

System altered.
                                                                                                                     -----------------wirted by Sunny Hu

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30109892/viewspace-2051809/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/30109892/viewspace-2051809/

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值