GoldenGate Veridata是GoldenGate中用于比较数据库间数据同步效果的一个工具。
官方说明如下:
Oracle GoldenGate Veridata is a high-speed data comparison solution that identifies and reports data discrepancies between databases without interrupting ongoing business processes. Using Oracle GoldenGate Veridata, companies can audit and verify large volumes of data across a variety of business applications with certainty,and maintain reliable data synchronization.
我本次配置Veridata使用了由于如下组件:
l GoldenGate Veridata Server
l GoldenGate Veridata Web
l GoldenGate Veridata Repository
l GoldenGate Veridata Agent
两台db server安装软件说明:
| Db server1 | Db server2 |
Veridata组件 | GoldenGate Veridata Server GoldenGate Veridata Web GoldenGate Veridata Repository GoldenGate Veridata Java Agent | GoldenGate Veridata Java Agent |
Oracle db | Oracle 10.2.0.3 for win x86 | Oracle 11.2.0.1 for linux x64 |
IP | 192.168.126.1 | 192.168.126.128 |
GoldenGate Veridata相关软件包:
http://edelivery.oracle.com下载:
GoldenGate_Veridata_win_x86_v3004_003.exe
GoldenGate_Veridata_Agent_win_x86_v3004_003.exe
V19618-01.zip (linux agent)
GoldenGate Veridata Server安装:
在server1上安装GoldenGate Veridata Server,使用GoldenGate_Veridata_win_x86_v3004_003.exe包(windows的安装,一路next),过程中需要注意的地方是:配置web server admin(记住自己配的用户名、口令、port)、指定Repository(相关tns、schema、tablespace要先准备好)、是否安装到windows serice等。
启动相关服务:GoldenGate Veridata Server、GoldenGate Veridata Web
GoldenGate Veridata Java Agent安装:
1.db server1
Veridata Server中没有包含agent,需要单独安装,点击GoldenGate_Veridata_Agent_win_x86_v3004_003.exe包进行安装。
需要注意的是:
Agent port的设置,默认端口是7850
JDBC URL设置指向本地数据库,之后最好输入用户和口令进行test connect
2.db server2
在liunx系统中解压V19618-01.zip包,进入agent目录,找到agent.properties.sample文件,将它cp为agent.properties,然后进行vi,修改如下内容:
server.port=7850 (agent端口)
database.url=jdbc:oracle:thin:@192.168.126.128:1521:orcl
server.driversLocation = drivers
server.jdbcDriver=ojdbc5.jar
运行agent:
1.db server1
进入agent安装目录C:\Program Files\Goldengate_Veridata_Agent,执行agent.bat start,确认7850端口打开
2.db server2
在agent解压目录/agent中,执行./agent.sh start,确认7850端口打开
使用WEB进行配置管理Veridata
l 在db server1上使用浏览器访问http://localhost:8830,输入之前配置的用户名和口令;
l 点击“Connection Configuration”,新建connection,分别配置指向server1和server2的oracle数据库;
l 点击“Group Configuration”,新建group,指定source connection和target connection,配置“Compare Pair Configuration”指定对象对,并保存(可通过“preview”查看对象对);
l 点击“Job Configuration”,新建job,并保存;
l 点击“Run...”按钮,运行job
我指定的是两个库的scott用户的对比,其中EMP和DEPT表对比完成一致,而BONUS和SALGRADE表一直是Abended状态,之后才发现原因是这两个表中没有key。
2010-06-23 15:10:16. Abended with errors. Group (scott), Compare Pair (BONUS=BONUS). (3) Remaining
2010-06-23 15:10:16. Abended with errors. Group (scott), Compare Pair (SALGRADE=SALGRADE). (2) Remaining
2010-06-23 15:10:17. Completed in-sync. Group (scott), Compare Pair (EMP=EMP). (1) Remaining
2010-06-23 15:10:17. Completed in-sync. Group (scott), Compare Pair (DEPT=DEPT). (0) Remaining
Compare Pairs with Errors: 2 Compare Pairs with Out-Of-Sync: 0 Compare Pairs without Out-Of-Sync: 2 Compare Pairs Cancelled: 0 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17997/viewspace-665990/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17997/viewspace-665990/