golden gate extract stuck

Posted by Roshan on Apr 29, 2019; 12:46pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/golden-gate-extract-stuck-tp7365.html

Hi Erman,

I am testing a golden gate extract using downstream database.

Please find attached the steps to configure.

downstream.docx

Log files are being shipped from source to the donwstream database and extract and pump processes are RUNNING.

However, I notice the extract is stuck

GGSCI (RHIS-BITEST-01) 3> send EXTDOWN status

Sending STATUS request to EXTRACT EXTDOWN ...
EXTRACT EXTDOWN (PID 21811)
  Current status: Recovery complete: Processing data

  Current read position:
  Redo thread #: 0  <-------------------------------showing 0
  Sequence #: 0 <-------------------------------showing 0
  RBA: 0 <-------------------------------showing 0
  Timestamp: 2019-04-29 16:35:26.000000
  SCN: 58.3900564062 (253008667230)
  Current write position:
  Sequence #: 3
  RBA: 29733
  Timestamp: 2019-04-29 16:44:39.250075
  Extract Trail: /data1/oggdwn/dirdat/SOURCE/lt

When I create a table on source, it does not get replicated.

downstream alert log:

alert_oggsrc.log

extract report file:
EXDWN2.rpt

Please advise.

Thanks,

Roshan