1、异常现象


[oracle@localhost ~]$ ggsci



Oracle GoldenGate Command Interpreter for Oracle


Version 11.1.1.0.0 Build 078


Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11



Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.



GGSCI (localhost.localdomain) 1> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     00:00:00      unknown


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown


2、尝试关闭异常进程重启


GGSCI (localhost.localdomain) 2> stop *



Sending STOP request to EXTRACT EXT-ECP ...



ERROR: sending message to EXTRACT EXT-ECP (Timeout waiting for message).



Sending STOP request to EXTRACT EXT-EDS ...



ERROR: sending message to EXTRACT EXT-EDS (Timeout waiting for message).



Sending STOP request to EXTRACT EXT-XZ ...



ERROR: sending message to EXTRACT EXT-XZ (Timeout waiting for message).



Sending STOP request to EXTRACT P-EDS ...



ERROR: sending message to EXTRACT P-EDS (Timeout waiting for message).



Sending STOP request to EXTRACT P-XZ ...



ERROR: sending message to EXTRACT P-XZ (Timeout waiting for message).



Sending STOP request to REPLICAT REP-BOS ...



ERROR: sending message to REPLICAT REP-BOS (Timeout waiting for message).



GGSCI (localhost.localdomain) 3> stop mgr!



Sending STOP request to MANAGER ...


Request processed.


Manager stopped.



GGSCI (localhost.localdomain) 4> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     STOPPED


EXTRACT     RUNNING     EXT-ECP     00:00:00      unknown


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown      



GGSCI (localhost.localdomain) 5> kill EXT-ECP  



ERROR: Manager not currently running.



GGSCI (localhost.localdomain) 6> kill EXT-EDS  



ERROR: Manager not currently running.



GGSCI (localhost.localdomain) 7> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     STOPPED


EXTRACT     RUNNING     EXT-ECP     00:00:00      unknown


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown    



GGSCI (localhost.localdomain) 8> exit


--使用stop 进程，stop mgr，kill 进程都不能正常关闭这些进程


3、系统系统级别kill相关ogg进程


[oracle@localhost OGG]$ ps -ef|grep /opt/OGG


oracle    7479     1  0 Nov10 ?        00:03:31 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-ecp.prm REPORTFILE /opt/OGG/dirrpt/EXT-ECP.rpt PROCESSID EXT-ECP USESUBDIRS


oracle    7480     1  0 Nov10 ?        00:02:30 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-eds.prm REPORTFILE /opt/OGG/dirrpt/EXT-EDS.rpt PROCESSID EXT-EDS USESUBDIRS


oracle    7482     1  0 Nov10 ?        00:03:07 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/ext-xz.prm REPORTFILE /opt/OGG/dirrpt/EXT-XZ.rpt PROCESSID EXT-XZ USESUBDIRS


oracle    7483     1  0 Nov10 ?        00:00:01 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-eds.prm REPORTFILE /opt/OGG/dirrpt/P-EDS.rpt PROCESSID P-EDS USESUBDIRS


oracle    7485     1  0 Nov10 ?        00:00:03 /opt/OGG/replicat PARAMFILE /opt/OGG/dirprm/rep-bos.prm REPORTFILE /opt/OGG/dirrpt/REP-BOS.rpt PROCESSID REP-BOS USESUBDIRS


oracle    7518     1  0 Nov10 ?        00:00:01 ./server -p 7847 -k -l /opt/OGG/ggserr.log


oracle    7677     1  0 Nov10 ?        00:00:15 /opt/OGG/extract PARAMFILE /opt/OGG/dirprm/p-xz.prm REPORTFILE /opt/OGG/dirrpt/P-XZ.rpt PROCESSID P-XZ USESUBDIRS


oracle   25261 25112  0 12:48 pts/1    00:00:00 grep /opt/OGG


[oracle@localhost OGG]$ kill -9 7479 7480 7482 7483 7485  7518 7677


[oracle@localhost OGG]$ ps -ef|grep /opt/OGG


oracle   25264 25112  0 12:48 pts/1    00:00:00 grep /opt/OGG


4、重启所有ogg进程


[oracle@localhost OGG]$ ggsci



Oracle GoldenGate Command Interpreter for Oracle


Version 11.1.1.0.0 Build 078


Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11



Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.



GGSCI (localhost.localdomain) 1> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     STOPPED


