GOLDENGATE EXCLUDEUSER 不能过滤
goldengate EXCLUDEUSER 不能过滤goldengate增加以下参数后，update可以过滤，delete不能过滤，请问怎么回事啊？
TRANLOGOPTIONS EXCLUDEUSER ogg
TRANLOGOPTIONS EXCLUDEUSER GHMES_CLEAN
具体参数如下
GGSCI (zhgdbp2) 272> view param extrzst
EXTRACT extrzst
SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db")
SETENV (ORACLE_SID = "sgjtzgp")
SETENV (NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8")
USERID gg PASSWORD gg
EXTTRAIL ./dirdat/ea
reportcount every 30 minutes rate
TRANLOGOPTIONS EXCLUDEUSER gg
TRANLOGOPTIONS EXCLUDEUSER ghmes_clean
--TABLE ghmes.mes_mat_material,FILTER (ON DELETE, @IF (@STREQ (@GETENV ("TRANSACTION", "USERNAME"), "GHMES_CLEAN"), 0, 1));
INCLUDE ./dirprm/EXTRZST.inc;
GGSCI (zhgdbp2) 273> view param dprzst
EXTRACT dprzst
SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db")
SETENV (ORACLE_SID = "sgjtzgp")
SETENV (NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8")
USERID gg PASSWORD gg
RMTHOST 10.88.249.35 MGRPORT 7839
RMTTRAIL ./dirdat/ra
PASSTHRU
INCLUDE ./dirprm/DPRZST.inc;
GGSCI (rzstandby) 177> view param reprzst
replicat reprzst
SETENV (ORACLE_HOME = "/app/oracle/product/10.2.0/db_1")
SETENV (ORACLE_SID = "sgjtzgp")
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
USERID ogg PASSWORD ogg
reportcount every 3 minutes rate
reperror (-1, discard)
reperror (-1403,discard)
reperror default abend
transactiontimeout 5 s
assumetargetdefs
discardfile ./dirrpt/reprzst.dsc append megabytes 5000
BATCHSQL
INCLUDE ./dirprm/REPRZST.inc;
具体现象如何观察的 不描述一下？ 源：HPUX1131 oracle10.2.0.4 ogg112101_ggs_HPUX_ia64_ora10g_64bit.zip
目标：LINUX Redhat5 oracle10.2.0.4 ogg112101_fbo_ggs_Linux_x64_ora10g_64bit.zip
增加EXCLUDEUSER GHMES_CLEAN参数
在源端update,insert数据不会同步到目标端
在源端delete数据会同步到目标端
如何解决delete同步问题，禁止同步此用户所有操作。 请确认你的实验过程没有受到其它干扰项的影响，最好能贴出过程。
如果确认无误，请按照1361231.1进行操作，需要分析delete操作的txuser到底是谁 OGG Extract is not skipping transactions from specific users (文档 ID 1361175.1)
页:
[1]