ogg强制停掉复制进程

有个长事务的复制进程直接stop，需要等很久，那么我们可以通过kill的方式直接杀掉进程
[code]GGSCI (repdb2.800best.com) 69> STOP R12Q9

Sending STOP request to REPLICAT R12Q9 ...
STOP request pending end-of-transaction (2182132 records so far)..

GGSCI (repdb2.800best.com) 68> info R12Q9

REPLICAT R12Q9 Last Started 2014-03-26 16:08 Status RUNNING
Checkpoint Lag 02:38:47 (updated 00:50:59 ago)
Log Read Checkpoint File /u01/ogg/dirdat/Q9/Q9045324
2014-03-26 15:11:14.984745 RBA 399487166[/code]
首先info 进程名得到进程的号
然后ps -ef|grep rep 得到复制进程的pid AAAA
然后ps -ef|grep AAAA（上一步的pid），通过父子进程关系得到复制进程数据库中的pid BBB
然后sqlplus / as sysdba进数据库
根据pid在v$session和v$process中确认是否为ogg的进程
然后再
kill -9 BBBB
ps -ef|grep BBBB
ps -ef|grep AAAA
kill -9 AAAA
ps -ef|grep AAAA
[code][oracle@repdb2 ~]$ ps -ef |grep rep
oracle 458 23560 0 18:48 pts/4 00:00:00 grep rep
avahi 7551 1 0 Mar07 ? 00:00:00 avahi-daemon: running [repdb2.local]
oracle 30085 30019 6 16:08 ? 00:11:09 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS
You have new mail in /var/spool/mail/oracle
[oracle@repdb2 ~]$ ps -ef |grep 30085
oracle 535 23560 0 18:48 pts/4 00:00:00 grep 30085
oracle 30085 30019 6 16:08 ? 00:11:09 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS
oracle 30124 30085 20 16:08 ? 00:32:05 oracleNEWREPDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@repdb2 ~]$ ps -ef |grep 30124
oracle 597 23560 0 18:48 pts/4 00:00:00 grep 30124
oracle 30124 30085 19 16:08 ? 00:32:06 oracleNEWREPDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@repdb2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on DÇÆúèy 3ÔÂ 26 18:49:12 2014

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from gv$process where spid=30124;

INST_ID ADDR PID SPID USERNAME SERIAL#
---------- ---------------- ---------- ------------ --------------- ----------
TERMINAL PROGRAM
------------------------------ ------------------------------------------------
TRACEID
--------------------------------------------------------------------------------
B LATCHWAIT LATCHSPIN PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM
- ---------------- ---------------- ------------ ------------- ----------------
PGA_MAX_MEM
-----------
1 0000000F581DAC28 53 30124 oracle 8
UNKNOWN oracle@repdb2.800best.com (TNS V1-V3)

INST_ID ADDR PID SPID USERNAME SERIAL#
---------- ---------------- ---------- ------------ --------------- ----------
TERMINAL PROGRAM
------------------------------ ------------------------------------------------
TRACEID
--------------------------------------------------------------------------------
B LATCHWAIT LATCHSPIN PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM
- ---------------- ---------------- ------------ ------------- ----------------
PGA_MAX_MEM
-----------
1339925 1850813 524288
2495109

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@repdb2 ~]$ ps -ef|grep 30124
oracle 847 23560 0 18:51 pts/4 00:00:00 grep 30124
oracle 30124 30085 19 16:08 ? 00:32:13 oracleNEWREPDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@repdb2 ~]$ ps -ef|grep ggs
oracle 852 23560 0 18:51 pts/4 00:00:00 grep ggs
oracle 25532 24275 0 11:35 pts/6 00:00:00 tail -100f ggserr.log
oracle 30855 24650 0 16:39 pts/5 00:00:00 ./ggsci
[oracle@repdb2 ~]$ ps -ef|grep ogg
oracle 862 23560 0 18:52 pts/4 00:00:00 grep ogg
oracle 30019 1 0 16:08 ? 00:00:03 ./mgr PARAMFILE /u01/ogg/dirprm/mgr.prm REPORTFILE /u01/ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
oracle 30085 30019 6 16:08 ? 00:11:14 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS

