1 Reply Latest reply: Aug 26, 2013 6:31 AM by sheeja.anil RSS

    Goldengate: Replication not happening.

    Danish297
      Hi All,

      My oracle golden gate replication is not working.

      all the required process is working fine on both source and target node.

      all the trail file is shipping from source to target etc.... but still changes made in Source DB not reflecting on Target DB.

      ISSUE: Replicate process is not able to read the trail file and unable to apply the changes to target Database.


      SOURCE INFO
      =========
      GGSCI (golden1.com) 176> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING
      EXTRACT RUNNING DPUMP 00:00:00 00:00:06
      EXTRACT RUNNING EXT1 00:00:00 00:00:04

      GGSCI (golden1.com) 179> view params mgr

      PORT 7809

      USERID ggs_owner, PASSWORD ggs_owner

      PURGEOLDEXTRACTS /u001/oracle/app/product/GG/dirdat/ex, USECHECKPOINTS

      GGSCI (golden1.com) 177> view params ext1

      extract ext1
      userid ggs_owner, password ggs_owner
      exttrail /u001/app/oracle/product/GG/dirdat/lt
      table DANISH.*;


      GGSCI (golden1.com) 178> view params dpump

      EXTRACT dpump
      USERID ggs_owner, PASSWORD ggs_owner
      RMTHOST 192.168.48.130, MGRPORT 7810
      RMTTRAIL /u001/app/oracle/product/GG/dirdat/rt
      PASSTHRU
      TABLE DANISH.*;



      TARGET INFO
      ==========

      GGSCI (golden2.com) 153> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING
      REPLICAT RUNNING REP1 00:00:00 00:00:09


      GGSCI (golden2.com) 157> view params rep1

      REPLICAT rep1
      ASSUMETARGETDEFS
      userid ggt_owner, password ggt_owner
      discardfile /u001/app/oracle/product/GG/discard/rep1_discard.txt,purge
      HANDLECOLLISIONS
      DDL INCLUDE ALL
      DDLERROR DEFAULT IGNORE RETRYOP
      MAP DANISH.TEMP_TEST,TARGET DANISH.TEMP_TEST;
      MAP DANISH.*,TARGET DANISH.*;


      GGSCI (golden2.com) 154> info rep1,detail

      REPLICAT REP1 Last Started 2013-01-11 15:49 Status RUNNING
      Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
      Log Read Checkpoint File /u001/app/oracle/product/GG/dirdat/lt000000
      First Record RBA 0

      Extract Source Begin End

      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record
      /u001/app/oracle/product/GG/dirdat/lt000000 * Initialized * First Record


      Current directory /u001/app/oracle/product/GG

      Report file /u001/app/oracle/product/GG/dirrpt/REP1.rpt
      Parameter file /u001/app/oracle/product/GG/dirprm/rep1.prm
      Checkpoint file /u001/app/oracle/product/GG/dirchk/REP1.cpr
      Checkpoint table ggt_owner.checkpoint
      Process file /u001/app/oracle/product/GG/dirpcs/REP1.pcr
      Stdout file /u001/app/oracle/product/GG/dirout/REP1.out
      Error log /u001/app/oracle/product/GG/ggserr.log

      GGSCI (golden2.com) 155> info rep1

      REPLICAT REP1 Last Started 2013-01-11 15:49 Status RUNNING
      Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
      Log Read Checkpoint File /u001/app/oracle/product/GG/dirdat/lt000000
      First Record RBA 0

      SQL> !ls -lrt /u001/app/oracle/product/GG/dirdat/
      total 28
      -rw-rw-rw- 1 oracle dba 1219 Jan 11 12:01 rt000000
      -rw-rw-rw- 1 oracle dba 1386 Jan 11 12:15 rt000001
      -rw-rw-rw- 1 oracle dba 1296 Jan 11 12:34 rt000002
      -rw-rw-rw- 1 oracle dba 1345 Jan 11 15:14 rt000003
      -rw-rw-rw- 1 oracle dba 1394 Jan 11 15:35 rt000004
      -rw-rw-rw- 1 oracle dba 1443 Jan 11 15:49 rt000005
      -rw-rw-rw- 1 oracle dba 1492 Jan 11 15:49 rt000006