5 Replies Latest reply: Jan 15, 2013 1:13 AM by 976081 RSS

    Replicate not able to read from trail file

    976081
      Hi Experts ,

      I just tried to configure a simple replication from one machine to another with a small table.I have enabled supplemental logging in database as well as in the required tables and source is in archive mode . The problem i am facing is that there is no errors in extract ,pump or replicate.But my replicate is not able to update the new updates at source .Kindly help .Sufficient privileges given to user in source and destination The parameters are given below

      l  source


      GSCI (ggdest) 7> start mgr

      Starting Manager as service ('GGSMGR')...
      Service started.


      GGSCI (ggdest) 8> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING


      GGSCI (ggdest) 9> dblogin userid ggate password password
      Successfully logged into database.

      GGSCI (ggdest) 10> edit params E1_ITMS


      GGSCI (ggdest) 11> ADD EXTRACT E1_ITMS,TRANLOG,BEGIN NOW
      EXTRACT added.
      GGSCI (ggdest) 12> add exttrail /ggate/dirdat/ET,extract E1_ITMS,MEGABYTES 100
      EXTTRAIL added.



      GGSCI (ggdest) 18> add extract P1_ITMS,EXTTRAILSOURCE /ggate/dirdat/ET
      EXTRACT added.
      GGSCI (ggdest) 10> add rmTtrail /ggs/dirdat/RT,EXTRACT P1_ITMS,MEGABYTES 100
      RMTTRAIL added.



      GGSCI (ggdest) 14> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING
      EXTRACT RUNNING E1_ITMS 00:00:00 00:00:06
      EXTRACT RUNNING P1_ITMS 00:00:00 00:00:00


      GGSCI (ggdest) 37> view params E1_ITMS
      extract E1_ITMS
      userid ggate, password password
      exttrail /ggate/dirdat/ET
      reportcount every 5 minutes, rate
      Table GGATE.BOOKS;


      GGSCI (ggdest) 38> view params P1_ITMS
      extract P1_ITMS
      passthru
      rmthost 192.168.1.100,MgrPort 7809
      rmttrail /ggs/dirdat/RT
      table *;


      Destination


      GSCI (ggdest) 10> EDIT PARAMS ./GLOBALS


      GGSCI (ggdest) 11> ADD CHECKPOINTTABLE CKPTAB

      Successfully created checkpoint table CKPTAB.

      GGSCI (ggdest) 12> info CHECKPOINTTABLE CKPTAB

      Checkpoint table CKPTAB created 2013-01-05 13:38:34.


      GGSCI (ggdest) 40> add replicat R1_ITMS,EXTTRAIL \ggs\dirdat\RT ,checkpointtable ggs_owner.ckptab;
      REPLICAT added.


      GGSCI (ggdest) 43> info all

      Program Status Group Lag at Chkpt Time Since Chkpt

      MANAGER RUNNING
      REPLICAT RUNNING R1_ITMS 00:00:00 00:00:03