GoldenGate°²×°²¿Êð¼°½â¾ö·½°¸

userid ddw,password ddw

reperror default, discard discardfile D:\\reptmy.dsc,append,megabytes 100

INSERTAPPEND --ʹÓÃÖ±½Ó·¾¶¼ÓÔØ£¬Ìá¸ß¼ÓÔØËÙ¶È

HANDLECOLLISIONS --µ±Ä¿±ê¶ËÒÑÓÐÊý¾Ýʱ£¬ÂÔ¹ýÖØ¸´Êý¾Ý´íÎó MAP ddw.test, TARGET ddw.test1; ***/

×¢Ò⣬ÕâÀïµÄextractºÍreplicat½ø³ÌÌí¼ÓÍêºóÔÚinfo allÖп´²»µ½Õâ¸ö½ø³Ì£¬µ«ÊÇview report¿ÉÒÔ¸ú×Ùµ½¡£

Òª¿ªÊ¼¼ÓÔØ£¬ÔÚÔ´¶ËÖ´ÐУº GGSCI> start exttmy

Ä¿±ê¶ËµÄreplicat½ø³Ì²»ÐèҪȥÆô¶¯£¬»á×Ô¶¯½øÐÐÊý¾ÝÓ¦Óá£

5.1.2 ÓëOracleÊý¾Ý±ÃÊý¾Ý¼ÓÔØËٶȵıȽÏ

°´ÕÕ5.6.1ʾÀýÖеÄÅäÖ㬶ÔÒ»ÕÅ600ÍòÐÐÊý¾ÝµÄ²âÊÔ±í½øÐгõʼ»¯¼ÓÔØ£¬ÍêÈ«¼ÓÔØ½áÊø´óÔ¼ÐèÒª50·ÖÖÓ¡£ ʹÓÃOracle 10gµÄÊý¾Ý±Ã¹¤¾ß¶ÔͬÑùµÄ±í£¬Í¨¹ýDB LinkµÄ·½Ê½½øÐгõʼ»¯¼ÓÔØ£º C:\\>impdp ddw/ddw@orcl job_name=zhouimp tables=test CONTENT=DATA_ONLY network_link=\

Ö»ÐèÒª1·Ö°ëÖӾ͵¼ÍêÁË600ÍòÐÐÊý¾Ý¡£Á½ÕßµÄÖ´ÐÐЧÂʲî±ðÌ«´óÁË¡£ ËùÒÔÔÚÒ»°ãÇé¿öÏ£¬¾¡Á¿Ê¹ÓÃÆäËû¸ßЧµÄÊý¾Ý¿â´«Ê乤¾ßÀ´Íê³É³õʼ»¯¼ÓÔØ£¬¶ø²»ÒªÓÃGoldenGateÌá¸ßµÄ³õʼ»¯¹¦ÄÜ¡£

5.2 Ò»¶Ô¶àÊý¾Ýͬ²½£¨¹ã²¥¸´ÖÆ£©

Ò»¶Ô¶àÊý¾Ýͬ²½ÊµÏּܹ¹£º

רҵ×ÊÁÏ

GoldenGate¶ÔÓÚ¶à¶ÔÒ»µÄʵÏÖ·½Ê½£¬¾ÍÊǶÔÓÚͬһ¸öÔ´½¨Á¢¶à¸öÌáÈ¡½ø³Ìͬ²½½øÐУ¬Ò²¾ÍÊÇ˵£¬¶ÔÓ¦²»Í¬µÄÄ¿±ê¶Ë£¬·Ö±ðÅäÖÃͬ²½½ø³Ì½øÐÐͬ²½¡£ÅäÖùý³ÌÓëÇ°ÃæÊÇÒ»ÑùµÄ¡£

ÕâÀïµÄ¶à¸öÄ¿±ê¶Ë£¬ÓпÉÄܶÔÓ¦²»Í¬µÄÊý¾Ý¿â£¬Ò²ÓпÉÄÜÊÇͬһ¸ö¿âÖеIJ»Í¬¶ÔÏó¡£Èç¹ûÊÇͬ²½µ½Í¬Ò»¸ö¿âÖеIJ»Í¬¶ÔÏ󣬳ýÁË·Ö±ðÅäÖÃͬ²½½ø³ÌÒÔÍ⣬ÓÐʱºòÒ²¿ÉÒÔÔÚÒ»¸ö½ø³ÌÖÐÍê³É£¬±ÈÈ磬¿ÉÒÔÔÚ¸´ÖƶËÈç´ËÅäÖ㺠/***

REPLICAT rep146e1

USERID coss3,PASSWORD coss3 assumetargetdefs

REPERROR default,discard

DISCARDFILE d:\\ggoracle\\log\\rep146e1.dsc,append,megabytes 200 HANDLECOLLISIONS

MAP ddw.test, TARGET ddw.test1;

MAP ddw.test, TARGET ddw.test2; --ͬһÕűíͬʱ¶ÔÓ¦¶à¸ö±í MAP ddw.test, TARGET ddw.test3; ***/

