【文章內(nèi)容簡介】 s requires an operating system user that has read access to thetransaction log files, both online and archived. On UNIX systems, that user must be a member of the group that owns the Oracle instance. If you install the Manager process as a Windows service during the installation steps in this documentation, you must install as Administrator for the correct permissions to be assigned. If you cannot install Manager as a service, assign read access to Extract manually, and then run Manager and Extract as Administrator whenever you start them.●Dedicate these operating system users to Oracle GoldenGate. Sensitive informationmight be available to anyone who runs an Oracle GoldenGate process, depending onhow database authentication is configured.●Before installing Oracle GoldenGate on a Windows system, install and configure the Microsoft Visual C ++ 2005 SP1 Redistributable Package. Make certain it is the SP1 version of this package, and make certain to get the correct bit version for your server. This package installs runtime ponents of Visual C++ Libraries. For more information, and to download this package, go to .. 目標機器manager進程添加到Windows服務1) 在目標機子上配置，進入ggsci命令界面2) 輸入“EDIT PARAMS ./GLOBALS”命令，注意：./GLOBALS最好使用大寫3) 輸入“MGRSERVNAME GGSMGR” ，系統(tǒng)默認的名字是“GGSMGR”4) 輸入“exit”命令5) 輸入“install addservice”命令. GoldenGate相關命令. 數(shù)據(jù)庫準備. 源數(shù)據(jù)庫要開歸檔已經(jīng)開啟. 打開數(shù)據(jù)庫級別的補充日志（supplemental log） SQL select supplemental_log_data_min from v$database。 SUPPLEMENTAL_LOG_DATA_MINNO SQL alter database add supplemental log data。 Database altered SQL select supplemental_log_data_min from v$database。 SUPPLEMENTAL_LOG_DATA_MINYES SQL . 在源端和目標端創(chuàng)建GoldenGate管理用戶，并授權源端create user ggs identified by ggs default tablespace GGS temporary tablespace TEMPB。grant dba to ggs。目標端：create user ggs identified by ggs default tablespace ggs temporary tablespace TEMPa。grant dba to ggs。. 官方技術要求Disabling triggers and cascade delete constraintsYou have the following options to handle triggers and integrity constraints on the target:●For Oracle and later patches, and for Oracle and later, you can use theReplicat parameter DBOPTIONS with the SUPPRESSTRIGGERS option to cause Replicat todisable the triggers during its session.主要參加官方安裝文檔第43頁左右. 數(shù)據(jù)庫字符集檢查SETENV (NLS_LANG = SIMPLIFIED )小機分析數(shù)據(jù)庫. 在源端添加表級的transdata例如：添加“scott”對像中的表回頭在這里試試添加新的表。add trandata add trandata . 查詢數(shù)據(jù)庫對哪些表添加了附加日志SELECT owner,table_name,log_group_name FROM dba_log_groupsWHERE owner=39。DZZWUSER39。 。. 在目標端添加checkpoint表在目標機器上的GLOBALS文件中加入，添加一行，“checkpointtable ”. 源端配置MGR管理進程組在源端和目標端都必須要有的，他負責啟動GoldenGate進程，已經(jīng)相關的動態(tài)進程、trail文件的管理、以及錯誤信息報告等等。. 配置參數(shù)文件進入ggsci ， edit params mgr，在彈出的文件里添加需要的參數(shù)內(nèi)容。*********************************************************************************** port 7809 dynamicportlist 78407880 purgeoldextracts /bak/gg/dirdat/et* , USECHECKPOINTS , MINKEEPDAYS 3 autostart extract * autorestart extract *,waitminutes 2, retries 360,resetminutes 60***********************************************************************************管理端口7809動態(tài)通信端口78407880動態(tài)通信端口分配前延時3600秒，重新制定一次自動清除已經(jīng)使用過的tail文件Mgr啟動后，自動啟動extract進程組Mgr啟動后，自動重啟extract進程組GoldenGate一個Port用于Manager Process之間通信（Source和Target），本地進程間通信使用的端口范圍：缺省范圍從7809開始，或者可以定義一個從7809+256的端口。Port 表示MGR進程通信的端口號，必須存在。dynamicportlist 表示manager進程可以為源端和目標端的動態(tài)通信動態(tài)的指定端口。autorestart extract 表示自動重啟extract進程組，每次嘗試的時間間隔為2分鐘，最大嘗試360次，如果沒有成功則放棄30分鐘清零。. 官方技術要求Configuring ManagerTo configure Manager, create a parameter file by following these steps. If you installedOracle GoldenGate on a UNIX cluster, configure the Oracle GoldenGate Manager processwithin the cluster application as directed by the vendor’s documentation, so that OracleGoldenGate will fail over properly with the other applications.To configure Manager the Oracle GoldenGate directory, run the ggsci program to open the OracleGoldenGate Software Command Interface, monly known as GGSCI. GGSCI, issue the following mand to edit the Manager parameter file.EDIT PARAMS MGR the following parameter to specify the Manager port number.PORT port_numberPORT defines the port number on which Manager runs on the local system. The default portis 7809. You must specify either the default port or another port. The port must beunreserved and unrestricted. GGSCI uses this port to request Manager to start processes.The Extract process uses this port to request Manager to start a remote Collector processor an initialload Replicat process. PORT is the only required Manager parameter.NOTEThe port number also must be specified with the MGRPORT argument of the Extractparameter RMTHOST.Database user parameterIf using Oracle GoldenGate DDL support, specify the Manager user and password with the USERID parameter.Dynamic port parametersUse the DYNAMICPORTLIST parameter to specify up to 256 unreserved, unrestricted ports fordynamic TCP/IP munications between the source and target systems. The Collector,Replicat, and GGSCI processes will use these ports.DYNAMICPORTLIST {port | portport} [, ...]In the absence of DYNAMICPORTLIST, Manager tries to start Collector on port 7840. If 7840 isnot available, Manager increments by one until it finds an available port.Use the DYNAMICPORTREASSIGNDELAY parameter to control how long Manager waits to assigna port that was assigned before.DYNAMICPORTREASSIGNDELAY secondsAutostart parametersUse the AUTOSTART parameter to start Extract and Replicat processes when Manager starts.This can be useful, for example, if you want Oracle GoldenGate activities to beginimmediately when you start the system, assuming Manager is part of the startup ro