Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › OGG-Oracle GoldenGate › 执行updatede时候源端报错OGG-01921 Missing GETBEFORE ...
发新帖
aaaaaaaa2000

131

积分

1

好友

13

主题

执行updatede时候源端报错OGG-01921 Missing GETBEFORECOLS with conflic...

1#
发表于 2013-4-15 15:16:19 | 查看: 6108| 回复: 3
gg version：Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
db:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
os:Red Hat Enterprise Linux Server release 6.0
目标端与源端的环境一致

extract参数
  1. GGSCI (ogg1) 2> view params EXMA1

  3. extract exma1
  4. SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
  5. userid ogg_source ,password AADAAAAAAAAAAADAPBWBXBLIQCCAYDPDTCRHNBSHTGHIVDQDLDUENJHHMCSEWDLECINGACXBJERHZEFD &
  6.         AES128,ENCRYPTKEY mykey1
  7. TRANLOGOPTIONS  INCLUDEREGIONID ALTARCHIVELOGDEST PRIMARY /home/oracle/app/oradata/arch
  8. EXTTRAIL /home/oracle/ogg/dirdat/m1
  9. table clm.ma*,&
  10. GETBEFORECOLS ( &
  11. ON UPDATE ALL,&
  12. ON DELETE ALL) &
  13. ;
复制代码
pump参数
  1. GGSCI (ogg1) 4> view params EXPMMA2

  3. EXTRACT expmma2
  4. REPORT AT 11:30
  5. REPORTROLLOVER AT 17:00
  6. USERID ogg_source,  password AADAAAAAAAAAAADAPBWBXBLIQCCAYDPDTCRHNBSHTGHIVDQDLDUENJHHMCSEWDLECINGACXBJERHZEFD &
  7.         AES128,ENCRYPTKEY mykey1
  8. DISCARDFILE /home/oracle/ogg/dirdat/disc_ma2.dis, append,megabytes 100
  9. RMTHOST 192.168.146.11, MGRPORT 7809 ,ENCRYPT AES128, KEYNAME mykey2
  10. ENCRYPTTRAIL AES128 KEYNAME mykey3
  11. RMTTRAIL /home/oracle/ogg/dirdat/m2
  12. TABLE  clm.MAP_TAB,COLSEXCEPT(update_time);
  13. --,&
  14. --GETBEFORECOLS ( &
  15. --ON UPDATE KEYINCLUDING (name, age), &
  16. --ON DELETE KEYINCLUDING (name, age));
