GoldenGate Extract Source 'Not Available' with Integrated Capture and Redo Logs

(Doc ID 1578876.1)

Last updated on DECEMBER 16, 2014

Applies to:

Oracle GoldenGate - Version 11.2.1.0.8 and later
Information in this document applies to any platform.

Goal

Redo log details from the database in Integrated capture mode show as "Not Available"

GGSCI > info pdrext01, detail
 .
 EXTRACT PDREXT01 Last Started 2013-08-15 11:01 Status RUNNING
 Checkpoint Lag 00:00:05 (updated 00:00:05 ago)
 Log Read Checkpoint Oracle Integrated Redo Logs
  2013-08-21 09:54:34
  SCN 0.3451151 (3451151)
  Target Extract Trails:
  Remote Trail Name Seqno RBA Max MB
  ./dirdat/pe 2 6787 100
  Extract Source Begin End
  Not Available 2013-08-14 11:13 2013-08-21 09:54
  Not Available 2013-08-14 11:13 2013-08-15 11:01
  Not Available 2013-08-14 11:13 2013-08-15 10:56
  Not Available * Initialized * 2013-08-14 11:13


Integrated Extract outbound server first scn: 0.2098968 (2098968)
 
Current directory /ggtest/app/oracle/product/11.2.0/gghome_112108
 
Report file /ggtest/app/oracle/product/11.2.0/gghome_112108/dirrpt/PDREXT01.rpt
Parameter file /ggtest/app/oracle/product/11.2.0/gghome_112108/dirprm/pdrext01.prm
Checkpoint file /ggtest/app/oracle/product/11.2.0/gghome_112108/dirchk/PDREXT01.cpe
Process file /ggtest/app/oracle/product/11.2.0/gghome_112108/dirpcs/PDREXT01.pce
Stdout file /ggtest/app/oracle/product/11.2.0/gghome_112108/dirout/PDREXT01.out

Error log /ggtest/app/oracle/product/11.2.0/gghome_112108/ggserr.log
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms