Oraclle11gR2_为GoldenGate源端添加pump进程二

本文介绍了在Oracle11gR2中为GoldenGate源端添加Pump进程的过程,通过修改ext1参数配置,确保Pump1进程能从RBA0开始写入远程Trail。尽管在测试中重建的Pump1进程检查点不同,但它能够自动与原有进程同步。
摘要由CSDN通过智能技术生成
      Oraclle11gR2_为GoldenGate源端添加pump进程二

前面测试过通过删除源端和目标端的进程并重建的方法添加PUMP进程,这里测试不删除源端和目标端的GoldenGate进程,而直接添加pump进程的过程。

1、删除原测试环境的进程

1.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:02    
EXTRACT     RUNNING     PUMP1       00:00:00      00:00:07    


GGSCI (oraclesrc) 2> stop ext1

Sending STOP request to EXTRACT EXT1 ...
Request processed.


GGSCI (oraclesrc) 3> stop pump1

Sending STOP request to EXTRACT PUMP1 ...
Request processed.


GGSCI (oraclesrc) 4> delete ext1

2015-04-10 09:16:26  WARNING OGG-01753  Cannot unregister EXTRACT EXT1 from database because no database login was provided. You can manually unregister this group later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.
Deleted EXTRACT EXT1.


GGSCI (oraclesrc) 5> delete pump1

2015-04-10 09:16:29  WARNING OGG-01753  Cannot unregister EXTRACT PUMP1 from database because no database login was provided. You can manually unregister this group later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.
Deleted EXTRACT PUMP1.

1.2 删除目标端


GGSCI (oracledest) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:09    


GGSCI (oracledest) 2> dblogin userid ogg@oradest,password ogg
Successfully logged into database.

GGSCI (oracledest) 3> delete checkpointtable ogg.checkpoint
This checkpoint tabl
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值