µ±È»£¬Èç¹ûͬ²½Êý¾Ý¸ºÔؽϴóµÄÇé¿öÏ£¬»¹Êǽ¨ÒéÔÚ½ø³Ì¼¶±ð·Ö¿ª¡£

5.3 ¶à¶ÔÒ»Êý¾Ýͬ²½£¨¼¯Öи´ÖÆ£©

¶à¶ÔÒ»Êý¾Ýͬ²½¼Ü¹¹£º

רҵ×ÊÁÏ

¶à¶ÔÒ»Êý¾Ýͬ²½ÊµÏÖ·½Ê½Í¬Ò»¶Ô¶à£¬Ò²Êǽ«extract-replicat½«½ø³Ì²ð·Ö³É¶à¸ö¡£ ¶à¶Ôһͬ²½ÐèҪעÒâµÄÊÇ£¬ËùÓÐÔ´¶ËºÍÄ¿±ê¶ËµÄ±í¶¼Ó¦¸ÃʹÓÃÒ»ÖµÄÖ÷¼üÔ¼Êø£¬¶øÇÒÔÚ²»Í¬µÄÔ´¶Ë²»Ó¦¸Ã¶Ôͬһ¼üÖµµÄÊý¾Ý½øÐÐά»¤¡£Ò²¾ÍÊÇ˵£¬ÐèÒªÔÚÒµÎñÉϽ«²»Í¬Ô´µÄÊý¾Ý¸ôÀ뿪À´£¬ÒÔ·ÀÖ¹¶ÔͬһÊý¾ÝµÄ¸²¸Ç¸ü¸ÄµÈÎÊÌâ¡£Ò»°ãÓÃÓÚά»¤ÒµÎñµÄÇøÓòÐÔÊý¾Ý¡¢È»ºóͳһͬ²½µ½ÒµÎñÖÐÐÄÊý¾ÝÔ´µÄÒµÎñ³¡¾°¡£ »¹ÓÐÒ»¸öÐèҪעÒâµÄ·½ÃæÊÇTRUCATEµÄ²¶»ñ£¬ÔÚ¶à¶ÔÒ»µÄÅäÖÃÏÂÓ¦±ÜÃâ²¶»ñ¡£ÒòΪGoldenGate´¦ÀíTRUNCATEͬ²½ÊÇÖ±½Ó´«ÊäÁËÕâ¸öÓï¾ä£¬²¢²»»áÌṩ¾ßÌåɾ³ýµÄÊý¾ÝÐÅÏ¢£¨Ã»ÓÐREDOÒ²ÎÞ·¨Ìṩ£©£¬ËùÒÔÎÞÂÛÄĸöÔ´¶ËÖ´ÐÐÁËTRUNCATE£¬Èç¹ûͬ²½µ½ÁËÄ¿±ê¶Ë£¬¶¼»áÖ±½Ó°ÑÄ¿±ê¶ËµÄ±íÊý¾ÝÖ±½Óɾ¹â£¬ÎÞÂÛÄ¿±êÊý¾ÝÊÇ·ñÊÇÀ´Ô´ÓÚÕâ¸öÔ´£¬Ôì³ÉÊý¾ÝµÄ²»Ò»Ö¡£

5.4 Êý¾Ýת»»ºÍ¹ýÂË

GlodenGateÖÐÖ§³Ö×Ö¶ÎÓ³Éä¡¢Êý¾Ýɸѡת»»£¬ÒÔ¼°µ÷ÓÃÖ´ÐÐÊý¾Ý¿â½Å±¾»òÕßSQLÓï¾äµÈ£¬ÔÚÒ»¶¨Ìõ¼þÏ£¬ÉõÖÁ¿ÉÒÔʵÏÖʵʱETLµÄ¹¦ÄÜ¡£

5.4.1 ×Ö¶ÎÓ³Éä

