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
1. SOURCE_SERV: GGSCI> stop EXT* ;
2. SOURCE_SERV: GGSCI> stop PMP* ;
3. TARGET_SERV: GGSCI> stop REP* ;
2. Edit the EXTRACT parameter file and add the new table{s) on
SOURCE_SERV
ext_all.prm: TABLE SCHEMA.INVOICE_TABLE ;
3. Add supplemental logging on SOURCE for new tables (TRANDATA logging)
GGSCI> dblogin userid GG_USER, password " password " ;
GGSCI> add trandata SCHEMA.INVOICE_TABLE ;
4. Start Extracts and Pump processes on SOURCE_SERV
GGSCI> start EXT* ;
GGSCI> start PMP* ;
5. 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 ( @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
