GOLDENGATE EXCLUDEUSER 不能过滤

roominess

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;

Maclean Liu(刘相兵

具体现象如何观察的 不描述一下？

roominess

源：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同步问题，禁止同步此用户所有操作。

clevernby

请确认你的实验过程没有受到其它干扰项的影响，最好能贴出过程。
如果确认无误，请按照1361231.1进行操作，需要分析delete操作的txuser到底是谁

psufnxk2000

OGG Extract is not skipping transactions from specific users (文档 ID 1361175.1)