EXTRACT     ABENDED     EXT-ECP     00:00:00      unknown


EXTRACT     ABENDED     EXT-EDS     00:00:00      unknown


EXTRACT     ABENDED     EXT-XZ      00:00:00      unknown


EXTRACT     ABENDED     P-EDS       00:00:00      unknown


EXTRACT     ABENDED     P-XZ        00:00:00      unknown


REPLICAT    ABENDED     REP-BOS     00:00:00      unknown


--进程状态还是异常



GGSCI (localhost.localdomain) 2> start mgr



Manager started.



GGSCI (localhost.localdomain) 3> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     00:00:00      unknown


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown


--进程起来了，但是Time Since Chkpt还是不正确



GGSCI (localhost.localdomain) 4> stop ext-ecp



Sending STOP request to EXTRACT EXT-ECP ...


Request processed.



GGSCI (localhost.localdomain) 5> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     STOPPED     EXT-ECP     unknown       00:00:02


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown


--关闭EXT-ECP测试，状态正常



GGSCI (localhost.localdomain) 6> start ext-ecp



Sending START request to MANAGER ...


EXTRACT EXT-ECP starting



GGSCI (localhost.localdomain) 7> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     unknown       00:00:14


EXTRACT     RUNNING     EXT-EDS     00:00:00      unknown


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown


--Lag异常，等待恢复



GGSCI (localhost.localdomain) 8> stop ext-eds



Sending STOP request to EXTRACT EXT-EDS ...



Recovery is not complete.  This normal stop will wait and checkpoint recovery's


work when recovery has finished. To force Extract to stop now,


use the SEND EXTRACT EXT-EDS, FORCESTOP command.


--因为恢复没有完成导致该提示，可以忽略，等待



GGSCI (localhost.localdomain) 9> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     unknown       00:00:02


EXTRACT     STOPPED     EXT-EDS     01:51:12      00:00:01


EXTRACT     RUNNING     EXT-IM      00:00:00      1059:44:26


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      unknown      



GGSCI (localhost.localdomain) 10> start ext-eds



Sending START request to MANAGER ...


EXTRACT EXT-EDS starting



GGSCI (localhost.localdomain) 11> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     99:53:02      00:00:01


EXTRACT     RUNNING     EXT-EDS     01:51:12      00:00:10


EXTRACT     RUNNING     EXT-XZ      00:00:00      unknown


EXTRACT     RUNNING     P-EDS       00:00:00      unknown


EXTRACT     RUNNING     P-XZ        00:00:00      unknown


REPLICAT    RUNNING     REP-BOS     00:00:00      00:00:00    



GGSCI (localhost.localdomain) 12> stop ext-xz



Sending STOP request to EXTRACT EXT-XZ ...


Request processed.



GGSCI (localhost.localdomain) 13> start ext-xz



Sending START request to MANAGER ...


EXTRACT EXT-XZ starting



GGSCI (localhost.localdomain) 15> stop p-eds



Sending STOP request to EXTRACT P-EDS ...


Request processed.



GGSCI (localhost.localdomain) 16> start p-eds



Sending START request to MANAGER ...


EXTRACT P-EDS starting



GGSCI (localhost.localdomain) 17> stop p-xz



Sending STOP request to EXTRACT P-XZ ...


Request processed.



GGSCI (localhost.localdomain) 18> start p-xz



Sending START request to MANAGER ...


EXTRACT P-XZ starting



GGSCI (localhost.localdomain) 19> info all



Program     Status      Group       Lag           Time Since Chkpt



MANAGER     RUNNING


EXTRACT     RUNNING     EXT-ECP     00:00:00      00:00:01


EXTRACT     RUNNING     EXT-EDS     00:00:00      00:00:10


EXTRACT     RUNNING     EXT-IM      00:00:00      1059:45:28


EXTRACT     RUNNING     EXT-XZ      00:00:00      00:00:07


EXTRACT     RUNNING     P-EDS       00:00:00      00:00:04


EXTRACT     RUNNING     P-XZ        00:00:00      00:00:05


REPLICAT    RUNNING     REP-BOS     00:00:00      00:00:05


--重启所有异常进程，ogg工作正常



GGSCI (localhost.localdomain) 20>


5、总结处理步骤


强制关闭mgr,系统级别kill相关ogg进程,开启ogg主进程,重启相关进程


oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html