Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GG stop Extract waiting on recovery that seems like stuck.

DM10430Nov 10 2016 — edited Nov 11 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2016
Added on Nov 10 2016
3 comments
746 views