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.
Pingback: How to sincronize high data volume with GoldenGate – Part II – |GREP ORA
Great post Maiquel! 😀