GGATE not replicating a new table - sanity check

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 16 Apr 2019 10:30:39 -0500
Message-ID: <CAP79kiR7w56=-=hcm+tQbV3xY2GwTSpCtVa-q-TvXpkH5EZ0FQ_at_mail.gmail.com>



List,

I've got an interesting issue with a table I'm trying to add to Golden Gate (oracle to oracle).
It should be pretty simple, but its refusing to replicate and there's no errors or warnings.

Can I get a sanity check on these steps? I'm clearly overlooking something but I can't find it.

*I've redacted Server names and schema names.*

One thing I'm seeing on the Extract is messages like this which seem unusual compared to the other tables:

2019-04-08T14:01:03.047-0400 INFO OGG-02262 Oracle GoldenGate Capture for Oracle, pmp_opt.prm: Passthru wildcard MAP (TABLE) resolved (entry SCHEMA.*): TABLE "SCHEMA"."INVOICE_TABLE". Steps:

  1. Stop both the Extract & the Replicats
  2. SOURCE_SERV: GGSCI> stop EXT* ;
  3. SOURCE_SERV: GGSCI> stop PMP* ;
  4. TARGET_SERV: GGSCI> stop REP* ;
  5. Edit the EXTRACT parameter file and add the new table{s) on SOURCE_SERV ext_all.prm: TABLE SCHEMA.INVOICE_TABLE ;
  6. Add supplemental logging on SOURCE for new tables (TRANDATA logging) GGSCI> dblogin userid GG_USER, password " password " ; GGSCI> add trandata SCHEMA.INVOICE_TABLE ;
  7. Start Extracts and Pump processes on SOURCE_SERV GGSCI> start EXT* ; GGSCI> start PMP* ;
  8. Get current SCN on SOURCE db SQL> select current_scn from v$database;

CURRENT_SCN



1263790785581
  1. Create an expdp parameter file for expdp on SOURCE - include SCN from above

userid="/ as sysdba"

directory=DUMP_DIR

dumpfile=exp_ggate_%U.dmp

logfile=exp_ggate.log

parallel=8

tables=SCHEMA.INVOICE_TABLE

flashback_scn=1263790785581

status=30

  1. Start the export on SOURCE using the parameter file just created $ expdp parfile=ggate_exp.par
  2. Copy the dumpfiles to TARGET server
  3. Create an impdp parameter file on TARGET server
    ## Make sure to include EXCLUDE=REF_CONSTRAINT

userid="/ as sysdba"

directory=DUMP_DIR

dumpfile=exp_ggate_%U.dmp

logfile=imp_ggate.log

parallel=8

tables=SCHEMA.INVOICE_TABLE

status=30

EXCLUDE=REF_CONSTRAINT

  1. Execute the import on TARGET server
  2. Edit the Parameter file for the REPLICAT to include the new table AND the SCN (CSN) we captured in step 5
    ## Use Double Quotes around Transaction & CSN keywords
    MAP SCHEMA.INVOICE_TABLE, TARGET SCHEMA.INVOICE_TABLE, FILTER ( _at_GETENV ("TRANSACTION", "CSN") > 1263790785581);
  3. After import completes, start the REPLICATs
  4. Monitor for data changes in the SOURCE - once data changes in SOURCE, verify modified data appears in TARGET
  5. After confirming Replicats are working and data is replicating for new table, stop the REPLICATs and remove the FILTER line
  6. Restart Replicats after removing FILTER
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 16 2019 - 17:30:39 CEST

Original text of this message