环境介绍:
source端:系统:windows2008_R2_SP1 64位 机器名:GG1 IP地址:192.168.0.201
数据库:sqlserver2008企业版
ogg版本:Oracle GoldenGate Command Interpreter for ODBC
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Windows x64 (optimized), Microsoft SQL Server on Oct 5 2011 00:28:20
target端:系统:windows2008_R2_SP1 64位 机器名:GG2 IP地址:192.168.0.202
数据库:sqlserver2008企业版
ogg版本:Oracle GoldenGate Command Interpreter for ODBC
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Windows x64 (optimized), Microsoft SQL Server on Oct 5 2011 00:28:20
source端
1:配置ODBC数据源(系统DSN)
开始--管理工具--ODBC数据源--选择系统DNS--添加--sqlserver驱动程序--配置数据源名称--服务器--sqlserver验证--选择数据库。
2:对sqlserver数据库进行一次全库备份
具体配置请参照www.baidu.com进行配置。
3:安装ogg并配置ogg
C:\Users\Administrator>cd c:/
c:\>cd gg
c:\gg>ggsci
Oracle GoldenGate Command Interpreter for ODBC
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Windows x64 (optimized), Microsoft SQL Server on Oct 5 2011 00:28:20
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (gg1) 1> create subdirs
Creating subdirectories under current directory c:\gg
Parameter files c:\gg\dirprm: created
Report files c:\gg\dirrpt: created
Checkpoint files c:\gg\dirchk: created
Process status files c:\gg\dirpcs: created
SQL script. files c:\gg\dirsql: created
Database definitions files c:\gg\dirdef: created
Extract data files c:\gg\dirdat: created
Temporary files c:\gg\dirtmp: created
Veridata files c:\gg\dirver: created
Veridata Lock files c:\gg\dirver\lock: created
Veridata Out-Of-Sync files c:\gg\dirver\oos: created
Veridata Out-Of-Sync XML files c:\gg\dirver\oosxml: created
Veridata Parameter files c:\gg\dirver\params: created
Veridata Report files c:\gg\dirver\report: created
Veridata Status files c:\gg\dirver\status: created
Veridata Trace files c:\gg\dirver\trace: created
Stdout files c:\gg\dirout: created
GGSCI (gg1) 2>
要将 Manager 进程添加为 Windows 服务,请在 GoldenGate 安装目录中执行 INSTALL ADDSERVICE 命令。
GGSCI (gg1) 3> exit
c:\gg>INSTALL ADDSERVICE
Service 'GGSMGR' created.
Install program terminated normally.
c:\gg>
配置mgr端口号
c:\gg>ggsci
GGSCI (gg1) 1> EDIT PARAM mgr
--GoldenGate主进程端口号
PORT 7809
--GoldenGate为进程间通讯动态分配的端口段,注意这里如果分配的端口端少于extract-replicat进程对的话,会导致部分进程因通讯失败而出错。
DYNAMICPORTLIST 7810-7850
-- 指定Extract\Replicat进程的自动重启(每次尝试时间间隔为5秒,最多尝试5次)
AUTORESTART ER *, WAITMINUTES 5, RETRIES 5
GGSCI (gg1) 2> START MGR
Starting Manager as service ('GGSMGR')...
Service started.
GGSCI (gg1) 3>
GGSCI (gg1) 3> DBLOGIN SOURCEDB db01 USERID sa, PASSWORD 123
Successfully logged into database.
GGSCI (gg1) 4>
---SOURCEDB 指的是配置系统dns时,配置数据源的名称
GGSCI (gg1) 4> ADD TRANDATA dbo.*
Logging of supplemental log data is enabled for table dbo.emp
Logging of supplemental log data is enabled for table dbo.sun
增加Capture任务(capdb1)
--新增抽取进程capdb1,基于日志方式,立即生效
GGSCI (gg1) 5> ADD EXTRACT capdb1, TRANLOG, BEGIN NOW
EXTRACT added.
本地Trail文件的位置指定
GGSCI (gg1) 6> ADD EXTTRAIL c:\gg\dirdat\lt, EXTRACT capdb1
EXTTRAIL added.
配置参数文件
--这里不同的是我们省略了 SOURCEISTABLE 参数并引入一个新参数:TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT。
--此选项告诉 Extract 进程定期检查和删除 CDC 捕获作业,从而提高性能并减小捕获数据所占用的空间
GGSCI (gg1) 7> EDIT PARAM capdb1
EXTRACT capdb1
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
SOURCEDB db01, USERID sa, PASSWORD 123
EXTTRAIL c:\gg\dirdat\lt
DISCARDFILE c:\gg\dirrpt\capdb1.DSC, PURGE
TABLE dbo.*;
DataPump的配置
Data Pump的配置(GGSCI中执行)
①增加Data Pump(pumpdb12)任务及本地Trail目录
GGSCI (gg1) 8> ADD EXTRACT pumpdb12, EXTTRAILSOURCE c:\gg\dirdat\lt,BEGIN NOW
EXTRACT added.
②指定远程Trail文件保存的目录
GGSCI (gg1) 9> ADD RMTTRAIL c:\gg\dirdat\rt, EXTRACT pumpdb12
RMTTRAIL added.
③配置参数文件
GGSCI (gg1) 10> EDIT PARAM pumpdb12
EXTRACT pumpdb12
SOURCEDB db01, USERID sa, PASSWORD 123
RMTHOST 192.168.0.202, MGRPORT 7809
RMTTRAIL c:\gg\dirdat\rt
DISCARDFILE c:\gg\dirrpt\pumpdb12.DSC, PURGE
TABLE dbo.*;
至此source端配置完成。
target端
1:同样target端也要配置ODBC数据源,但需要注意的是,选择sqlserver驱动程序时候,应该选择SQL Server Native Client。
2:还原source端备份的数据全备
具体配置,百度一下,你就知道了!
3:安装ogg并配置ogg
安装ogg 和source端一样
配置ogg:
要将 Manager 进程添加为 Windows 服务,请在 GoldenGate 安装目录中执行 INSTALL ADDSERVICE 命令。
GGSCI (gg1) 3> exit
c:\gg>INSTALL ADDSERVICE
Service 'GGSMGR' created.
Install program terminated normally.
c:\gg>
配置mgr端口号
c:\gg>ggsci
GGSCI (gg2) 1> EDIT PARAM mgr
--GoldenGate主进程端口号
PORT 7809
--GoldenGate为进程间通讯动态分配的端口段,注意这里如果分配的端口端少于extract-replicat进程对的话,会导致部分进程因通讯失败而出错。
DYNAMICPORTLIST 7810-7850
-- 指定Extract\Replicat进程的自动重启(每次尝试时间间隔为5秒,最多尝试5次)
AUTORESTART ER *, WAITMINUTES 5, RETRIES 5
GGSCI (gg2) 2> START MGR
Starting Manager as service ('GGSMGR')...
Service started.
GGSCI (gg2) 5> EDIT PARAMS ./GLOBALS
CHECKPOINTTABLE dbo.ggschkpt
GGSCI (gg2) 9> exit
c:\gg>ggsci
GGSCI (gg2) 1> DBLOGIN SOURCEDB db02, USERID sa PASSWORD 123
Successfully logged into database.
GGSCI (gg2) 2> ADD CHECKPOINTTABLE
No checkpoint table specified, using GLOBALS specification (dbo.ggschkpt)...
Successfully created checkpoint table DBO.GGSCHKPT.
GGSCI (gg2) 3>
配置Replicat(repdb2)进程
GGSCI (gg2) 3> ADD REPLICAT repdb2, EXTTRAIL c:\gg\dirdat\rt, BEGIN NOW
REPLICAT added.
GGSCI (gg2) 4> EDIT PARAM repdb2
REPLICAT repdb2
ASSUMETARGETDEFS
HANDLECOLLISIONS
TARGETDB db02, USERID sa, PASSWORD 123
DISCARDFILE c:\gg\dirrpt\repdb2.DSC, PURGE
MAP dbo.*, TARGET dbo.*;
至此target端也配置完成。
启动进程服务
source端:
①启动Capture(在源端)
GGSCI (gg1) 11> START capdb1
Sending START request to MANAGER ('GGSMGR') ...
EXTRACT CAPDB1 starting
②启动Data Pump(在源端)
GGSCI (gg1) 12> START pumpdb12
Sending START request to MANAGER ('GGSMGR') ...
EXTRACT PUMPDB12 starting
GGSCI (gg1) 13> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING CAPDB1 00:00:00 00:00:00
EXTRACT RUNNING PUMPDB12 00:00:00 00:00:04
GGSCI (gg1) 14>
注意:启动着两个进程以后,虽然状态是running,但是最好查看一下进程启动的详细信息
GGSCI (gg1) 14> view report capdb1
***********************************************************************
Oracle GoldenGate Capture for ODBC
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Windows x64 (optimized), Microsoft SQL Server on Oct 5 2011 02:06:04
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-07-05 14:56:35
***********************************************************************
Operating System Version:
Microsoft Windows Server 2008 R2 , on x64
Version 6.1 (Build 7601: Service Pack 1)
Process id: 2772
---------------------------------略
如果报错,那么根据错误来更正。
target端
启动Replicat进程
GGSCI (gg2) 5> START repdb2
Sending START request to MANAGER ('GGSMGR') ...
REPLICAT REPDB2 starting
GGSCI (gg2) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPDB2 00:00:00 00:00:08
同样 view report repdb2查看一下启动信息。
至此sqlserver 2008 ogg的DML 配置完成。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28698327/viewspace-767336/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28698327/viewspace-767336/