Veridata比较工具

Goldengate Veridata 比较工具：一、Veridata 比较原理：By default, GoldenGate Veridata compares rows by comparing allcolumns of the primary key literally (value-for-value) and by using a hash value forall non-key columns. The unique digital signature that is used to calculate the hashvalue shrinks the data to be transferred over the network for the comparison, whilestill providing a highly reliable (but not absolute) and efficient mechanism fordetermining whether two rows contain the same or different column values.对于构成键的列，采用文本比较（值与值比较）。对于非键列，采用hash值进行比较。Source和target 分别进行hash运算并进行数字签名后，传递到veridata的server端进行比较。For more assurance of discovering out-of-sync rows, you can configure GoldenGateVeridata to compare non-key rows column-for-column, instead of using a hash.Full-column comparisons reduce the processing performance in proportion to thenumber of columns, and they increase network usage.更精确的比较，可以采用如下方法：非键列采用column-for-column比较，不采用hash比较。这样的话，这个方法实际上就是Full-column comparisons。不过此方法会降低性能。DSN：第一、安装agent时指定哪个sql server实例下的哪个db name第二、ie 的web界面下，Configuration -Connection Configuration指定主机名，数据库类型。二、Goldengate Veridata部署解释:Goldengate Veridata Agent 分别安装在source db和target db上。形成名为” GoldenGateVeridataAgent”的windows 服务。安装的过程中，会指定dbname。Goldengate Veridata Server：跟Goldengate Veridata web装在同一个机器上。形成名为” GoldenGate Veridata Server”和” GoldenGate Veridata Web” 的windows 服务.Goldengate Veridata Server 安装时，会指定需要创建的db name，这个db name 就是Repository。Repository用于存放比较开始前的配置信息，比如如下的配置信息:compare pair；group ; job; profile.注:请不要用sql 2000作为repository。我测试时，是在一个sql2005实例下建立的repository。Metalink文章ID 973702.1 有如下的说明：Veridata v3.0 does not support Sql Server 2000 as a database repository.Goldengate Veridata web：跟Goldengate Veridata Server装在同一个机器上.Goldengate Veridata web采Apache Tomcat作为web应用程序服务器，来实现比较业务逻辑、比较的配置、运行比较,以及查看比较报告等。Goldengate Veridata CLI 这是一个命令行界面，所实现的功能也可以用Goldengate Veridata web 界面来实现。三、比较报告。此报告比较长，可以直接到第77页去看此报告的结尾。比较报告分为表级的rpt 和job级的rpt比如job级别的rpt，jobwin.rpt ,里边是进行比较的全部对象的报告，比如:* Oracle GoldenGate Veridata Server Version 3.0.0.4 Build 003 Copyright (C) 2004, 2009, Oracle and/or its affiliates. All rights reserved. Starting at 2010-09-17 16:30:56*Microsoft Windows 2000 Server Version 5.2 (Build 3790: Service Pack 2)Process id: 3656, Thread id : 2740Profile: $defaultGeneral:* Out-Of-Sync Output Format: binary Maximum Size of Each Out-Of-Sync XML Chunk (Rows): 500 Output in-sync rows to OOS file: falseOutput in-sync after in-flight rows to OOS file: true Report in-sync rows to report file: falseReport in-sync after in-flight rows to report file: false Sorting Method: Sort Data Using: database Maximum Memory Usage (MB): 50 Number Of Concurrent Threads: 4 Temporary Storage Directory for Source Data: Temporary Storage Directory for Target Data: NSort Memory Retry Limit: 0NSort Memory Retry Wait Interval: 0Initial Compare (General):* Max Concurrent Comparison Threads: 4Terminate when Maximum Records Out-Of-Sync: 100000 Output Out-Of-Sync Record Details to Report File: false Update Report file Every (seconds): 0 Update Report file Every Threads: 0Terminate when Maximum Records Out-Of-Sync: 100000 Output Out-Of-Sync Record Details to Report File: false Update Report file Every (seconds): 0 Update Report file Every (records): 0 Limit Number of Input Rows: 0 Delta processsing enabled: falseInitial Compare (Event Reporting):* Generate Messages: none Generate Warning Messages For Out-Of-Sync Rows After (differences): 50Initial Compare (Agent):* Use Static Listening Port For For Agent During Row Hash On Source: 0 Use Static Listening Port For For Agent During Row Hash On Target: 0Initial Compare (NonStop Process):* Source Process Name Starting With: Source Process CPU Number: -1 Source Process Priority: 0 Target Process Name Starting With: Target Process CPU Number: -1 Target Process Priority: 0Confirm-Out-Of-Sync (General):* Perform Confirm Out-Of-Sync Step: true Run Concurrently With Initial Compare: true Delay Confirm-Out-Of-Sync By (seconds): 0Terminate when Maximum Records Out-Of-Sync: 100000 Output Out-Of-Sync Record Details to Report File: false Update Report file Every (seconds): 0 Update Report file Every (records): 0Confirm-Out-Of-Sync (Event Reporting):* Generate Messages: none Generate Warning Messages For For Out-Of-Sync Rows After (differences): 50Confirm-Out-Of-Sync (Agent):* Use Static Listening Port For Agent During Row Hash On Source: 0 Use Static Listening Port For Agent During Row Hash On Target: 0Confirm-Out-Of-Sync (NonStop Process):* Source Process Name Starting With: Source Process CPU Number: -1 Source Process Priority: 0 Target Process Name Starting With: Target Process CPU Number: -1 Target Process Priority: 0Run Overrides:*General (No comparisons performed):* Review Previous Out-Of-Sync Results: false Generate Out-Of-Sync XML from Previous Run: falseProfile Setting Overrides:* Max Concurrent Comparison Threads: 4 Delay Confirm-Out-Of-Sync By (seconds): 0 Perform Confirm Out-Of-Sync Step: true Out-Of-Sync Output Format: binary Maximum Size of Each Out-Of-Sync XML Chunk (Rows): 500 Tracing: Trace Agent Rowhash: false Trace Agent COOS: false Trace Server: 0x00000000Job: jobwin (1) GroupsPerforming 515 comparisons .Group: groupwin (515) Compare Pairs Compare pair: A_TMP=A_TMP Compare pair: BACKBB=BACKBB Compare pair: BBCONF=BBCONF Compare pair: BBORDE=BBORDE Compare pair: B_TMP=B_TMP Compare pair: CBCBXM=CBCBXM Compare pair: CBFYXM=CBFYXM Compare pair: CGRKJYJL=CGRKJYJL Compare pair: CGZGGYS=CGZGGYS Compare pair: CHZGYF=CHZGYF Compare pair: CJSCDD1=CJSCDD1 Compare pair: CJSCDD2=CJSCDD2 Compare pair: CJSCDD3=CJSCDD3 Compare pair: CJSCDD4=CJSCDD4 Compare pair: CJSCDD5=CJSCDD5 Compare pair: CJSCDD6=CJSCDD6 Compare pair: CJSCDDLB=CJSCDDLB Compare pair: CJSCDDLY=CJSCDDLY Compare pair: C_TMP=C_TMP Compare pair: FNQSDX=FNQSDX Compare pair: FUNCCS=FUNCCS Compare pair: FUNCTIONVALUES=FUNCTIONVALUES Compare pair: GDBDD=GDBDD Compare pair: GDBMD=GDBMD Compare pair: GDBMZD=GDBMZD Compare pair: GDCZD=GDCZD Compare pair: GDDXJL=GDDXJL Compare pair: GDHSKM=GDHSKM Compare pair: GDJSD=GDJSD Compare pair: GDJSYY=GDJSYY Compare pair: GDJSZC=GDJSZC Compare pair: GDJZD=GDJZD Compare pair: GDJZZB=GDJZZB Compare pair: GDJZZC=GDJZZC Compare pair: GDJZZW=GDJZZW Compare pair: GDLYZD=GDLYZD Compare pair: GDMXKM=GDMXKM Compare pair: GDNBDB=GDNBDB Compare pair: GDPGD=GDPGD Compare pair: GDQLD=GDQLD Compare pair: GDSYQK=GDSYQK Compare pair: GDSZGS=GDSZGS Compare pair: GDXMMX=GDXMMX Compare pair: GDXMZD=GDXMZD Compare pair: GDYLZC=GDYLZC Compare pair: GDYTZD=GDYTZD Compare pair: GDYZCZ=GDYZCZ Compare pair: GDZCBD=GDZCBD Compare pair: GDZCBF=GDZCBF Compare pair: GDZCBJ=GDZCBJ Compare pair: GDZCGS=GDZCGS Compare pair: GDZCLB=GDZCLB Compare pair: GDZCMX=GDZCMX Compare pair: GDZCMXEX=GDZCMXEX Compare pair: GDZCPG=GDZCPG Compare pair: GDZCZY=GDZCZY Compare pair: GDZJD=GDZJD Compare pair: GDZJFF=GDZJFF Compare pair: GDZJFP=GDZJFP Compare pair: GDZJFYD=GDZJFYD Compare pair: GDZJZC=GDZJZC Compare pair: GDZTBD=GDZTBD Compare pair: GDZTZD=GDZTZD Compare pair: GZBASE=GZBASE Compare pair: GZBASE_BAK=GZBASE_BAK Compare pair: GZBASE_BF=GZBASE_BF Compare pair: GZBBXM=GZBBXM Compare pair: GZBBXM_BAK=GZBBXM_BAK Compare pair: GZBMZD=GZBMZD Compare pair: GZDFFA=GZDFFA Compare pair: GZDZML=GZDZML Compare pair: GZDZZD=GZDZZD Compare pair: GZGZBB=GZGZBB Compare pair: GZGZBB_BAK=GZGZBB_BAK Compare pair: GZHSKM=GZHSKM Compare pair: GZHSYW=GZHSYW Compare pair: GZJGZD=GZJGZD Compare pair: GZJGZD_BAK=GZJGZD_BAK Compare pair: GZJKSJ=GZJKSJ Compare pair: GZJSGS=GZJSGS Compare pair: GZKZZD=GZKZZD Compare pair: GZLBZD=GZLBZD Compare pair: GZMXKM=GZMXKM Compare pair: GZMZZD=GZMZZD Compare pair: GZNSBB=GZNSBB Compare pair: GZSLZD=GZSLZD Compare pair: GZWJGS=GZWJGS Compare pair: GZYGYH=GZYGYH Compare pair: GZYHGS=GZYHGS Compare pair: GZYHJL=GZYHJL Compare pair: GZYHXX=GZYHXX Compare pair: GZYHZD=GZYHZD Compare pair: HZBBEX=HZBBEX Compare pair: HZBBGS=HZBBGS Compare pair: HZBBZD=HZBBZD Compare pair: HZBDH=HZBDH Compare pair: HZBDL=HZBDL Compare pair: HZBZBM=HZBZBM Compare pair: HZCONF=HZCONF Compare pair: HZDGSM=HZDGSM Compare pair: HZDGSZ=HZDGSZ Compare pair: HZDWBB=HZDWBB Compare pair: HZDWHZD=HZDWHZD Compare pair: HZDWLB=HZDWLB Compare pair: HZDWLZD=HZDWLZD Compare pair: HZDWSB=HZDWSB Compare pair: HZDWSJ=HZDWSJ Compare pair: HZDWZD=HZDWZD Compare pair: HZDYZD=HZDYZD Compare pair: HZENDBBMONTH=HZENDBBMONTH Compare pair: HZENDBBYEAR=HZENDBBYEAR Compare pair: HZFLBB=HZFLBB Compare pair: HZFLZD=HZFLZD Compare pair: HZFXB=HZFXB Compare pair: HZFXDY=HZFXDY Compare pair: HZHZD=HZHZD Compare pair: HZHZSJ=HZHZSJ Compare pair: HZJSGS=HZJSGS Compare pair: HZJYGS=HZJYGS Compare pair: HZJYQK=HZJYQK Compare pair: HZJYXX=HZJYXX Compare pair: HZLBHZ=HZLBHZ Compare pair: HZLBZD=HZLBZD Compare pair: HZLZD=HZLZD Compare pair: HZORDE=HZORDE Compare pair: HZPHGS=HZPHGS Compare pair: HZPRTFMT=HZPRTFMT Compare pair: HZSBXZ=HZSBXZ Compare pair: HZSBZT=HZSBZT Compare pair: HZSTOB=HZSTOB Compare pair: HZTSB=HZTSB Compare pair: HZTSDY=HZTSDY Compare pair: HZTZZD=HZTZZD Compare pair: JLDATA=JLDATA Compare pair: JSBHCODE=JSBHCODE Compare pair: JSBHCOL=JSBHCOL Compare pair: JSBHJL=JSBHJL Compare pair: JSBHOBJ=JSBHOBJ Compare pair: JSBHRULE=JSBHRULE Compare pair: JSBZGX=JSBZGX Compare pair: JSBZGZSJ=JSBZGZSJ Compare pair: JSGNZD=JSGNZD Compare pair: JSGXFL=JSGXFL Compare pair: JSGXJYXM=JSGXJYXM Compare pair: JSGZRL=JSGZRL Compare pair: JSGZRLFP=JSGZRLFP Compare pair: JSGZRLMX=JSGZRLMX Compare pair: JSGZRTZ=JSGZRTZ Compare pair: JSGZSJ=JSGZSJ Compare pair: JSJLDW=JSJLDW Compare pair: JSJLDWHS=JSJLDWHS Compare pair: JSLJBM=JSLJBM Compare pair: JSUSGN=JSUSGN Compare pair: JSWLDWHS=JSWLDWHS Compare pair: JSWLQX=JSWLQX Compare pair: JSZGBZ=JSZGBZ Compare pair: KCBMZD=KCBMZD Compare pair: KCCKD1=KCCKD1 Compare pair: KCCKD2=KCCKD2 Compare pair: KCCKD3=KCCKD3 Compare pair: KCHWWL=KCHWWL Compare pair: KCHWZD=KCHWZD Compare pair: KCJGXX=KCJGXX Compare pair: KCJYJL=KCJYJL Compare pair: KCRKD1=KCRKD1 Compare pair: KCRKD2=KCRKD2 Compare pair: KCRKD3=KCRKD3 Compare pair: KCTSKCLB=KCTSKCLB Compare pair: KCXED1=KCXED1 Compare pair: KCXED2=KCXED2 Compare pair: KCZJSQD1=KCZJSQD1 Compare pair: KCZJSQD2=KCZJSQD2 Compare pair: KCZJSQD3=KCZJSQD3 Compare pair: LCBBEX=LCBBEX Compare pair: LCBBGS=LCBBGS Compare pair: LCBBZD=LCBBZD Compare pair: LCBDH=LCBDH Compare pair: LCBDH_TMP=LCBDH_TMP Compare pair: LCBDL=LCBDL Compare pair: LCBDL_TMP=LCBDL_TMP Compare pair: LCBZBM=LCBZBM Compare pair: LCDWHZD_TMP=LCDWHZD_TMP Compare pair: LCDWLZD_TMP=LCDWLZD_TMP Compare pair: LCDWSJ_TMP=LCDWSJ_TMP Compare pair: LCDYZD=LCDYZD Compare pair: LCDYZDO_TMP=LCDYZDO_TMP Compare pair: LCDYZD_TMP=LCDYZD_TMP Compare pair: LCENDBBMONTH=LCENDBBMONTH Compare pair: LCENDBBYEAR=LCENDBBYEAR Compare pair: LCFLBB=LCFLBB Compare pair: LCFLZD=LCFLZD Compare pair: LCFUNC=LCFUNC Compare pair: LCHZD=LCHZD Compare pair: LCHZD_TMP=LCHZD_TMP Compare pair: LCJSGS=LCJSGS Compare pair: LCJSGS_TMP=LCJSGS_TMP Compare pair: LCJYGS=LCJYGS Compare pair: LCJYGS_TMP=LCJYGS_TMP Compare pair: LCJYQK=LCJYQK Compare pair: LCJYXX=LCJYXX Compare pair: LCLZD=LCLZD Compare pair: LCLZD_TMP=LCLZD_TMP Compare pair: LCPHGS=LCPHGS Compare pair: LCPHGS_TMP=LCPHGS_TMP Compare pair: LCPRTFMT=LCPRTFMT Compare pair: LCRBSJ=LCRBSJ Compare pair: LCSBXZ=LCSBXZ Compare pair: LCSBZT=LCSBZT Compare pair: LCTSB=LCTSB Compare pair: LCTSDY=LCTSDY Compare pair: LCTZZD=LCTZZD Compare pair: LCYJCS=LCYJCS Compare pair: LCYJLB=LCYJLB Compare pair: LCYJZB=LCYJZB Compare pair: LCZTXX=LCZTXX Compare pair: LSBFJL=LSBFJL Compare pair: LSBFRQ=LSBFRQ Compare pair: LSBHCODE=LSBHCODE Compare pair: LSBHCOL=LSBHCOL Compare pair: LSBHFF=LSBHFF Compare pair: LSBHJL=LSBHJL Compare pair: LSBHOBJ=LSBHOBJ Compare pair: LSBHQZ=LSBHQZ Compare pair: LSBHRULE=LSBHRULE Compare pair: LSBJG=LSBJG Compare pair: LSBLM=LSBLM Compare pair: LSBLOB=LSBLOB Compare pair: LSBMJG=LSBMJG Compare pair: LSBMZD=LSBMZD Compare pair: LSBQXKZ=LSBQXKZ Compare pair: LSBUTTONSQL=LSBUTTONSQL Compare pair: LSBZZD=LSBZZD Compare pair: LSCGZD=LSCGZD Compare pair: LSCKZD=LSCKZD Compare pair: LSCOMN=LSCOMN Compare pair: LSCONF=LSCONF Compare pair: LSCSJL=LSCSJL Compare pair: LSCTGN=LSCTGN Compare pair: LSCTSJ=LSCTSJ Compare pair: LSDDWD=LSDDWD Compare pair: LSDELZD=LSDELZD Compare pair: LSDJGS=LSDJGS Compare pair: LSDJGSMX=LSDJGSMX Compare pair: LSDJRZ=LSDJRZ Compare pair: LSDXLB=LSDXLB Compare pair: LSDYGS=LSDYGS Compare pair: LSDYZD=LSDYZD Compare pair: LSEXCEL_COL=LSEXCEL_COL Compare pair: LSEXCEL_MODEL=LSEXCEL_MODEL Compare pair: LSEXCEL_TABLE=LSEXCEL_TABLE Compare pair: LSEXCEL_TYPE=LSEXCEL_TYPE Compare pair: LSFLDY=LSFLDY Compare pair: LSFSDZ=LSFSDZ Compare pair: LSFUNC=LSFUNC Compare pair: LSFZMB=LSFZMB Compare pair: LSGDHL=LSGDHL Compare pair: LSGNZD=LSGNZD Compare pair: LSGRAN=LSGRAN Compare pair: LSGRAP=LSGRAP Compare pair: LSGUID=LSGUID Compare pair: LSGXZD=LSGXZD Compare pair: LSHELP=LSHELP Compare pair: LSHSFZ=LSHSFZ Compare pair: LSINDEX=LSINDEX Compare pair: LSJXCFACECOL=LSJXCFACECOL Compare pair: LSJXCFACEDW=LSJXCFACEDW Compare pair: LSJXCHELPSQL=LSJXCHELPSQL Compare pair: LSJXCSHOW=LSJXCSHOW Compare pair: LSKJQJ=LSKJQJ Compare pair: LSKM