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>