ogg同步源端update的操作到目标端转成insert了

scofieldus

参数

EXTRACT:

1. EXTRACT EXT
   
2. setenv (ORACLE_SID="db1")
   
3. setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
   
4. EXTTRAIL /oracle/app/goldengate/dirdat/sl
   
5. USERID ogg,PASSWORD "test"
   
6. TRANLOGOPTIONS ALTARCHIVELOGDEST +DATA/archive
   
7. TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.dbf
   
8. TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD test
   
9. THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 90000
   
10. numfiles 3000
    
11. DISCARDROLLOVER AT 05:30
    
12. DYNAMICRESOLUTION
    
13. --GETTRUNCATES
    
14. DDL INCLUDE MAPPED &
    
15. exclude objtype 'PROCEDURE' &
    
16. exclude objtype 'FUNCTION' &
    
17. exclude objtype 'TYPE' &
    
18. exclude objtype 'TRIGGER' &
    
19. exclude objtype 'GRANT' &
    
20. exclude instr 'GRANT' &
    
21. exclude objtype 'DATABASE LINK' &
    
22. exclude objtype 'CONSTRAINT' &
    
23. exclude objtype 'JOB' &
    
24. exclude instr 'ALTER SESSION' &
    
25. exclude INSTR 'AS SELECT' &
    
26. exclude INSTR 'REPLACE SYNONYM'
    
27. DDLOPTIONS ADDTRANDATA,REPORT
    
28. FETCHOPTIONS,  USESNAPSHOT, USELATESTVERSION, MISSINGROW REPORT
    
29. STATOPTIONS REPORTFETCH
    
30. WARNLONGTRANS 1H, CHECKINTERVAL 5M
    
31. SEQUENCE A.* ;
    
32. SEQUENCE B.* ;
    
33. TABLE A.* ;
    
34. TABLE B.* ;

复制代码

PUMP:

1. EXTRACT EDP
   
2. setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
   
3. PASSTHRU
   
4. DYNAMICRESOLUTION
   
5. USERID ogg,PASSWORD "test"
   
6. RMTHOST 10.10.10.1, MGRPORT 7819,COMPRESS
   
7. RMTTRAIL /oracle/app/goldengate/dirdat/ww
   
8. DISCARDFILE ./dirrpt/ext.dsc,APPEND,MEGABYTES 5
   
9. SEQUENCE A.*;
   
10. SEQUENCE B.*;
    
11. TABLE A.*;
    
12. TABLE B.*;

复制代码

REPLICAT:

1. REPLICAT REP
   
2. setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
   
3. DBOPTIONS DEFERREFCONST
   
4. USERID ogg,PASSWORD "test"
   
5. --HANDLECOLLISIONS
   
6. REPERROR (00001,discard)
   
7. ASSUMETARGETDEFS
   
8. REPORTROLLOVER AT 23:59
   
9. DISCARDFILE ./dirrpt/REP.DSC,APPEND,megabytes 100
   
10. DDL INCLUDE MAPPED
    
11. --exclude INSTR 'AS SELECT'
    
12. DDLERROR DEFAULT IGNORE RETRYOP
    
13. DDLOPTIONS REPORT
    
14. --BATCHSQL
    
15. ALLOWNOOPUPDATES
    
16. DDLSUBST 'A' WITH 'A_OGG' INCLUDE ALL
    
17. DDLSUBST 'B' WITH 'B_OGG' INCLUDE ALL
    
18. DDLOPTIONS MAPSESSIONSCHEMA A, TARGET A_OGG, MAPSCHEMAS
    
19. DDLOPTIONS MAPSESSIONSCHEMA B, TARGET B_OGG, MAPSCHEMAS
    
20. DBOPTIONS LOBWRITESIZE 102400
    
21. MAP A.* , TARGET A_OGG.*;
    
22. MAP B.* , TARGET B_OGG.*;
    
23. 
    
24. 
    

复制代码

scofieldus

付上截图

scofieldus

Maclean Liu(刘相兵 发表于 2013-5-2 11:02
你是何时 如何观察到 update转换为insert的？

你能重现该现象吗？ rep的report上传一下 ...

大刘，这个问题不能重现，操作是业务上操作的，只能通过discard日志与veridata比对报表得出结论
veridata 报告：





discard信息：

scofieldus

贴图还是太小，上传了附件
Desktop.zip (126.16 KB, 下载次数: 1819)

2013-5-2 11:14 上传

点击文件名下载附件