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

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖
1#
发表于 2013-4-19 11:23:02
How to run Veridata jobs from command line
/app/oggver/Oracle_GoldenGate_Veridata/server/bin
Compare the whole group
[oracle@dbsrv1 bin]$ ./vericom -j myjob
Connecting to: localhost:4150
Run ID: (1019, 0, 0)
REMARK: Myjob is your job name.
Compare Only one table
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY
Connecting to: localhost:4150
Run ID: (1021, 0, 0)
REMARK: Myjob is your job name, mygroup is your compare group name, tnokey=tnokey is your compare pair name.

Compare only a partition of a table
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY -pS mypartition1 -pT mypartition1
Or you can direct write the sql here:
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY -pq name=’a’
This will apply the query to both source and target. Please refer to Veridata admin guide for more command line help.

回复 显示全部楼层 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-5-19 11:51 , Processed in 0.046277 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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