首页 > 其他 > 详细

goldengate12c不同步索引的处理办法

时间:2020-02-12 21:20:36      阅读:89      评论:0      收藏:0      [点我收藏+]

数据库版本:12.2.0.1版 cdb下有一个pdb
从库版本:11.2.0.4

goldengate版本:12.3.0.1

如下配置后发现索引没有同步,(但是在11g同步到11g,或是12c没有启用pdb下如下配置是可以同步索引的)

extract extep
userid c##goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
SETENV (ORACLE_SID="ora12c")
SETENV ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
exttrail ./dirdat/ep
sourcecatalog ora12cpdb1
BR BRINTERVAL 20M
numfiles 5000
warnlongtrans 3h, checkinterval 10m
--TRANLOGOPTIONS LOGRETENTION ENABLED
--TRANLOGOPTIONS DBLOGREADER

--DDL parameter
DDL &
EXCLUDE INSTR shrink space CHECK &
INCLUDE MAPPED OBJTYPE INDEX &
INCLUDE MAPPED OBJTYPE TABLE &
INCLUDE MAPPED OBJTYPE SEQUENCE &
INCLUDE MAPPED OBJTYPE VIEW &
INCLUDE MAPPED OBJTYPE PROCEDURE &
INCLUDE MAPPED OBJTYPE FUNCTION &
INCLUDE MAPPED OBJTYPE PACKAGE &


DDLOPTIONS ADDTRANDATA REPORT


table ora12cpdb1.EPI_HUNAN.tb_test01;
table ora12cpdb1.EPI_HUNAN.tb_test02;

修改如下后就可以同步了,添加了红色部分

extract extep
userid c##goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
SETENV (ORACLE_SID="ora12c")
SETENV ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
exttrail ./dirdat/ep
sourcecatalog ora12cpdb1
BR BRINTERVAL 20M
numfiles 5000
warnlongtrans 3h, checkinterval 10m
--TRANLOGOPTIONS LOGRETENTION ENABLED
--TRANLOGOPTIONS DBLOGREADER

--DDL parameter
DDL &
EXCLUDE INSTR shrink space CHECK &
INCLUDE MAPPED OBJTYPE INDEX &
INCLUDE MAPPED OBJTYPE TABLE &
INCLUDE MAPPED OBJTYPE SEQUENCE &
INCLUDE MAPPED OBJTYPE VIEW &
INCLUDE MAPPED OBJTYPE PROCEDURE &
INCLUDE MAPPED OBJTYPE FUNCTION &
INCLUDE MAPPED OBJTYPE PACKAGE &
INCLUDE INSTR CREATE INDEX


DDLOPTIONS ADDTRANDATA REPORT


table ora12cpdb1.EPI_HUNAN.tb_test01;
table ora12cpdb1.EPI_HUNAN.tb_test02;

 

goldengate12c不同步索引的处理办法

原文:https://www.cnblogs.com/hxlasky/p/12300569.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!