1、源端抽取进程参数
[oracle@as52 dirprm]$cat eini_1.prm
EXTRACT EINI_1
SETENV (ORACLE_SID=r11g)
USERID ggs, PASSWORD ggs
RMTHOST as52, MGRPORT 8409
RMTTRAIL /oracle/ggs/dirdat/ds
TABLE ggs.test;
2、源端投递进程参数
[oracle@as52 dirprm]$cat r11g.prm
extract R11G
USERID ggs, PASSWORD ggs
dynamicresolution
NOPASSTHRU
rmthost 192.168.0.220,mgrport 8409,compress
rmttrail d:\tools\ggs\dirdat\wi #这个非常重要!
numfiles 3000
TABLE ggs.test ;
如果误将传递进程的rmttrail文件设置为源端文件,会产生莫名其妙的错误,而不是提示你不能创建这个文件:
2010-07-08 14:15:37 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, r11g.prm: Output file /oracle/ggs/dirdat/wi is usin
g format RELEASE 10.4.
2010-07-08 14:15:37 GGS ERROR 112 Oracle GoldenGate Capture for Oracle, r11g.prm: There is a problem in network communicati
on, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file u
sed is /oracle/ggs/dirdat/wi000000, reply received is Could not create /oracle/ggs/dirdat/wi000000).
2010-07-08 14:15:37 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, r11g.prm: PROCESS ABENDING.
3、目标端接收进程参数
D:\tools\ggs>type dirprm\linux.prm
REPLICAT LINUX
SETENV (ORACLE_SID=test)
USERID chensq,password chensq
HANDLECOLLISIONSASSUMETARGETDEFS
DISCARDFILE d:\tools\ggs\dirrpt\RINI_ggt.dsc,PURGE
map ggs.* , target chensq.*;
效果测试
在源表ggs.test插入数条记录,看一下投递进程及接收进程的统计信息:
- 投递进程
GGSCI (as52) 2> stats r11g
Sending STATS request to EXTRACT R11G …
Start of Statistics at 2010-07-08 14:41:08.
Output to d:\tools\ggs\dirdat\wi:
Extracting from GGS.TEST to GGS.TEST:
*** Total statistics since 2010-07-08 14:22:27 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Daily statistics since 2010-07-08 14:22:27 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Hourly statistics since 2010-07-08 14:22:27 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Latest statistics since 2010-07-08 14:22:27 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00End of Statistics.
- 接收进程
Related PostsGGSCI (thinkpad) 10> stats linux
Sending STATS request to REPLICAT LINUX …
Start of Statistics at 2010-07-08 16:17:53.
Replicating from GGS.TEST to CHENSQ.TEST:
*** Total statistics since 2010-07-08 16:17:51 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Daily statistics since 2010-07-08 16:17:51 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Hourly statistics since 2010-07-08 16:17:51 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00*** Latest statistics since 2010-07-08 16:17:51 ***
Total inserts 4691.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 4691.00End of Statistics.