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

aaaaaaaa2000

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
   
2. 
   
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
   
2. 
   
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
   
2. 
   
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
.
不知道那个地方配置出问题了，多谢解答

aaaaaaaa2000

REMP1.txt (15.97 KB, 下载次数: 587)

2013-4-15 15:34 上传

点击文件名下载附件
log文件

aaaaaaaa2000

表上都不添加主键。

aaaaaaaa2000

目标端map_tab表的定义

1. SYS@orcl(ogg1)> select dbms_metadata.get_ddl('TABLE','MAP_TAB','CLM') from dual;
   
2. 
   
3. DBMS_METADATA.GET_DDL('TABLE','MAP_TAB','CLM')
   
4. --------------------------------------------------------------------------------
   
5. 
   
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;
   
2. 
   
3. DBMS_METADATA.GET_DDL('TABLE','MAP_TAB_LOG','CLM_TARGET')
   
4. --------------------------------------------------------------------------------
   
5. 
   
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"
    

复制代码