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
前面测试过通过删除源端和目标端的进程并重建的方法添加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