Forum Stats

  • 3,840,087 Users
  • 2,262,565 Discussions
  • 7,901,149 Comments

Discussions

Goldengate extract parameter TABLE with wildcard "*" not working

User_HM44O
User_HM44O Member Posts: 12 Green Ribbon

im new to goldengate, i want to replicate the whole schema with the use of wildcard "*" but it wont work, it works only when i specify one table and i want the whole schema.


can someone help me?


ps: im using oracle database 19c and goldengate 19 using three vms one for each database and one for the goldengate, and this is my extract parameter and its report:

EXTRACT ex1

LOGALLSUPCOLS

FETCHOPTIONS FETCHPKUPDATECOLS, USESNAPSHOT, USELATESTVERSION

DBOPTIONS ALLOWUNUSEDCOLUMN

DISCARDFILE /u01/app/oracle/product/19.0.0/gghome_1/DISCARD/CRM_B2B1.dsc, APPEND, MEGABYTES 100

tranlogoptions IntegratedParams (max_sga_size 256)

UPDATERECORDFORMAT COMPACT

exttrail /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex

ddl include all

GETTRUNCATES

useridalias ggadmine

SOURCECATALOG EAST

TABLE ggadmin.*;

---------------------------------------------------------

---------------------------------------------------------

***********************************************************************

         Oracle GoldenGate Capture for Oracle

  Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO

  Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:58

 

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.


          Starting at 2022-05-25 19:58:05

***********************************************************************


Operating System Version:

Linux

Version #1 SMP Tue Apr 5 16:57:59 UTC 2022, Release 3.10.0-1160.62.1.el7.x86_64

Node: localhost.localdomain

Machine: x86_64

             soft limit  hard limit

Address Space Size  :  unlimited  unlimited

Heap Size      :  unlimited  unlimited

File Size      :  unlimited  unlimited

CPU Time       :  unlimited  unlimited


Process id: 29676


Description: 


***********************************************************************

**      Running with the following parameters         **

***********************************************************************


2022-05-25 19:58:06 INFO  OGG-03059 Operating system character set identified as UTF-8.


2022-05-25 19:58:06 INFO  OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.


2022-05-25 19:58:06 INFO  OGG-01360 EXTRACT is running in Integrated mode.

EXTRACT ex1

LOGALLSUPCOLS


2022-05-25 19:58:07 WARNING OGG-04033  LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.

FETCHOPTIONS FETCHPKUPDATECOLS, USESNAPSHOT, USELATESTVERSION

DBOPTIONS ALLOWUNUSEDCOLUMN

DISCARDFILE /u01/app/oracle/product/19.0.0/gghome_1/DISCARD/CRM_B2B1.dsc, APPEND, MEGABYTES 100

tranlogoptions IntegratedParams (max_sga_size 256)

UPDATERECORDFORMAT COMPACT

exttrail /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex

ddl include all

GETTRUNCATES

useridalias ggadmine


2022-05-25 19:58:08 INFO  OGG-02623 Default source catalog name EAST will be used for source table name ggadmin.* mapping.


2022-05-25 19:58:08 INFO  OGG-00506 Both GETTRUNCATES and DDL replication are enabled.


2022-05-25 19:58:08 INFO  OGG-01815 Virtual Memory Facilities for: BR

  anon alloc: mmap(MAP_ANON) anon free: munmap

  file alloc: mmap(MAP_SHARED) file free: munmap

  target directories:

  /u01/app/oracle/product/19.0.0/gghome_1/BR/EX1.


Bounded Recovery Parameter:

BRINTERVAL = 4HOURS

BRDIR   = /u01/app/oracle/product/19.0.0/gghome_1/


2022-05-25 19:58:08 INFO  OGG-01851 filecaching started: thread ID: 140431606146816.


2022-05-25 19:58:08 INFO  OGG-01815 Virtual Memory Facilities for: COM

  anon alloc: mmap(MAP_ANON) anon free: munmap

  file alloc: mmap(MAP_SHARED) file free: munmap

  target directories:

  /u01/app/oracle/product/19.0.0/gghome_1/dirtmp.


2022-05-25 19:58:08 INFO  OGG-25340  

Database Version:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.


2022-05-25 19:58:08 INFO  OGG-25341  

Database Language and Character Set:

NLS_LANGUAGE   = "AMERICAN" 

NLS_TERRITORY  = "AMERICA" 

NLS_CHARACTERSET = "AL32UTF8".


2022-05-25 19:58:08 INFO  OGG-06604 Database ORCL CPU info: CPU Count 1, CPU Core Count 1, CPU Socket Count 1.


2022-05-25 19:58:08 INFO  OGG-06618 Database ORCL Platform: Linux x86 64-bit.


2022-05-25 19:58:13 INFO  OGG-02339 Integrated capture successfully attached to logmining server OGG$CAP_EX1 using 60 second streaming duration.


2022-05-25 19:58:13 INFO  OGG-02089 Source redo compatibility version is: 19.0.0.


2022-05-25 19:58:13 INFO  OGG-02086 Integrated Dictionary will be used.


2022-05-25 19:58:13 WARNING OGG-02905 Replication of OID column in object tables may diverge.


2022-05-25 19:58:13 INFO  OGG-02776 Native data capture is enabled for Oracle NUMBER data type.


2022-05-25 19:58:13 INFO  OGG-01971 The previous message, 'INFO OGG-02776', repeated 1 times.


2022-05-25 19:58:13 INFO  OGG-01055 Recovery initialization completed for target file /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex000000082, 

at RBA 1408.


2022-05-25 19:58:13 INFO  OGG-01478 Output file /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex is using format RELEASE 19.1.


2022-05-25 19:58:13 INFO  OGG-02776 Native data capture is enabled for Oracle NUMBER data type.


2022-05-25 19:58:13 INFO  OGG-01026 Rolling over remote file /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex000000082.


2022-05-25 19:58:13 INFO  OGG-01053 Recovery completed for target file /u01/app/oracle/product/19.0.0/gghome_1/dirdat/ex000000083, at RBA 1408.


2022-05-25 19:58:13 INFO  OGG-01057 Recovery completed for all targets.


***********************************************************************

**           Run Time Messages               **

***********************************************************************

Tagged:

Answers