I need to stop one extract process out of several setup for this environment.
1. Initially STOP extract waiting on receovery.
2. Forced stopped, stopped the process but started again automatically (As other processes are setup, can not disable autostart)
3. Started extract again, also with begin now (As this is system test env).
4. But still graceful stop is waiting for recovery. How I can stop the extract gracefully?
GGSCI (hw-sls-db02.syniverse.com) 3> send extract EXTOPCF status
Sending STATUS request to EXTRACT EXTOPCF ...
EXTRACT EXTOPCF (PID 69882)
Current status: In recovery[1]: Processing data with empty data queue
Current read positions:
Redo thread #: 1
Sequence #: 10577
RBA: 132630032
Timestamp: 2016-11-10 13:38:21.000000
SCN: 991.2866473491
Redo thread #: 2
Sequence #: 6822
RBA: 537104
Timestamp: 2016-11-10 13:38:21.000000
SCN: 991.2866473491
Redo thread #: 3
Sequence #: 7253
RBA: 5518864
Timestamp: 2016-11-10 13:38:19.000000
SCN: 991.2866473479
Current write position:
Sequence #: 57
RBA: 2965
Timestamp: 2016-10-04 21:22:52.263314
Extract Trail: ./dirdat/ec
PENDING
STOP request pending end of recovery
GGSCI (hw-sls-db02.syniverse.com) 5> send EXTOPCF,showtrans
Sending SHOWTRANS request to EXTRACT EXTOPCF ...
No transactions found
Oldest redo log files necessary to restart Extract are:
Redo Thread 1, Redo Log Sequence Number 10577, SCN 991.2866552569 (4259179142905), RBA 156603920
Redo Thread 2, Redo Log Sequence Number 6822, SCN 991.2866552570 (4259179142906), RBA 22322192
Redo Thread 3, Redo Log Sequence Number 7253, SCN 991.2866552567 (4259179142903), RBA 27735056.
GGSCI (hw-sls-db02.syniverse.com) 6>
GGSCI (hw-sls-db02.syniverse.com) 6> info EXTOPCF detail
EXTRACT EXTOPCF Last Started 2016-11-10 13:34 Status RUNNING
Checkpoint Lag 00:00:01 (updated 00:00:00 ago)
Log Read Checkpoint Oracle Redo Logs
2016-11-10 17:49:26 Thread 1, Seqno 10577, RBA 156631040
SCN 991.2866552713