How to sincronize high data volume with GoldenGate

I was taking high workload with data load methods, so I decided to move out of comfort zone and fortunately discovered a excellent way to copy/move high data volume with GoldenGate Initial Load.

It’s well documented by Oracle and gavinsoorma.com (best and simple one).

# On source GoldenGate (ggsci>):

GGSCI> ADD EXTRACT load1, SOURCEISTABLE
GGSCI> EDIT PARAMS load1

EXTRACT load1
userid ggate@goldengate
RMTHOST target-mgr.grepora.com, MGRPORT 7809
RMTTASK replicat, GROUP load2 FORMAT LEVEL 4

---Loading tables
map CUSTOMER.TABLE1;
 


# On target GoldenGate (target-mgr.grepora.com)  –  (its possible to be on same installation)

GGSCI> ADD REPLICAT load2, SPECIALRUN
GGSCI> EDIT PARAMS load2

REPLICAT load2
userid ggate@goldengate
ASSUMETARGETDEFS
SOURCECHARSET PASSTHRU

TABLE CUSTOMER.TABLE1, TARGET CUSTOMER_CLOUD.TARGET_TABLE1;

# On source GoldenGate (ggsci>):

GGSCI> start load1
GGSCI > start load1

Extracting from CUSTOMER.TABLE1 to CUSTOMER_CLOUD.TARGET_TABLE1:

*** Total statistics since 2016-08-12 19:04:16 ***
 Total inserts 8007208.00
 Total updates 0.00
 Total deletes 0.00
 Total discards 0.00
 Total operations 8007208.00

Tested this feature with source GG 12.2 and target GG 12.1, so it were necessary to specify ” FORMAT LEVEL 4″ on rmthost line.

This feature worked very well, and wasn’t necessary to create db links/bulk batch or technical WA.

I hope it help keep our lives more simple 🙂
Maiquel.
 

2 thoughts on “How to sincronize high data volume with GoldenGate

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.