3 Replies Latest reply: Jan 14, 2013 11:18 AM by satrap RSS

    Isn't Table level logging a pre-requisite for Replication ?

    GarryB
      GG version      11.2.1.0.3
      RDBMS Version: 11.2.0.3 (Source and Target are of version 11.2.0.3)
      OS     :      RHEL 5.4


      After the initial load using expdp, impd Using GoldenGate we are replicating the DMLs of 5 tables (Uni-directonal) from source to target.

      DB level Supplemental logging is enabled in the source.
      SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v_$database;
      
      SUPPLEME
      --------
      YES
      we haven't enabled table level logging for these tables using ADD TRANDATA command like
      GGSCI > add trandata SCOTT.EMP
      Verified it by running
      GGSCI (cbrdf2) 2> info trandata SCOTT.*
      
      
      Logging of supplemental redo log data is disabled for table SCOTT.EMP.
      
      Logging of supplemental redo log data is disabled for table SCOTT.XXX.
      
      .
      .
      But the replication is working without any issues . So, Isn't table level logging a pre-requisite for Replication ?

      Only either one of the above logging method is enough ?