[oracle@repdb2 ~]$ ps -ef|grep 30085
oracle 865 23560 0 18:52 pts/4 00:00:00 grep 30085
oracle 30085 30019 6 16:08 ? 00:11:17 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS
oracle 30124 30085 19 16:08 ? 00:32:28 oracleNEWREPDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@repdb2 ~]$ sqlplus / as sydba

SQL> set long 10000
SQL> set pagesize 10000

SQL> select * from v$session where paddr='0000000F581DAC28';

SADDR SID SERIAL# AUDSID PADDR USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME COMMAND OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER PROCESS
------------------------------ ------------
MACHINE
----------------------------------------------------------------
TERMINAL PROGRAM
------------------------------ ------------------------------------------------
TYPE SQL_ADDRESS SQL_HASH_VALUE SQL_ID SQL_CHILD_NUMBER
---------- ---------------- -------------- ------------- ----------------
PREV_SQL_ADDR PREV_HASH_VALUE PREV_SQL_ID PREV_CHILD_NUMBER
---------------- --------------- ------------- -----------------
PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID PLSQL_OBJECT_ID
--------------------- ------------------------- ---------------
PLSQL_SUBPROGRAM_ID MODULE MODULE_HASH
------------------- ------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
LOGON_TIME LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
-------------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION SEQ# EVENT#
----------------- ---------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT P3
---------------------------------------------------------------- ----------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE
--------------- -------------------
SERVICE_NAME SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T
-----
0000000F562DD800 613 32 2670261 0000000F581DAC28 60
GGUSR 7 2147483644 0000000F3A286B08
ACTIVE DEDICATED 60 GGUSR
oracle 30085
repdb2.800best.com
replicat@repdb2.800best.com (TNS V1-V3)
USER 0000000F5AEE3F68 2552060560 f7u5ty2c1uqnh 0
0000000F5AEE3F68 2552060560 f7u5ty2c1uqnh 0

OGG-R12Q9-OPEN_DATA_SOURCE 1467909010
0

42849798 58757 173 42089 0
26-3ÔÂ -14 0 NO NONE NONE NO
DISABLED ENABLED DISABLED
0
NO HOLDER
7156 116
db file sequential read
file# 173
00000000000000AD
block# 42089
000000000000A469
blocks 1
0000000000000001 1740759767 8
User I/O 0
0 WAITING
SYS$USERS DISABLED FALSE
FALSE

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@repdb2 ~]$ ps -ef|grep 30085
oracle 904 23560 0 18:54 pts/4 00:00:00 grep 30085
oracle 30085 30019 6 16:08 ? 00:11:23 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS
oracle 30124 30085 19 16:08 ? 00:32:43 oracleNEWREPDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@repdb2 ~]$ kill -9 30124
[oracle@repdb2 ~]$ ps -ef|grep 30085
oracle 920 23560 0 18:55 pts/4 00:00:00 grep 30085
oracle 30085 30019 7 16:08 ? 00:11:40 /u01/ogg/replicat PARAMFILE /u01/ogg/dirprm/R12Q9.prm REPORTFILE /u01/ogg/dirrpt/R12Q9.rpt PROCESSID R12Q9 USESUBDIRS
[oracle@repdb2 ~]$ kill -9 30085
[oracle@repdb2 ~]$

GGSCI (repdb2.800best.com) 85> !
info R12Q9

REPLICAT R12Q9 Last Started 2014-03-26 16:08 Status ABENDED
Checkpoint Lag 02:38:47 (updated 01:05:28 ago)
Log Read Checkpoint File /u01/ogg/dirdat/Q9/Q9045324
2014-03-26 15:11:14.984745 RBA 399487166[/code]