4 Replies Latest reply on Jun 5, 2014 4:57 PM by 2674291

    DDL replicated table has more rows in Target than in Source

    2674291

      Hi,


      I am new to GoldenGate and testing DDL support.


      On Source

      *********

      GG version is 12.1.2.0.0 (Integrated Extract Mode)

      DB Version is 11.2.0.4

      OS version is RHEL 6.4 64Bit

       

      GGSCI (source) 1> info all

       

      Program Status Group Lag at Chkpt Time Since Chkpt

       

      MANAGER RUNNING

      EXTRACT RUNNING EXT1 00:00:10 00:00:07

      EXTRACT RUNNING EXTPUMP 00:00:00 00:00:04

       

      GGSCI (source) 2> view params ext1

       

      EXTRACT ext1

      USERIDALIAS ggown

      LOGALLSUPCOLS

      UPDATERECORDFORMAT COMPACT

      EXTTRAIL /fs1/app/product/ogg/12.1.2.0.0/ogghome1/dirdat/et

      DDL INCLUDE, MAPPED OBJNAME GGTEST.*

      MAP GGTEST.*;

       

      GGSCI (source) 3> view params extpump

       

      EXTRACT extpump

      USERIDALIAS ggown

      RMTHOST usav1dba12t01, MGRPORT 7809

      RMTTRAIL /fs1/app/oracle/product/ogg/12.1.2.0.0/ogghome1/dirdat/rt

      MAP GGTEST.*;

       

      GGSCI (source) 12> ADD SCHEMATRANDATA ggtest

       

       

      2014-06-04 10:27:55  INFO    OGG-01788  SCHEMATRANDATA has been added on schema ggtest.

       

       

      2014-06-04 10:27:55  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema ggtest.

       

      SQL> create table ggtest.ind as select * from dba_indexes;

       

      Table created.

       

      SQL> select count(*) from IND;

       

      COUNT(*)

      ----------

      4791

      On target

      ********

      GG version is 12.1.2.0.0 (Integrated Replicat Mode)

      DB version is 11.2.0.4

      OS version is RHEL 5.5 64Bit

       

      GGSCI (target) 1> info all

       

      Program Status Group Lag at Chkpt Time Since Chkpt

       

      MANAGER RUNNING

      REPLICAT RUNNING REP1 00:00:00 00:00:07

       

      GGSCI (target) 2> view params rep1

       

      REPLICAT rep1

      SETENV (ORACLE_HOME="/fs1/app/oracle/product/11.2.0/dbhome_1")

      SETENV (ORACLE_SID="POCDB2")

      DBOPTIONS INTEGRATEDPARAMS(parallelism 2)

      USERIDALIAS ggown

      ASSUMETARGETDEFS

      HANDLECOLLISIONS

      MAP ggtest.*, TARGET ggtest.*;

       

      SQL> select count(*) from IND;

       

      COUNT(*)

      ----------

      4946

      There is a mismatch in number of rows replicated. I am unable to figure out where the additional rows have come from.


      Regards,

      Nagendra