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,
Date: Tue, 16 Apr 2019 10:30:39 -0500
Message-ID: <CAP79kiR7w56=-=hcm+tQbV3xY2GwTSpCtVa-q-TvXpkH5EZ0FQ_at_mail.gmail.com>
List,
directory=DUMP_DIR
dumpfile=exp_ggate_%U.dmp
logfile=exp_ggate.log
parallel=8
tables=SCHEMA.INVOICE_TABLE
flashback_scn=1263790785581
status=30
- Start the export on SOURCE using the parameter file just created $ expdp parfile=ggate_exp.par
- Copy the dumpfiles to TARGET server
- 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
- Execute the import on TARGET server
- 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); - After import completes, start the REPLICATs
- Monitor for data changes in the SOURCE - once data changes in SOURCE, verify modified data appears in TARGET
- After confirming Replicats are working and data is replicating for new table, stop the REPLICATs and remove the FILTER line
- Restart Replicats after removing FILTER
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 16 2019 - 17:30:39 CEST