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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s