Oracle_GoldenGate安装文档.doc

Oracle GoldenGate For Oracle(windows 平台) 安装配置GoldenGate 的安装非常简单，将解压缩安装文件到指定目录。比如安装文件解压缩后的路径为 d:ggs安装步骤如下:1. 进入命令行2. 切换到ggs目录下3. 输入命令 install addservice addevents4. 输入ggsci进入GoldenGate的命令行5. 输入 create subdirs OK，GoldenGate安装就已经完成了。实际操作如下C:Documents and SettingsPONYd:D:cd ggsD:ggsinstall addservice addeventsOracle GoldenGate messages installed successfully.Service GGSMGR created.Install program terminated normally.D:ggsggsciOracle GoldenGate Command Interpreter for OracleVersion 10.4.0.19 Build 002Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.GGSCI (PONY) 1 create subdirsCreating subdirectories under current directory D:ggsParameter files D:ggsdirprm: createdReport files D:ggsdirrpt: createdCheckpoint files D:ggsdirchk: createdProcess status files D:ggsdirpcs: createdSQL script files D:ggsdirsql: createdDatabase definitions files D:ggsdirdef: createdExtract data files D:ggsdirdat: createdTemporary files D:ggsdirtmp: createdVeridata files D:ggsdirver: createdVeridata Lock files D:ggsdirverlock: createdVeridata Out-Of-Sync files D:ggsdirveroos: createdVeridata Out-Of-Sync XML files D:ggsdirveroosxml: createdVeridata Parameter files D:ggsdirverparams: createdVeridata Report files D:ggsdirverreport: createdVeridata Status files D:ggsdirverstatus: createdVeridata Trace files D:ggsdirvertrace: createdStdout files D:ggsdirout: created1数据库复制实施文档1.1准备工作准备两台机器，分别为SourceDB, TargetDB，通过TCP/IP网络进行互连SourceDB ：WIN XP环境，Oracle 10g 10.2.0.1.0TargetDB ：WIN 2003 环境 Oracle 10g 10.2.0.1.0必须保证SourceDB是运行在归档模式下。目的 ：将SourceDB中相关Schema中的数据同步复制到TargetDB相对应的Sechema中首先要保持SourceD, TargetDB相关Schema中的初始数据一致，可以通过Exp/Imp,Rman,冷备等方式实现.双方DB建立ggate用户，赋予DBA权限，用于GoldenGate连接DB.双方DB安装GoldenGateSourceDB必须开始最小附加日志模式源数据库配置GoldenGate主要通过抓取源端数据库重做日志进行分析，将获取的数据应用到目标端，实现数据同步。因此，为了让GoldenGate能够正常工作，源数据库需要进行一定配置。1.设置源库为归档模式SQL shutdown immediateSQL startup mountSQL alter database archivelog;SQL alter database open;2 开启minimal supplemental loggingSQL alter database add supplemental log data;SQL select SUPPLEMENTAL_LOG_DATA_MIN from v$database;SUPPLEMEYES3 关闭数据库的recyblebinSQL alter system set recyclebin=off scope=spfile;如果数据库是10g，需要关闭recyclebin并重启；或者手工purge recyclebin。1.2配置GoldenGate1.2.1配置SourceDB的GoldenGate 配置复制的DDL支持在命令行，切换到GGS目录运行SQLPLUSSQL create user ggate identified by ggate default tablespace users temporary tablespace temp;SQL grant connect,resource,unlimited tablespace to ggate;SQL grant execute on utl_file to ggate;SQL marker_setup.sql; enter GoldenGate schema(ggate)SQL ddl_setup.sql;enter schema:ggatechoose installation mode: INITIALSETUPSQL role_setup.sql;SQL grant GGS_GGSUSER_ROLE to ggate;SQL ddl_enable.sql;两端都安装完成.2.5 创建源端和目标端的测试用户sourceSQL create user sender identified by oracle default tablespace users temporary tablespace temp;SQL grant connect,resource,unlimited tablespace to sender;destinationSQL create user receiver identified by oracle default tablespace users temporary tablespace temp;SQL grant connect,resource,unlimited tablespace to receiver;3. 配置manager在源端和目标端分别执行下面的步骤。3.1 创建managerd:ggsggsciGGSCI (gridcontrol) 1 info allProgram Status Group Lag Time Since ChkptMANAGER STOPPEDGGSCI (gridcontrol) 2 edit params mgrPORT 7809ggate (gridcontrol) 3 start managerManager started.4. 配置源端复制队列Goldengate和oracle复制源端可以安装在不同机器上，但需安装oracle客户端，并配置好源和目标的tnsnames文件。本文选择源TNS为 标识source，目标为target。GGSCI (gridcontrol) 1 add extract ext1, tranlog, begin nowEXTRACT added.GGSCI (gridcontrol) 2 add exttrail d:ggsdirdatlt, extract ext1EXTTRAIL added.GGSCI (gridcontrol) 3 edit params ext1extract ext1userid ggatesource, password oraclermthost 192.168.103.170,mgrport 7809rmttrail d:ggsdirdatltddl include mapped objname sender.*;table sender.*;GGSCI (gridcontrol) 6 info allProgram Status Group Lag Time Since ChkptMANAGER STOPPEDEXTRACT STOPPED EXT1 00:00:00 00:10:555. 配置目标端同步队列5.1 在目标端添加checkpoint表D:ggsggsciGGSCI (centos4) 1 edit parms GLOBAL 添加下列内容GGSCHEMA ggateCHECKPOINTTABLE ggate.checkpoint GGSCI (centos4) 2 dblogin userid ggatetargetPassword:Successfully logged into database. GGSCI (centos4) 3 add checkpointtable ggate.checkpoint Successfully created checkpoint table GGATE.CHECKPOINT.5.2 创建同步队列 GGSCI (centos4) 4 add replicat rep1, exttrail d:ggsdirdatlt, checkpointtable ggate.checkpoint REPLICAT added.GGSCI (centos4) 5 edit params rep1replicat rep1ASSUMETARGETDEFSuserid ggatetarget, password ggatediscardfile d:ggsdirdatrep1_discard.txt, append, megabytes 10gettruncatesDDLmap sender.*, target receiver.*;6. 开启同步源GGSCI (gridcontrol) 14 start extract ext1GGSCI (gridcontrol) 15 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNINGEXTRACT RUNNING EXT1 00:00:00 00:00:05GGSCI (centos4) 7 start replicat rep1GGSCI (centos4) 8 info all Program Status Group Lag Time Since Chkpt MANAGER RUNNINGREPLICAT RUNNING REP1 00:00:00 00:00:007. 验证结果源端：SQL create table sender.test_tab_1 (id number,rnd_str varchar2(12);SQL insert into sender.test_tab_1 values (1,test_1);SQL commit;目标端：SQL select * from receiver.test_tab_1; ID RND_STR- 1 test_1如发现某个进程有故障,可以在ggsci 中使用 view report 进程名 查看详细信息G