This is a question. If you still want the info you requested after checking
this then I will send them.
Isn’t the supplemental logging set using like what we previously did for
gm_wdata and gmmeta?
ADD SCHEMATRANDATA GM_WDATA ALLCOLS
ADD SCHEMATRANDATA GMMETA ALLCOLS
This is me checking it today:
GGSCI (corvette.corp.acxiom.net as service_gg@gmdwhp) 2> INFO SCHEMATRANDATA
GMMETA
2019-06-28 09:27:19 INFO OGG-06480 Schema level supplemental logging,
excluding non-validated keys, is enabled on schema "GMMETA".
2019-06-28 09:27:19 INFO OGG-01981 Schema level supplemental logging is
enabled on schema "GMMETA" for all columns.
2019-06-28 09:27:19 INFO OGG-10462 Schema "GMMETA" have 59 prepared tables
for instantiation.
GGSCI (corvette.corp.acxiom.net as service_gg@gmdwhp) 3> INFO SCHEMATRANDATA
GM_WDATA
2019-06-28 09:27:35 INFO OGG-06480 Schema level supplemental logging,
excluding non-validated keys, is enabled on schema "GM_WDATA".
2019-06-28 09:27:35 INFO OGG-01981 Schema level supplemental logging is
enabled on schema "GM_WDATA" for all columns.
2019-06-28 09:27:35 INFO OGG-10462 Schema "GM_WDATA" have 1,472 prepared
tables for instantiation.
GGSCI (corvette.corp.acxiom.net as service_gg@gmdwhp) 4> INFO SCHEMATRANDATA
GM_SDATA
2019-06-28 09:28:00 INFO OGG-01786 Schema level supplemental logging is
disabled on schema "GM_SDATA".
2019-06-28 09:28:00 INFO OGG-10462 Schema "GM_SDATA" have 654 prepared
tables for instantiation.
GGSCI (corvette.corp.acxiom.net as service_gg@gmdwhp) 5>
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Andrew Kerber
Sent: Tuesday, April 16, 2019 11:59 AM
To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Re: GGATE not replicating a new table - sanity check
Can you show the full extract, pump, and replicate parameter files? Its hard
to track this down without the full text.
On Tue, Apr 16, 2019 at 10:32 AM Chris Taylor
<christopherdtaylor1994@xxxxxxxxx<mailto:christopherdtaylor1994@xxxxxxxxx>>
wrote:
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
* SOURCE_SERV: GGSCI> stop EXT* ;
* SOURCE_SERV: GGSCI> stop PMP* ;
* TARGET_SERV: GGSCI> stop REP* ;
1. Edit the EXTRACT parameter file and add the new table{s) on SOURCE_SERV
ext_all.prm: TABLE SCHEMA.INVOICE_TABLE ;
2. Add supplemental logging on SOURCE for new tables (TRANDATA logging)
GGSCI> dblogin userid GG_USER, password " password " ;
GGSCI> add trandata SCHEMA.INVOICE_TABLE ;
3. Start Extracts and Pump processes on SOURCE_SERV
GGSCI> start EXT* ;
GGSCI> start PMP* ;
4. 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
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank You.
****************************************************************************
