ããOracle GoldenGate ç¨äºå¨åç§ä¼ä¸ç³»ç»é´ä»¥äºç§çº§é度å¤å¶åéæäºå¡æ°æ®ï¼æ¯åç±»æä½³çãæäºé¨ç½²ç产åãOracle GoldenGate å¯ä»¥çµæ´»å°å¨åç±»åå¼ç±»ç³»ç»ï¼å
æ¬ä¸åçæ¬ç Oracle Databaseãä¸åç硬件平å°ï¼ä¹é´ä»¥å Oracle æ°æ®åºåé Oracle æ°æ®åºï¼å
æ¬ Microsoft SQL Serverãç¨äºå¼æ¾ç³»ç»å z/OS ç IBM DB2ãSybase ççï¼ä¹é´ç§»å¨æ°æ®ã
ããæ¬ææ¼ç¤ºå¦ä½å®è£
ã设置åé
ç½®æ¤äº§å以轻æ¾å®ç° Oracle Database 10g å 11g ä¹é´æ°æ®çæ ç¼å¤å¶ï¼è¿ä»ç»äºæ¤äº§åçå éè½åã
ããOracle äº 2009 å¹´æ¶è´äº GoldenGateï¼æ们å¯ä»¥çå°å¨å
¨çåè¡ä¸è¶
è¿ 4,000 个解å³æ¹æ¡ä¸å®æ½äº Oracle GoldenGateã该软件æ§è¡å®æ¶çãåºäºæ¥å¿çæ´æ¹æ°æ®æè· (CDC)ï¼è½å¤å¨å¼ææ°æ®åºé´ä»¥æä½ç延è¿åå¾å°ç空é´ç§»å¨å¤§éäºå¡æ°æ®ã
ããé常ï¼æ¨é¨ç½² GoldenGate æè·ãæ°æ®æ³µå交ä»è¿ç¨ï¼å¹¶ä¸å¯å°è¿äºè¿ç¨é¨ç½²å¨è®¸å¤ä¸åçæä½ç³»ç»åæ°æ®åºä¸ãå¯æ ¹æ®ç®æ æ°æ®åºçéè¦ï¼å¤å¶æææ°æ®æé¨åæ°æ®ãå½ Oracle GoldenGate ç¨äº Oracle æ°æ®åºæ¶ï¼å¯ä»¥å¤å¶æ°æ®æä½è¯è¨ (DML) åæ°æ®å®ä¹è¯è¨ (DDL) æä½ãï¼ç®ååªè½å¨åç±»ï¼ä¸è½å¨å¼ç±»çï¼Oracle çæ¬é´å¤å¶ DDL æä½ãï¼Oracle GoldenGate å®æ¹æ¯æ Oracle9i 第 2 çå° Oracle Database 11g 第 2 çï¼å¹¶ä¸å¯¹ææè¿äºçæ¬æä¾ DML/DDL æ¯æã该产åå¯ç¨äº Oracle Database çä¼ä¸çåæ åçã
ããå¦ä¸æè¿°ï¼å¯ä»¥å¨ææ¯æçåç±»æå¼ç±» Oracle Database çæ¬é´ç§»å¨æ°æ®ï¼ä¹å¯ä»¥å¨ Oracle æ°æ®åºåé Oracle æ°æ®åºé´ç§»å¨æ°æ®ã大å¤æ°æ
åµä¸ï¼å¯å¯¹æ°æ®è¿è¡çéãæ å°å转æ¢ã注æï¼å¦æå¯ç¨äº DDL æ¯æï¼æ¢è¨ä¹ï¼å¦æä½¿ç¨ GoldenGate è¿è¡åç±» Oracle Database çæ¬ä¹é´ç DDL å¤å¶ï¼ï¼åä¸æ¯ææ°æ®çéãæ å°å转æ¢ã
ããOracle GoldenGate æ¯ä»¥ DBA 为ä¸å¿çï¼å æ¤ DBA å¾å®¹æå¦ä¼å¦ä½ä½¿ç¨å®ãå
¶å®ç°æ¶é´ä¹æ¯æå°ç â ä¸äºç«ç¹åªç¨ä¸ä¸ªæçæ¶é´å°±å®å
¨ä»è¯¸å®ç°ã
ããå¯è·å¾ä»ä¹
ããOracle GoldenGate 产åç³»åå
æ¬ï¼
ããOracle GoldenGate
ããManagement Pack for Oracle GoldenGateï¼ä¹ç§°ä¸º Oracle GoldenGate Directorï¼Oracle GoldenGate Veridata
ããOracle GoldenGate Application Adapters
ããOracle GoldenGate for Mainframe
ãã为使å¢å¼æå¡é ç¦å®¢æ·ï¼Oracle GoldenGate æ ¸å¿è®¸å¯å
æ¬ Oracle Active Data Guard çå
¨æ使ç¨è®¸å¯å Oracle Database ä¸ XStream çå
¨æ使ç¨è®¸å¯ãXStream æ¯ä¸ Oracle Streams æ¥å£ç APIãOracle Active Data Guard æ¯æ主å¨æå¼å¤ç¨æ°æ®åºä»¥æä¾æ¥è¡¨æå¡ï¼çè³å¨åºç¨éåæ°æ®çåæ¶ä¹å¦æ¤ãè¿ä¸ªç¹æ§é常æ£ï¼å¯å°ç产æ¥è¡¨åæ¥è¯¢å·¥ä½åæµå°å¤ç¨æ°æ®åºä¸ã
ããä¸ç´ä»¥æ¥ï¼Oracle Streams åªç¨äºå¨ Oracle æ°æ®åºé´å¤å¶æ°æ®ãOracle GoldenGate è¿å¯ä»¥å¨é Oracle æ°æ®åºé´å¤å¶æ°æ®ï¼å¹¶ä¸è¿ç§å¤å¶æäºå»ºç«ã
ããæ们åºæ³¨æå°ï¼å·²åå¸ç Oracle â GoldenGate åå±æ¹å声æä¸æåºï¼âç±äº Oracle GoldenGate çæç¥æ§ï¼å°ç»§ç»æ¯æ Oracle Streamsï¼ä½ä¸ä¼å¯¹å
¶è¿è¡ä¸»å¨å¢å¼ºãèæ¯å¯¹ Oracle Streams ä¸æ好çå
容è¡è¯ä¼°ä»¥ç¡®å®æ¯å¦å°å
¶å¹¶å
¥ Oracle GoldenGate ä¸ãâ
ããæ¤æ¼ç¤ºçç®ç
ãã为äºè¿è¡æ¤æ¬¡æ¼ç¤ºï¼æ¨åºå¨ä¸å° Microsoft Windows æå¡å¨ä¸æä¸ä¸ªæ°æ®åºãè¿ä¸ä¸ªæ°æ®åºæ¯ HRPRD1ãHRPRD2 å HRPRD3ãå
¶æ°æ®åºçæ¬åå«ä¸º Oracle Database 11gãOracle Database 10g å Oracle Database 10gã
ããè¿ä¸ä¸ªæ°æ®åºç SYS å SYSTEM å£ä»¤å·²è®¾ç½®ä¸º hrpassword1ï¼ç¨äºæµè¯ç®çãç¨åå¯æ´æ¹æ¤å£ä»¤ã
ããæ¤æ¼ç¤ºçç®çæ¯å¨ HRPRD2 å HRPRD3 è¿ä¸¤ä¸ª Oracle 10g æ°æ®åºç HR.EMPLOYEES 表ä¹é´å»ºç«ååå¤å¶ã对第ä¸ä¸ªæ°æ®åºä¸æ¤è¡¨ç DML æ´æ¹åºä¼ ç»ç¬¬äºä¸ªæ°æ®åºãç¶åï¼æ们å°å¯¹è¿ä¸å¤å¶è¿è¡å¢å¼ºï¼å¯ä»¥å°æ´æ¹åæ¶å¤å¶å° Oracle 11g æ°æ®åº HRPRD1 ä¸ãå
¶ç»ææ¯ï¼å¯¹ HRPRD2 ä¸è¯¥è¡¨çä»»ä½æ´æ°ãæå
¥åå é¤ä¸ä»
å°ä¼æåæ´æ° HRPRD3ï¼ä¹ä¼æåæ´æ° HRPRD1ã
ããè¿ç§ä» Oracle Database 10g å° Oracle Database 10g ç¶ååå° Oracle Database 11g çå¤å¶çç¥å¸¸ç¨äºå级æ
åµï¼è¿è¡å级æ¶ï¼éè¦å
å¤å¶æ°æ®ï¼ç¶åæ¹å¯åæ¢å°å级åçæ°æ®åºçæ¬ãOracle GoldenGate æä¾äºç®åç解å³æ¹æ¡ã
ãã注æï¼é对 Oracle æ°æ®åºæ¶ï¼æ¨ä¸ éè¦ä½¿ç¨ Microsoft ODBC æ°æ®æºç®¡çå¨ä¸ºè¿äºæ°æ®åºå建æ°æ®æºå称 (DSN)ãOracle GoldenGate å¤å¶å°ä½¿ç¨çå¬å¨ç´æ¥è¿æ¥å° Oracle æ°æ®åºã
ããéè¦ä¸è½½çå
容
ããé¦å
ï¼å¯¹äº Windows ç³»ç»ï¼éè¦ä» Microsoft ä¸è½½ä¸å¿ä¸è½½ Microsoft Visual C ++ 2005 SP1 Redistributable Packageï¼ç¶åè¿è¡å®è£
ãå¦æ计ç®æºä¸æªå®è£
Visual C++ï¼è¿ç¨äºå®è£
è¿è¡æ¬åºç¨ç¨åºæ¶æéç Visual C++ åºçè¿è¡æ¶ç»ä»¶ã
ããæ¥ä¸æ¥ï¼éè¦ä» Oracle ææ¯ç½ä¸è½½ Oracle GoldenGate 软件ãæªè³æ¬ææ°åæ¶ï¼OTN åªæ¯æ Windows å¹³å° 64 ä½çæ¬ï¼éç¨äº Windows 2000ãXP å 2003ï¼64 ä½ï¼ä¸ç Oracle 10g ç Oracle GoldenGate 10.4.0.x ç (8 MB)ãè¦ä¸è½½ 32 ä½ Windows çæ¬ï¼æ¨å¿
é¡»ä½¿ç¨ Oracle E-Delivery ç½ç«ãï¼è¯·æ³¨æï¼E-Delivery ä¸è½½æä¸ä¸ªä¸ºæ 30 天çè¯ç¨äº§å许å¯ï¼èé OTN å¼å人å许å¯ãï¼ç»å½æ¤ç½ç«åï¼æç´¢éç¨äº Microsoft Windowsï¼32 ä½ï¼å¹³å°çâOracle Fusion Middleware Product Packâï¼å 为 Oracle GoldenGate 被è§ä½ä¸ä¸ª Oracle èåä¸é´ä»¶äº§åï¼èé Oracle Database 产åï¼ï¼ç¶ååå» Goã
ããæ¤æ¶ä¼åºç°ä»è´¨å
å表ãå¨æ¤å表ä¸ï¼å
éæ© Oracle GoldenGate on Oracle Media Pack for Microsoft Windows (32-bit)ã
ããæ¤ä»è´¨å
ä¸å
å«ï¼
ããéç¨äº Windows 2000ãXP å 2003 ä¸ç Oracle 10g ç Oracle GoldenGate 10.4.0.x çV18162-01
ãã大å°ï¼8.4 MB
ããéç¨äº Windows 2000ãXP å 2003 ä¸ç Oracle 11g ç Oracle GoldenGate 10.4.0.x çV18164-01
ãã大å°ï¼8.4 MB
ããOracle GoldenGate ææ¡£
ããV18423-01
ãã大å°ï¼20 MB
ããä¸è½½è¿ä¸ä¸ª zip æ件ï¼å 为æ¨éè¦éç¨äº Oracle 10g å Oracle 11g ç Oracle GoldenGateã
ããç¶åï¼è¿åå° Oracle èåä¸é´ä»¶çä»è´¨å
å表ï¼ä»ä¸éæ© Management Pack for Oracle GoldenGate (v2.0.0.2) Media Pack for Microsoft Windowsã
ãã该管çå
ä»è´¨å
ä¸å
å«ï¼
ããéç¨äº Windows ç Oracle GoldenGate Director V2.0.0.x ServerV18127-01
ãã大å°ï¼228 MB
ããéç¨äº Windows ç Oracle GoldenGate Director V2.0.0.x ClientV18128-01
ãã大å°ï¼55 MB
ããOracle GoldenGate Director ææ¡£
ããV18129-01
ãã大å°ï¼952 KB
ããå¦ææ¨æ³å®è£
管çå
ï¼ä¸è½½ææè¿äºæ件ã该管çå
æ¯ä¸ä¸ªå®è£
æ¨ Windows æå¡å¨ä¸çç¬ç«äº§åï¼ã该产ååå为 Oracle GoldenGate Directorï¼å®å
å«ä¸ä¸ªå¤å±ç客æ·ç«¯-æå¡å¨åºç¨ç¨åºï¼ä½¿ç»ç»å¯ä»¥è½»æ¾çè§å管çå
¶ Oracle GoldenGate é¨ç½²ã
ããä½¿ç¨ Oracle GoldenGate Director ç GUI çé¢ï¼å¯ä»¥éä¸è®¾è®¡åé
ç½® Oracle GoldenGateï¼è¿å¯ä»¥ç®¡çåçè§ä¸ºäºå¨å
¬å¸åæå¡å¨é´å¤å¶æ°æ®è建ç«çåç§ Oracle GoldenGate è¿ç¨ã
ããä»è´¨å
ç主å表ä¸è¿æå
¶ä»ä¸äºä»è´¨å
ï¼å¦ Oracle GoldenGate Veridata Media Pack for Microsoft Windowsã
ããOracle GoldenGate Veridata 软件ä½ä¸ºæå¡å¨è¿è¡å®è£
ï¼å¨ä¸åå¹³å°ä¸å
·æ代çï¼å®è´è´£å°ä¸ç»æ°æ®ä¸å¦ä¸ç»æ°æ®è¿è¡å¯¹æ¯ä»¥è¯å«ä¸åæ¥çæ°æ®ï¼å¯¹æ¯æ¶æ éåæºãæ¤å¯¹æ¯å¯å
¨å¤©åè¿è¡ï¼å¯ä¸å¤§æµéçå¤å¶åæ¶è¿è¡ãè¿å¯å¨ä¸åå¹³å°é´è¿è¡æ°æ®å¯¹æ¯ã
ããé¤äºä¸è¿°ä¸»è¦ä»è´¨å
å¤ï¼å表ä¸è¿æ¾ç¤ºäºå
¶ä» Oracle GoldenGate å
ãè¿äºè½¯ä»¶å
éç¨äºé Oracle æ°æ®åºï¼å¦ SybaseãSQL ServerãIBM DB2ãTeradataï¼è¿æ JMS åå¹³é¢æ件ï¼è¿åæ äº Oracle GoldenGate æ¯æå¼æçæ§è´¨ã
ããå®è£
æ¥éª¤
ããæ¨ä¸è½½ç Oracle GoldenGate ææ¡£ zip æ件 (V18423-01.zip)ä¸å
å« Oracle GoldenGate Oracle Installation and Setup Guide Version 10.4 (gg_ora_inst_v104.pdf)ï¼å
¶ä¸æè¿°äºéç¨äº LinuxãUNIX å Windows ä¸ç Oracle æ°æ®åºç Oracle GoldenGate çå®è£
æ¥éª¤ã
ãã注æï¼è¿æå
¶ä»ä¸äºå®è£
ææ¡£ï¼å®ä»¬é对éç¨äº SybaseãSQL ServerãDB2ãMySQLãTeradata çç Oracle GoldenGateã
ããé¦å
ï¼å° Oracle GoldenGate for Oracle 10g (V18162-01.zip) 解å缩å°ä¸ä¸ªæ°ç Oracle GoldenGate 软件ç®å½ä¸ï¼ç®å½åä¸ä¸å«ä»»ä½ç©ºæ ¼ãä¾å¦ï¼æ¨å¯ä»¥ä½¿ç¨ C:\OGG10G ä½ä¸º Oracle GoldenGate ç®å½ãæ¤ç®å½ä¸ç软件代ç å°ç¨äºå»ºç«ç¬¬ä¸ä¸ªå第äºä¸ª Oracle 10g æ°æ®åºä¹é´çå¤å¶ã
ããç±äºæ¨ç第ä¸ä¸ªæ°æ®åºæ¯ Oracle Database 11g çï¼æ¨è¿éè¦è§£å缩 Oracle GoldenGate for Oracle 11g (V18164-01.zip)ã对äºæ¤çæ¬ç Oracle GoldenGateï¼æ¨éè¦ä½¿ç¨ä¸ä¸ªåç¬çç®å½ï¼C:\OGG11Gãæ¤ç®å½ä¸ç软件代ç å°ç¨äºæ§å¶å°ç¬¬ä¸ä¸ª Oracle Database 11g æ°æ®åºçå¤å¶ã
ããå¦ææ¨æ Oracle9i æ°æ®åºå¹¶ä¸æ³ä»å
¶å¤å¶æ°æ®æåå
¶å¤å¶æ°æ®ï¼éè¦å¦ä¸ä¸ªéç¨äº Oracle9i ç Oracle GoldenGate 软件ãä¸è¿ï¼æ¨ä¸è½éè¿ Oracle ç½ç«ä¸è½½ Oracle GoldenGate ç Oracle9i çæ¬ãå¦ææ¨éè¦æ¤çæ¬ï¼å¯è½éè¦éè¿ My Oracle Support ååºä¸ä¸ªç³»ç»è¯·æ± (SR)ã
ããå¨å½ä»¤æ示符å¤è¾å
¥ä»¥ä¸å½ä»¤ï¼
ããmkdir C:\OGG10G
ããcd C:\OGG10G
ããunzip c:\V18162-01.zip
ããmkdir C:\OGG11G
ããcd C:\OGG11G
ããunzip C:\V18164-01.zip
ãã# start the 10g databases if not already startednet start OracleServiceHRPRD2
ããnet start OracleServiceHRPRD3
ãã# start the 11g database if not already startednet start OracleServiceHRPRD1
ãã设置ç¯å¢åé
ããç°å¨ï¼æ¨å¯ä»¥æå¼ä¸¤ä¸ªå½ä»¤çªå£ï¼å¼å§..è¿è¡..Cmdï¼ï¼é对 Oracle Database 10g å Oracle Database 11g å°ç¸åºçç¯å¢åéï¼å¦ ORACLE_HOMEãORACLE_SIDãLD_LIBRARY_PATH çï¼è®¾ç½®ä¸ºç¸åºçå¼ã
ãã为äºå¨ä¸¤ä¸ª Oracle 10g æ°æ®åºé´å»ºç«å¤å¶ï¼å°è¿äºåéè¿è¡å¦ä¸è®¾ç½®ï¼
ããset ORACLE_HOME=C:\Oracle\product\10.2.0\db_1set ORACLE_SID=HRPRD2
ããset PATH=%ORACLE_HOME%\bin;%PATH%
ããset LD_LIBRARY_PATH=C:\OGG10G; %ORACLE_HOME%\LIB;%ORACLE_HOME%\jdbc\lib
ããset CLASSPATH=;C:\Program
ããFiles\Java\jre6\lib\ext\QTJava.zip;%ORACLE_HOME%\jdbc\libORACLE_SID å¯è®¾ç½®ä¸º HRPRD2 æ HRPRD3ï¼ä¸¤è
é½æ¯ Oracle 10g æ°æ®åºã请注æ PATHãLD_LIBRARY_PATH å CLASSPATH çå¼ã
ããå¦ä¸ç§æ¹æ³æ¯ç¨ç³»ç»åéè¿è¡è¿äºè®¾ç½®ï¼ä¸ºæ¤æ¨å¯ä»¥å¨ Windows XP Professional ä¸ä½¿ç¨ï¼æççµè..å±æ§..é«çº§..ç¯å¢åé..ç³»ç»åéãå¨è¿éæ·»å æ°çç³»ç»åé并æå¦ä¸æè¿°æ´æ¹è·¯å¾ã
ããå¨æ¤ä¾ä¸ï¼å¨ä¸å°æå¡å¨ä¸è¿è¡ä¸¤ä¸ªæ°æ®åºçæ¬ç缺ç¹æ¯ï¼æ¯æ¬¡å¯å¨ Oracle GoldenGate for Oracle 10g æ Oracle GoldenGate for Oracle 11g ç Manager æå¡æ¶ï¼é½å¿
é¡»æ´æ¹ç³»ç»åéãæ¨å¯è½è¦æ·»å ä¸ Oracle Database 11g æå
³çç³»ç»åéï¼ç¶åå¯å¨ Oracle GoldenGate for Oracle 11g Manager æå¡ãè¿ä¹åï¼æ¨å¯è½è¦æ´æ¹è¿äºç³»ç»åéï¼ä½¿å
¶éåäº Oracle Database 10gï¼ç¶åå¯å¨ Oracle GoldenGate for Oracle 10g Manager æå¡ãç±äºè¿æ¯ä¸ä¸ªæµè¯ç³»ç»ï¼è¿ä¹åå¯è½æ²¡æé®é¢ãä½å¨ç产ç¯å¢ä¸ï¼æ¨éè¦éåä¸ç§æ´èªå¨åçæ¹æ³ï¼å¦éç¨èæ¬åçæ¹æ³ï¼å¨èæ¬ä¸è®¾ç½®è¿äºåé并å¯å¨ Manager æå¡ã
ããGGSCI å½ä»¤è§£éç¨åº
ããå¨å½ä»¤çªå£æâæççµèâ级å«è®¾ç½®ç¯å¢åéä¹åï¼è½¬å° Oracle GoldenGate çæ件夹ä¸ï¼éè¿å½ä»¤è¡ï¼è§å¾ 1ï¼æ Windows èµæºç®¡çå¨è¿è¡ Oracle GoldenGate Command Interpreter for Oracle (GGSCI) ç¨åºã
ããå¾ 1 Oracle GoldenGate Command Interpreterç°å¨ï¼æ¨å¯å¨ GGSCI ä¸æ§è¡ CREATE SUBDIRS å½ä»¤æ¥å建 Oracle GoldenGate çå·¥ä½åç®å½ãåè§å¾ 2ï¼å
¶ä¸ååºäºæå建çéè¦ç®å½ã
ããå¾ 2 å建工ä½åç®å½
ããå° Oracle GoldenGate Manager ä½ä¸ºæ¬å°ç¨åºè¿è¡æ¨å¯ä»¥å° Oracle GoldenGate Manager å½ä½ä¸ä¸ªæ¬å°ç¨åºå¨å½ä»¤çªå£ä¸è¿è¡ï¼ä¹å¯ä»¥å°å®ä½ä¸ºä¸ä¸ª Windows æå¡å®è£
ä»¥ä¾¿å¨ Windows å¯å¨æ¶èªå¨å¯å¨ãæ们建议使ç¨åé¢è¿ç§æ¹æ³ã
ããå¦ææ¨å¸æå°å
¶ä½ä¸ºä¸ä¸ªæ¬å°å½ä»¤è¿è¡ï¼åªéè°ç¨ç®å½ä¸ç Manager æ§è¡æ件ï¼è°ç¨æ¶å¸¦çä¸ä¸ªåæ°æ件ï¼å³å¯ãå½ä»¤è¯æ³ä¸ºï¼
ããC:\OGG10G>mgr
ããUsage: MGR PARAMFILE [REPORTFILE ]
ãã[PID ] [PORT ]
ãã[USESUBDIRS] [NOUSESUBDIRS]
ãã[PAUSEATEND] [NOPAUSEATEND]
ãã[CD ]
ããPARAMFILE æ¯å¿
éçåæ°ãå æ¤ï¼æ¨å¿
é¡»å¨ GGSCI ä¸å建ä¸ä¸ªåæ°æ件ï¼
ããGGSCI (HaviPori) 1> edit params mgr
ããæ¤å½ä»¤å°å¨ C:\OGG10G\dirprm ç®å½ä¸å建ä¸ä¸ªæ°ç mgr.prm æ件ãå¨è¯¥æ件ä¸é®å
¥å°ç¨äºè¿è¡ manager è¿ç¨ç端å£å·ï¼ç¶åä¿å该æ件ã
ããPORT 7809
ããé»è®¤ç«¯å£å·ä¸º 7809ãæ 论æ¨éæ©åªä¸ªç«¯å£å·ï¼è¯·ç¡®ä¿è¯¥ç«¯å£å·æªè¢«ä»»ä½å
¶ä»ç¨åºæ使ç¨å¹¶ä¸æ²¡æä»»ä½é²ç«å¢éå¶ãå 为 PORT æ¯ Manager å¯ä¸éè¦çåæ°ï¼æ以å¿
é¡»æå®è¯¥åæ°ãGGSCI 使ç¨è¯¥ç«¯å£å°è¯·æ±åéç» Manager 以å¯å¨è¿ç¨ï¼å¹¶ä¸ Extract è¿ç¨ä¹ä½¿ç¨è¯¥ç«¯å£è¿è¡åç§æä½ã
ããå建该åæ°æ件ä¹åï¼å°±å¯ä»¥å¨ Windows å½ä»¤æ示符ä¸å¯å¨ Manager äºï¼å¦ä¸æ示ï¼
ããC:\OGG10G>mgr paramfile c:\OGG10G\dirprm\mgr.prm该å½ä»¤å¯å¨ Managerï¼å¹¶ä¸æ¾ç¤ºå¾ 3 æ示çæ¶æ¯ï¼
ããå¾ 3 å¨ Windows å½ä»¤æ示符å¤å¯å¨ Manager
ããå¿
é¡»ä¿ææ¤çªå£ä¸ºæå¼ç¶æï¼ä»¥ä¿æ Manager è¿è¡ãå¦ææ¨æ³¨éï¼è¯¥çªå£å°å
³éï¼Manager å°åæ¢è¿è¡ã
ããå° Manager ä½ä¸º Windows æå¡è¿è¡å®è£
ããä¸ææè¿°äºæå¨å¯å¨ Manager çæ¹æ³ï¼è¿æä¸ç§å¯å¨æ¹æ³ï¼é£å°±æ¯å° Manager ä½ä¸ºèªå¨å¯å¨ç Windows æå¡æ¥å®è£
ã
ããå¨ Windows é群ç¯å¢ä¸å¿
须使ç¨åé¢è¿ç§æ¹æ³ï¼å 为åºç°æ
éæ¶åªææå¡å¯ä»¥èªå¨åæ¢å°å¤ç¨æå¡å¨ä¸ãå¨éé群系ç»ä¸ï¼å° Manager ä½ä¸ºæå¡æ¥å®è£
æ¯å¯éçæ¹æ³ä½ä¹æ¯å¼ºç建议çæ¹æ³ã
ããå¨ Windows ä¸ä½ä¸ºæå¡å建 Manager è¿ç¨æ¶ï¼è¯¥æå¡çé»è®¤å称为 GGSMGRãæ¨å¯ä»¥ä¸ºæ¤æå¡æå®èªå®ä¹çå称ãå¦ææ¨å¨åä¸å°æå¡å¨ä¸éè¦ä¸æ¢ä¸ä¸ª Oracle GoldenGate Manager æå¡ï¼æ¯å¦ä¸ä¸ªé对 Oracle GoldenGate for Oracle 10g çæå¡åå¦ä¸ä¸ªé对 Oracle GoldenGate for Oracle 11g çæå¡ï¼åæå®å称æ¯å¾éè¦çãå¦ææ¨æç®è¿è¡ Oracle GoldenGate Veridataï¼è¿éè¦ä¸ä¸ª Manager æå¡ã
ããç¨ä»¥ä¸æ¹æ³ä¸º Manager æå¡æå®ä¸ä¸ªä¸åçå称ãå¨ GGSCI å½ä»¤æ示符å¤æ§è¡ä»¥ä¸å½ä»¤ï¼
ããEDIT PARAMS ./GLOBALS
ããå¨åºç°çè®°äºæ¬ç¼è¾å¨ä¸ï¼éæ©æ°å»ºä¸ä¸ªæ件ï¼å¦ææ¯é¦æ¬¡è¿ä¹åï¼ï¼ç¶åè¾å
¥ä»¥ä¸ä»£ç 并ä¿å该 GLOBALS æ件ï¼
ããMGRSERVNAME OracleGGSMGR1
ããæ ¹æ® Windows ä¸ç Oracle æå¡ä¸è¬å¸¦æ Oracle åç¼ï¼å¦ OracleDBConsoleãOracleJobScheduler æå¡ï¼çæ¯ä¾ï¼ä½¿ç¨å称 OracleGGSMGR1ã
ããéè¿ C:\OGG10G ç®å½ä¸ç Install ç¨åºå¯è½»æ¾å建 Manager æå¡ãä½¿ç¨ install addservice å½ä»¤ï¼å¦å¾ 4 æ示ï¼
ããå¾ 4 å建 Manager æå¡
ããæ°æå¡å¨ Windows æå¡å表ä¸æ¾ç¤ºä¸ºä¸ä¸ªèªå¨å¯å¨çæå¡ï¼è§å¾ 5ï¼ï¼
ããå¾ 5 Manager æå¡å±æ§
ããManager æå¡ä»¥æ¬å°ç³»ç»å¸æ·è¿è¡ï¼ä¹å¯é
置为以ç¹å®å¸æ·ï¼ä½¿ç¨ç¨æ·ååå£ä»¤é项ï¼è¿è¡ï¼è¯¥ç¨æ·ååå£ä»¤å¯ç± addservice å½ä»¤æå®ãç°å¨å¯éè¿ä»¥ä¸å½ä»¤å¯å¨è¯¥æå¡ï¼
ããGGSCI (HaviPori) 1> start manager
ããStarting Manager as service ('OracleGGSMGR1')...
ããService started.
ããå®è£
Windows äºä»¶æ¶æ¯
ããè¿å¯ä½¿ç¨ Install ç¨åºå°äºä»¶æ¶æ¯å®è£
å° Windows 注å表ä¸ï¼è¿æ ·å®ä»¬å¯éè¿ Windows Event Manager æ¾ç¤ºã使ç¨ä»¥ä¸å½ä»¤å¯å®ææ¤æä½ï¼
ããC:\OGG10G>install addevents
ããOracle GoldenGate messages installed successfully.
ããInstall program terminated normally.
ããè¿å¯å° category.dll å ggsmsg.dll æä»¶ä» C:\OGG10G ç®å½å¤å¶å° C:\WINDOWS\system32 ç®å½ï¼ä»èçæå
·ä½çèä¸æ¯ä¸è¬æ§çé误ã
ãã建ç«å¤å¶ â å¨ HRPRD2 ä¸å»ºç« Extract è¿ç¨Oracle GoldenGate Manager è¿ç¨å·²å¯å¨å¹¶è¿è¡ãä¸ä¸æ¥è¦å»ºç«æ°æ®åºä¹é´çå¤å¶ã
ãã为æ¤ï¼æ¨è³å°éè¦å建åé
ç½®ä¸ä¸ª Extract å Replicat ç»ãå¨è¿äºç»ä¸æå®æ¨æ³æè·åå¤å¶çæ°æ®ã
ããExtract è¿ç¨æè·åççæ°æ®æ´æ¹å¹¶å°è¿äºæ´æ¹åéç»ç®æ æå¡å¨ä¸çä¸ä¸ªâ线索âãå¨ç®æ æå¡å¨ä¸å¯å¨ Replicat è¿ç¨ï¼è¯¥è¿ç¨è´è´£è¿è¡å®é
çå¤å¶ï¼å®ä»çº¿ç´¢ä¸è·åæ°æ®æ´æ¹ï¼ç¶åå°è¿äºæ´æ¹åºç¨å°ç®æ æ°æ®åºä¸ã
ããæ¨è¿éè¦ä¸º Oracle GoldenGate Replication åå¤æ°æ®åºï¼å¨æ°æ®åºçº§æå¼è¿½å æ¥å¿ åè½ã为æ¤ï¼å¨ä»¥ SYSDBA 身份ç»å½å°æ°æ®åºå使ç¨ä»¥ä¸å½ä»¤ï¼
ããSQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;Database altered.
ããSQL> alter system switch logfile;
ããSystem altered
ããç°å¨å¯ä»¥æ·»å Extract ç»äºã
ããGGSCI (HaviPori) 1> ADD EXTRACT emp_ext, TRANLOG, BEGIN NOWEXTRACT added.
ããæ¨å¨è¿éæå®äº TRANLOGï¼è¿æå³çäºå¡ï¼éåï¼æ¥å¿æ为æ°æ®æºãBEGIN åé¢å¯ä»¥æ¯è¯¥æ¥å¿ä¸çä¸ä¸ªæ¶é´æ³ä»¥ä¾¿ä»è¯¥æ¶å»å¼å§è¿è¡å¤çï¼ä¹å¯ä»¥æ¯ NOW 以便ç«å³å¼å§å¤çã
温馨提示:答案为网友推荐,仅供参考