1 Reply Latest reply: Sep 2, 2013 3:51 PM by stevencallan RSS

    Golden Gate Schema Replication

    895876

      Guys - My requirement is fairly simple.I have two schemas, GG [Source] and GGR [Target] on the same host. Have one table called GG.SYNC_TABLE. I am having difficulties to push data from GG to GGR

       

      Below are the extract and replicat information

       

      EXTRACT EXT_AP1
      SETENV (ORACLE_SID=ERPA4)
      RMTHOST mcdeagaix825, mgrport 7809
      USERID GG@ERPA4, PASSWORD goldengate1
      DISCARDFILE ./dirrpt/ext_ap1_discard.rpt, append, megabytes 50
      RMTTRAIL ./dirdata/sa
      TABLE GG.AP_AE_HEADERS_ALL;
      TABLE GG.AP_AE_LINES_ALL;
      TABLE GG.AP_BANK_ACCOUNTS_ALL;
      TABLE GG.AP_BANK_BRANCHES;
      TABLE GG.AP_CARDS_ALL;
      TABLE GG.AP_CHECKS_ALL;
      TABLE GG.AP_CREDIT_CARD_TRXNS_ALL;
      TABLE GG.AP_EXPENSE_REPORTS_ALL;
      TABLE GG.AP_EXPENSE_REPORT_HEADERS_ALL;
      TABLE GG.AP_EXPENSE_REPORT_LINES_ALL;
      TABLE GG.AP_EXPENSE_REPORT_PARAMS_ALL;
      TABLE GG.AP_EXP_REPORT_DISTS_ALL;
      TABLE GG.AP_HOLDS_ALL;
      TABLE GG.AP_HOLD_CODES;
      TABLE GG.AP_INVOICES_ALL;
      TABLE GG.AP_INVOICE_DISTRIBUTIONS_ALL;
      TABLE GG.AP_INVOICE_LINES_ALL;
      TABLE GG.AP_INVOICE_PAYMENTS_ALL;
      TABLE GG.AP_NOTES;
      TABLE GG.AP_PAYMENT_HISTORY_ALL;
      TABLE GG.AP_PAYMENT_HIST_DISTS;
      TABLE GG.AP_PAYMENT_SCHEDULES_ALL;
      TABLE GG.AP_POL_VIOLATIONS_ALL;
      TABLE GG.AP_SELF_ASSESSED_TAX_DIST_ALL;
      TABLE GG.AP_SUPPLIERS;
      TABLE GG.AP_SUPPLIER_SITES_ALL;
      TABLE GG.AP_SYSTEM_PARAMETERS_ALL;
      TABLE GG.AP_TERMS_LINES;
      TABLE GG.AP_TOLERANCE_TEMPLATES;
      TABLE GG.SYNC_TABLE;

       

      REPLICAT REP_AP1

      SETENV (ORACLE_SID=ERPA4)

      USERID GG@ERPA4, PASSWORD goldengate1

      ASSUMETARGETDEFS

      REPORTCOUNT EVERY 1 MINUTES, RATE

      DISCARDFILE ./dirrpt/rep_ap1.dsc, PURGE

      MAP GG.AP_AE_HEADERS_ALL, TARGET GGR.AP_AE_HEADERS_ALL;

      MAP GG.AP_AE_LINES_ALL, TARGET GGR.AP_AE_LINES_ALL;

      MAP GG.AP_BANK_ACCOUNTS_ALL, TARGET GGR.AP_BANK_ACCOUNTS_ALL;

      MAP GG.AP_BANK_BRANCHES, TARGET GGR.AP_BANK_BRANCHES;

      MAP GG.AP_CARDS_ALL, TARGET GGR.AP_CARDS_ALL;

      MAP GG.AP_CHECKS_ALL, TARGET GGR.AP_CHECKS_ALL;

      MAP GG.AP_CREDIT_CARD_TRXNS_ALL, TARGET GGR.AP_CREDIT_CARD_TRXNS_ALL;

      MAP GG.AP_EXPENSE_REPORTS_ALL, TARGET GGR.AP_EXPENSE_REPORTS_ALL;

      MAP GG.AP_EXPENSE_REPORT_HEADERS_ALL, TARGET GGR.AP_EXPENSE_REPORT_HEADERS_ALL;

      MAP GG.AP_EXPENSE_REPORT_LINES_ALL, TARGET GGR.AP_EXPENSE_REPORT_LINES_ALL;

      MAP GG.AP_EXPENSE_REPORT_PARAMS_ALL, TARGET GGR.AP_EXPENSE_REPORT_PARAMS_ALL;

      MAP GG.AP_EXP_REPORT_DISTS_ALL, TARGET GGR.AP_EXP_REPORT_DISTS_ALL;

      MAP GG.AP_HOLDS_ALL, TARGET GGR.AP_HOLDS_ALL;

      MAP GG.AP_HOLD_CODES, TARGET GGR.AP_HOLD_CODES;

      MAP GG.AP_INVOICES_ALL, TARGET GGR.AP_INVOICES_ALL;

      MAP GG.AP_INVOICE_DISTRIBUTIONS_ALL, TARGET GGR.AP_INVOICE_DISTRIBUTIONS_ALL;

      MAP GG.AP_INVOICE_LINES_ALL, TARGET GGR.AP_INVOICE_LINES_ALL;

      MAP GG.AP_INVOICE_PAYMENTS_ALL, TARGET GGR.AP_INVOICE_PAYMENTS_ALL;

      MAP GG.AP_NOTES, TARGET GGR.AP_NOTES;

      MAP GG.AP_PAYMENT_HISTORY_ALL, TARGET GGR.AP_PAYMENT_HISTORY_ALL;

      MAP GG.AP_PAYMENT_HIST_DISTS, TARGET GGR.AP_PAYMENT_HIST_DISTS;

      MAP GG.AP_PAYMENT_SCHEDULES_ALL, TARGET GGR.AP_PAYMENT_SCHEDULES_ALL;

      MAP GG.AP_POL_VIOLATIONS_ALL, TARGET GGR.AP_POL_VIOLATIONS_ALL;

      MAP GG.AP_SELF_ASSESSED_TAX_DIST_ALL, TARGET GGR.AP_SELF_ASSESSED_TAX_DIST_ALL;

      MAP GG.AP_SUPPLIERS, TARGET GGR.AP_SUPPLIERS;

      MAP GG.AP_SUPPLIER_SITES_ALL, TARGET GGR.AP_SUPPLIER_SITES_ALL;

      MAP GG.AP_SYSTEM_PARAMETERS_ALL, TARGET GGR.AP_SYSTEM_PARAMETERS_ALL;

      MAP GG.AP_TERMS_LINES, TARGET GGR.AP_TERMS_LINES;

      MAP GG.AP_TOLERANCE_TEMPLATES, TARGET GGR.AP_TOLERANCE_TEMPLATES;

      MAP GG.SYNC_TABLE, TARGET GGR.SYNC_TABLE;

       

      Extract, Replicat and Manager processes are running fine. But a commit on target is not propagating the data across to GGR schema. Supplemental logging is enabled. Archiving is not [I hope its not required]. What do you think I am missing here?

        • 1. Re: Golden Gate Schema Replication
          stevencallan

          No point in doing this if you are not running in archived log mode. If you get behind for whatever reason and GoldenGate has to look further into the past that what is currently in your online redo log, game over.

           

          Have you tried the tutorial at Oracle Learning Library?

           

          Another thing - why would you use your GoldenGate user as part of your schema/data replication? That is only asking for trouble and unnecessary complexity.  The GoldenGate schema is used to drive the replication between other schemas, not itself.