复制代码
replicat参数
  1. GGSCI (ogg2) 69> view params REMP1

  3. REPLICAT remp1
  4. --CHECKPARAMS
  5. SETENV (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
  6. USERID ogg_target, PASSWORD ogg
  7. REPORT AT 11:30
  8. REPORTROLLOVER AT 17:00
  9. STATOPTIONS REPORTDETAIL RESETREPORTSTATS
  10. sqlexec "Alter session set constraints=deferred"
  11. ---DBOPTIONS limitrows  SUPPRESSTRIGGERS DEFERREFCONST
  12. ---DDLOPTIONS REPORT
  13. ---ASSUMETARGETDEFS
  14. ---REPERROR (DEFAULT, DISCARD)
  15. ---DDLERROR DEFAULT DISCARD  RETRYOP
  16. DECRYPTTRAIL AES128 KEYNAME mykey3
  17. DISCARDFILE /home/oracle/ogg/disc_mp1,append, megabytes 100
  18. SOURCEDEFS /home/oracle/ogg/dirdef/map.df
  19. map clm.map_tab, target  clm_target.map_tab_log, &
  20. KEYCOLS (id), &
  21. SQLEXEC(id env,query "select SYS_CONTEXT('USERENV','TERMINAL') terminal, sys.login_user username,SYS_CONTEXT('USERENV','HOST') hostn
  22. ame,SYS_CONTEXT('USERENV','DB_NAME') dbname from dual",EXEC SOURCEROW), &
  23. colmap (USEDEFAULTS, &
  24. identity_card_en = IDENTITY_CARD, &
  25. oper_time = @GETENV ("GGHEADER", "COMMITTIMESTAMP"), &
  26. OPER_NAME = env.username , &
  27. oper_ip = "test", &
  28. oper_optype = @GETENV("GGHEADER", "OPTYPE") &
  29. op_dname =  env.dbname, &
  30. op_terminal = env.terminal &
  31. ), &
  32. COMPARECOLS ( &
  33. ON UPDATE KEYINCLUDING (name, age), &
  34. ON DELETE KEYINCLUDING (name, age)), &
  35. RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX(age))), &
  36. RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEMAX(age))), &
  37. RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)), &
  38. RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)), &
  39. RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)), &
  40. ----REPERROR DISCARD, &
  41. where (id=1),&
  42. EVENTACTIONS ( SHELL ("Timestamp: $1  > /home/oracle/id=1log.txt ", VAR $1 = @GETENV("JULIANTIMESTAMP")),&
  43. FILTER( IGNORE UPDATE,  IGNORE DELETE,(area="yantai"))
  44. ;
复制代码
现在的现象是，insert进去没有问题，但是当update的时候replicat直接abend
2007-08-08 11:57:01  ERROR   OGG-01921  Missing GETBEFORECOLS with conflict detection enabled in target table CLM_TARGET.MAP_TAB_LOG
.
不知道那个地方配置出问题了，多谢解答
2#
发表于 2013-4-15 15:25:38
目标端map_tab表的定义
  1. SYS@orcl(ogg1)> select dbms_metadata.get_ddl('TABLE','MAP_TAB','CLM') from dual;

  3. DBMS_METADATA.GET_DDL('TABLE','MAP_TAB','CLM')
  4. --------------------------------------------------------------------------------

  6.   CREATE TABLE "CLM"."MAP_TAB"
  7.    (    "ID" NUMBER,
  8.         "NAME" VARCHAR2(20),
  9.         "AGE" NUMBER,
  10.         "IDENTITY_CARD" VARCHAR2(20),
  11.         "AREA" VARCHAR2(40),
  12.         "GANDER" NUMBER,
  13.         "UPDATE_TIME" TIMESTAMP (6) DEFAULT sysdate,
  14.          SUPPLEMENTAL LOG GROUP "GGS_77044" ("ID", "NAME", "AGE", "IDENTITY_CARD", "ARE
  15. A", "GANDER", "UPDATE_TIME") ALWAYS
  16.    ) SEGMENT CREATION IMMEDIATE
  17.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  18. NOCOMPRESS LOGGING
  19.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  20.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  21.   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  22.   TABLESPACE "USERS"
复制代码
源端map_tab_log表定义
  1. SYS@orcl(ogg2)> select dbms_metadata.get_ddl('TABLE','MAP_TAB_LOG','CLM_TARGET') from dual;

  3. DBMS_METADATA.GET_DDL('TABLE','MAP_TAB_LOG','CLM_TARGET')
  4. --------------------------------------------------------------------------------

  6.   CREATE TABLE "CLM_TARGET"."MAP_TAB_LOG"
  7.    (    "ID" NUMBER,
  8.         "NAME" VARCHAR2(20),
  9.         "AGE" NUMBER,
  10.         "AREA" VARCHAR2(40),
  11.         "IDENTITY_CARD_EN" VARCHAR2(100),
  12.         "GANDER" NUMBER,
  13.         "OPER_NAME" VARCHAR2(10),
  14.         "OPER_IP" VARCHAR2(40),
  15.         "OPER_OPTYPE" VARCHAR2(20),
  16.         "OPER_TIME" TIMESTAMP (6),
  17.         "OP_DNAME" VARCHAR2(20),
  18.         "OP_TERMINAL" VARCHAR2(40)
  19.    ) SEGMENT CREATION IMMEDIATE
  20.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  21. NOCOMPRESS LOGGING
  22.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  23.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  24.   BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  25.   TABLESPACE "USERS"
复制代码

回复 只看该作者 道具 举报

3#
发表于 2013-4-15 15:33:43
表上都不添加主键。

回复 只看该作者 道具 举报

4#
发表于 2013-4-15 15:34:43
REMP1.txt (15.97 KB, 下载次数: 587)

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-18 20:48 , Processed in 0.062170 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569