以下是我两台机器做GOLDGATE的一些参数,其中复制进程一直是STOPED状态,比较疑惑,望高人指点。
SOURCE DB 192.168.1.223
GGSCI (haha) 1> info all
Program StatusGroup Lag Time Since Chkpt
MANAGER RUNNING
EXTRACTRUNNING EXT100:00:0000:00:04
edit param ext1
extract ext1
userid goldengate,password goldengate
rmthost 192.168.1.224, mgrport 7810
rmttrail /home/oracle/ggs/dirdat/r1
dynamicresolution
gettruncates
table wang.*;
target db 192.168.1.224
GGSCI (haha) 1> info all
Program StatusGroup Lag Time Since Chkpt
MANAGER RUNNING
REPLICATSTOPPED REP100:00:0000:16:34
edit param rep1
replicat rep1
userid goldengate,password goldengate
assumetargetdefs
reperror default,discard
DISCARDFILE /home/oracle/ggs/dirrpt/error.dsc,append,megabytes 100 gettruncate
MAP wang.*,TARGET wang.*;
|