Oracle11gR2_为GoldenGate源端添加pump进程一
1、源端设置
GGSCI (oraclesrc) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:03
删除旧的ext1:
GGSCI (oraclesrc) 2> stop ext1
GGSCI (oraclesrc) 2> delete ext1
重建ext1:
GGSCI (oraclesrc) 6> add extract ext1,tranlog,begin now
GGSCI (oraclesrc) 8> add exttrail /u01/ogg/dir
在原来的测试环境中,没有使用pump进程,这里测试重新配置源端和目标端进程,使源端使用pump进程。在本测试中,对源端extract进程删除重建,并新增pump进程,在目标端也对replicat进程删除重建。
1、源端设置
GGSCI (oraclesrc) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:03
删除旧的ext1:
GGSCI (oraclesrc) 2> stop ext1
GGSCI (oraclesrc) 2> delete ext1
重建ext1:
GGSCI (oraclesrc) 6> add extract ext1,tranlog,begin now
GGSCI (oraclesrc) 8> add exttrail /u01/ogg/dir