golden gate extract stuck

[Roshan]

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

[Roshan]

Please find attached the extract process details

extractinfo3.txt

[Roshan]

From the latest report file, I see DMLs are being captured but DDL is not being captured.
EXDWN3.rpt

[ErmanArslansOracleBlog]

First, please review the following note and update me->

GoldenGate Not Replicating One New Table (Doc ID 1595713.1)

[Roshan]

ok noted. thanks