GoldenGateÖÐ×ֶεÄÓ³ÉäÒ»°ãÅäÖÃÔÚ¸´ÖÆÓ¦Óö˵ÄMAP²ÎÊýÖУ¬×Ö¶ÎÓ³ÉäÒªÇóÁ½±ß¾¡Á¿Ò»ÖµÄ×ֶεÄÀàÐÍ£¬µ±È»Ò²ÔÊÐíCHAR<->VARCHARÖ®ÀàµÄת»»¡£¶ÔÓÚ²»Í¬×Ö¶ÎÀàÐ͵ÄÓ³É䣬×îºÃÏêϸ²Î¿¼GoldenGate¹Ù·½ÎĵµÒԵõ½×ã¹»µÄÖ§³ÖÐÅÏ¢£¬²¢×öºÃ²âÊÔÑéÖ¤ÒÔ·ÀÖ¹Êý¾Ý¶ªÊ§µÈ¡£ÒÔÏÂÊÇ×Ö¶ÎÓ³ÉäµÄÅäÖÃÀý×Ó£º Àý×Ó1£º

רҵ×ÊÁÏ

/***

MAP ddw.a1test, target ddw.a2test, --targetǰһ¶¨ÒªÁô¸ö¿Õ¸ñ£¬·ñÔò»á±¨´í COLMAP (id = id, type1 = type1, sell_date1 = sell_date2); --×Ö¶ÎÓ³ÉäÅäÖà ***/

Àý×Ó2£º /***

MAP ddw.a1test, target ddw.a2test,

COLMAP (USEDEFAULTS, sell_date1 = sell_date2); --USEDEFAULTS±íʾ×Ô¶¯Ó³ÉäͬÃû×Ö¶Î MAP ddw.a3test, target ddw.a4test; --²»Í¬µÄ±íÓ³É䣬²»Í¬µÄmap

MAP ¡°ddw.a5test¡±, target ¡°ddw.a6test¡±; --ÔÚÓÐЩ´óСдÃô¸ÐµÄÊý¾ÝÔ´ÐèÒªÒýºÅÇø·Ö´óСд

***/

Àý×Ó3£º /***

MAP ddw.a1test, target ddw.a2test,

COLMAP (USEDEFAULTS, num = 111, name = \ @DATENOW()); --×Ö¶ÎÖ¸¶¨¹Ì¶¨Öµ£¬×¢Òâ×Ö·ûÖµ¼ÓÒýºÅ£¬Êý×ÖÖµ²»¿É¼ÓÒýºÅ£»@DATENOW()±íʾµ±Ç°ÏµÍ³Ê±¼ä ***/

Àý×Ó4£º /***

MAP ddw.a1test, target ddw.a2test, COLMAP (USEDEFAULTS, transaction_date = @DATE (¡°YYYY-MM-DD¡±, ¡°YY¡±, YEAR, ¡°MM¡±, MONTH, ¡°DD¡±, DAY),);

--¶à¸ö×Ö·û×Ö¶ÎÕûºÏת»»ÎªÄ¿±ê¶ËµÄÒ»¸öʱ¼ä×Ö¶Î ***/

ÔÚÕâÀï˳±ã²åÈëÒ»¸öºÜÈÝÒ׳ö´íµÄ±íÓ³ÉäÀý×Ó£º /***

map ddw.a*, target ddw.*; --ͨÅä·û±íʾËùÓÐa¿ªÍ·µÄ±í½øÐÐÓ³É䣬עÒâµÄÊÇtargetºóÃæµÄ±íÃûǧÍò

²»ÄÜҲд³Éddw.a*£¬²»È»»á±»Ó³Éä³ÉÄ¿±ê¶Ëaa¿ªÍ·µÄ±í ***/

5.4.2 ×ֶκÍÊý¾Ýɸѡ

GoldenGateÖÐ×ֶεÄɸѡһ°ã¶¼ÔÚTABLE²ÎÊýÖÐÅäÖã¨Ä¿±ê¶ËÊÇÔÚMAP²ÎÊý£©¡£Ò»°ãÍÆ¼öÔÚÔ´¶Ëextract½ø³ÌÅäÖÃÎļþÖÐÅäÖã¬ÕâÑù¿ÉÒÔÓÐЧµÃ¼õСtrailÎļþµÄ´óС£¬¼õÐ¡ÍøÂç¸ºÔØ¡£ÒÔÏÂÊÇһЩɸѡÅäÖÃÀý×Ó£¨Ö»ÁгöÅäÖÃÎļþµÄTABLE²ÎÊý²¿·Ö£©¡£

רҵ×ÊÁÏ

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)