【正文】 目錄1. 安裝配置GoldenGate 3. 設置環(huán)境變量 3. 官方資料 3. 7. 8. 9. 10. 安裝GG（只在小機1和分析2上建） 11. 官方系統(tǒng)要求 13. 目標機器manager進程添加到Windows服務 16. GoldenGate相關命令 17. 數據庫準備 19. 源數據庫要開歸檔 19. 打開數據庫級別的補充日志（supplemental log） 19. 在源端和目標端創(chuàng)建GoldenGate管理用戶，并授權 20. 官方技術要求 21. 數據庫字符集檢查 27. 在源端添加表級的transdata 28. 在目標端添加checkpoint表 29. 源端配置MGR管理進程組 30. 配置參數文件 30. 官方技術要求 31. 使用GGSCI命令管理MGR 33. 源端配置Extract抽取進程組 35. 創(chuàng)建和編輯Extract進程配置文件 35. Extract相關命令 36. 源端配置Pump投遞進程組 37. 創(chuàng)建和編輯Pump進程配置文件 37. 使用GGSCI命令管理Pump 38. 目標端創(chuàng)建和配置MGR管理進程組 39. 目標端配置Replicat復制進程組 40. 驗證DML復制結果 41. 增加表進行監(jiān)控的方法 422. 安裝配置Director 43. 安裝配置Director Server 43. 安裝前準備 43. 啟動weblogic server 47. 登入服務端 47. 安裝配置Director Client 48. 安裝客戶端。 48. 登陸信息 48. 配置監(jiān)控的頁面 49. 啟動監(jiān)控 50. 登錄頁面進行監(jiān)控 51. 安裝配置Monitor 5264 / 641. 安裝配置GoldenGate. 設置環(huán)境變量設置ORACLE_HOME和ORACLE_SID. 官方資料To specify Oracle variables on UNIXbased systems●If there is one instance of Oracle on the system, you only need to set ORACLE_HOME andORACLE_SID at the system level. If you cannot set them that way, use the following SETENVstatements in the parameter file of every Extract and Replicat group that will beconnecting to the instance.SETENV (ORACLE_HOME = “path to Oracle home location”)SETENV (ORACLE_SID = “SID”)These parameters override the system settings and allow the Oracle GoldenGateprocess to set the variables at the session level when it connects to the database.●If there are multiple Oracle instances on the system with Extract and Replicatprocesses connecting to them, you will need to use a SETENV statement in the parameterfile of each process group and point it to the correct instance. For example, thefollowing shows parameter files for two Extract groups, each capturing from a differentOracle instance.Group 1:EXTRACT ora9aSETENV (ORACLE_HOME = “/home/oracle/ora9/product”)SETENV (ORACLE_SID = “ora9a”)USERID ggsa, PASSWORD ggsaRMTHOST sysbRMTTRAIL /home/ggs/dirdat/rtTABLE 。TABLE 。Group 2:EXTRACT ora9bSETENV (ORACLE_HOME = “/home/oracle/ora9/product”)SETENV (ORACLE_SID = “ora9b”)USERID ggsb, PASSWORD ggsbRMTHOST sysbRMTTRAIL /home/ggs/dirdat/stTABLE 。TABLE 。To specify Oracle variables on Windows systems●If there is one instance of Oracle on the system, the Registry settings for ORACLE_HOMEand ORACLE_SID should be sufficient for Oracle GoldenGate. If those settings areincorrect in the Registry and cannot be changed, you can set an override as follows.?On the desktop or Start menu (depending on the Windows version), rightclick MyComputer, and then select Properties.?In Properties, click the Advanced tab.?Click Environment Variables.?Under System Variables, click New.?For Variable Name, type ORACLE_HOME.?For Variable Value, type the path to the Oracle binaries.?Click OK.?Click New again.?For Variable Name, type ORACLE_SID.?For Variable Value, type the instance name.?Click OK.●If there are multiple Oracle instances on the system with Extract and Replicatprocesses connecting to them, do the following.?Use the preceding procedure (single Oracle instance on system) to set theORACLE_HOME and ORACLE_SID system variables to the first Oracle instance.?Start all of the Oracle GoldenGate processes that will connect to that instance.?Repeat the procedure for the next Oracle instance, but this time Edit the existingORACLE_HOME and ORACLE_SID variables to specify the new information.?Start the Oracle GoldenGate processes that will connect to that instance.?Repeat the Edit and startup procedure for the rest of the Oracle instances.Setting library paths for dynamic builds on UNIX systemsOracle GoldenGate uses shared libraries. When you install Oracle GoldenGate on a UNIXsystem, the following must be true before you run GGSCI or any other Oracle GoldenGateprocess. Oracle GoldenGate connects to the database locally, all of the following musthave the same bit type, either all 32bit, all 64bit, or all IA64: Oracle GoldenGate connects through SQL*Net, the Oracle client library and theOracle GoldenGate build must match. This means that the Oracle version, the bit type(32bit, 64bit, IA64) and the operating system version all must match. If you are usingthe TRANLOGOPTIONS parameter with the LOGSOURCE option and Oracle GoldenGateconnects to transaction logs from a different operating system, the Oracle versionsmust also be the same. certain that the database libraries are added to the sharedlibrary environmentvariables of the system. This procedure is usually performed at database installationtime. Consult your Database Administrator if you have any questions. you will be running an Oracle GoldenGate program from outside the OracleGoldenGate installation directory on a UNIX system:?(Optional) Add the Oracle GoldenGate installation directory to the PATHenvironment variable.?(Required) Add the Oracle GoldenGate installation directory to the sharedlibraries environment variable.For example, given an Oracle GoldenGate installation directory of /ggs/, the secondmand in the following table requires these variables to be set:To set the variables in Korn shellPATH=installation directory:$PATHexport PATHshared libraries variable=absolute path of installation directory:$shared libraries variableexport shared libraries variableTo set the variables in Bourne shellexport PATH=installation directory:$PATHexport shared libraries variable=absolute path of installation directory:$shared libraries variableTo set the variables in C shellsetenv PATH installation directory:$PATHsetenv shared libraries variable absolute path of installation directory:$shared libraries variable. 創(chuàng)建GG用戶，密碼ggmkdir /home/gguseradd d /home/gg g oinstall G dba ggpasswd gg修改配置文件增加如下配置：export ORACLE_SID=jiesuan1expor