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_at_gmail.com> 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
> 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 (
> _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
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l