Oraclegoldengate安装手册
Oracle_GoldenGate软件安装、配置、运维管理_整理版
Oracle_GoldenGate软件安装、配置、运维管理整理版目录Oracle_GoldenGate安装、配置、管理整理版 (1)a) Oracle GoldenGate主要组件 (5)GoldenGate for Oracle (8)b) 把源端数据库的数据同步到目标数据库 (13)c) 源数据库的修改实时同步到目标数据库 (34)d) 把源数据库的DDL修改同步到目标数据库中 (42)e) 术语和缩略语 (61)基于命令行的监控 (63)f) 说明 (63)g) 启动GoldenGate进程 (63)h) 停止GoldenGate进程 (64)i) 查看整体运行情况 (66)j) 查看参数设置 (67)k) 查看进程状态 (67)l) 查看延时 (70)m) 查看统计信息 (70)n) 查看运行报告 (71)基于GoldenGate Director的监控 (73)o) GoldenGate Director概述 (73)p) GoldenGate Director的安装部署 (75)部署方案及必需条件 (75)安装GoldenGate Director Server (77)安装GoldenGate Director Client (82)q) 启动GoldenGate Server (83)r) 配置被监控实例 (83)s) 登录Director Web监控界面 (86)t) 监控整体运行情况 (88)u) 监控进程状态 (89)v) 手工配置重点监控列表 (89)w) 查看事件日志 (92)x) Email告警 (93)y) 运行GGSCI命令 (94)日常维护指南 (96)z) 日常维护注意事项 (96)aa) 配置自动删除队列 (96)bb) 配置启动MGR时自动启动Extract和Replicat进程 (97)cc) 配置MGR自动重新启动Extract和Replicat进程 (97)dd) 长事务管理 (98)a) 源端和目标端数据库增减复制表 (101)b) 修改表结构 (104)c) 表的重新再同步 (105)异常处理预案 (106)d) 网络故障 (106)e) RAC环境下单节点失败 (106)f) Extract进程常见异常 (107)g) Replicat进程常见异常 (108)h) 异常处理一般步骤 (108)参考文献 (110)GoldenGate工作原理a) Oracle GoldenGate主要组件● Extract● Data pump● Replicat● Trails or extract files● Checkpoints● Manager● Collector1、Data Pump是一个次级的Extract Group,如果你的GG环境中不使用Data Pump的话，那么Primary Extract Group必须直接将trail通过网络写到Target系统上.参见后面的示例6:配置Data Pump实现一对多拓扑方案.2、默认情况下,Replicat是实时复制的,如果因为某种需要需要延迟复制的话,那么可以通过Replicat Group的如下DEFERAPPLYINTERVAL参数来控制，该参数允许delay的最大时间是7天。
GoldenGate安装部署及解决方案
GoldenGate安装部署及解决方案目录GoldenGate安装部署及解决方案 (1)1、GoldenGate 简介 (3)2、文档约定和说明 (5)3、GoldenGate软件安装 (6)3.1 GoldenGate软件安装包下载 (6)3.2 Windows下安装 (7)3.3 Linux和Unix下安装 (8)4、GoldenGate同步基本配置 (9)4.1 oracle之间同步和GoldenGate基础 (9)4.2 oracle与db2同步 (17)4.3 oracle与sybase同步 (18)5、GoldenGate同步方案 (19)5.1 使用GoldenGate初始化加载 (19)5.2 一对多数据同步（广播复制） (21)5.3 多对一数据同步（集中复制） (22)5.4 数据转换和过滤 (23)5.5 关于目标端高数据安全性下的GoldenGate配置方案 (27)5.6 GoldenGate双向复制（active-active） (30)6、GoldenGate数据同步性能测试 (33)6.1 测试中主要监测数据和监测方式 (33)6.2 测试脚本和GoldenGate配置 (34)6.3 测试步骤 (38)6.4 性能测试结果 (40)7、GoldenGate推荐配置 (42)7.1 添加必要的环境参数 (42)7.2 BATCHSQL参数 (42)7.3 数据库用户密码加密 (43)7.4 trail再压缩 (44)8、GoldenGate Troubleshooting (45)8.1 一些常用的进程信息和日志的查看方式 (45)8.2 解析trail文件 (45)附：GoldenGate新版本的一个特性 (46)参考文档 (48)1、GoldenGate 简介GoldenGate软件是一种基于日志的结构化数据复制软件，它通过解析源数据库在线日志或归档日志获得数据的增删改变化，再将这些变化应用到目标数据库，实现源数据库与目标数据库实时同步（real-time data synchronize）、双活（active-active high availability）。
goldengate 安装 详细命令
源端与目标端前言之解压缩文件包unzip Oracle_GoldenGate_V11.1.1.1.0_for_Oracle_10g_on_Linux_x86.zipmkdir oggmv fbo_ggs_Linux_x64_ora10g_32bit.tar ogg/tar zxf fbo_ggs_Linux_x64_ora10g_32bit.tar -C /oracle/goldengate0、增加环境变量export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport GGATE=/oracle/goldengate1、开启附加日志alter database add supplemental log data;select supplemental_log_data_min from v$database;2、为goldengate创建用户、表空间并授权create tablespace tbs_gguser datafile '/data0/u02/oradata/ora10g/jtuser1/gguser.dbf' size 1000m autoextend on;create user ogg identified by ufsoft default tablespace tbs_gguser temporary tablespace TEMP quota unlimited on tbs_gguser;grant connect,resource to ogg;grant create session,alter session to ogg;grant select any dictionary,select any table to ogg;grant alter any table to ogg;grant flashback any table to ogg;grant execute on dbms_flashback to ogg;grant insert any table to ogg;grant delete any table to ogg;grant update any table to ogg;++++++++++++++++++++++++++++++++++3、开启强制日志模式(为支持DDL复制)alter database force logging;alter system set recyclebin=off scope=both;[root@vm2 oracle]# chown oracle.oinstall /oracle/goldengate/ -R [oracle@vm2 ~]$ cd /oracle/goldengate/[oracle@vm2 goldengate]$ sqlplus / as sysdbaSQL> @marker_setup………………………………Enter GoldenGate schema name:ogg ………………………………………………………SQL> @ddl_setup………………………………Enter GoldenGate schema name:ogg ………………………………………………………Enter mode of installation:INITIALSETUP …………………………………………………………..Enter yes or no:yes…………………………..SQL> @role_setup………………………………Enter GoldenGate schema name:ogg ………………………………………………………SQL>grant GGS_GGSUSER_ROLE to ogg;SQL> @ddl_enableTrigger altered.4、源端配置goldengate4.1、安装goldengate#Su – oracle$cd /oracle/goldengate>./ggsci> CREATE SUBDIRSGGSCI (vm1) 2> exit至此，goldengate安装完成基于DDL的同步配置源端4.2、配置管理进程与抽取进程./ggsciGGSCI (vm1) 1> dblogin userid ogg,password ufsoftGGSCI (vm1) 2> edit params mgr //编辑管理进程#文件内容如下PORT 7809#保存退出#启动管理进程GGSCI (vm1) 3> start mgrGGSCI (vm1) 4> edit params GLOBALS#文件内容GGSCHEMA ogg#保存退出GGSCI (vm1) 7> add extract eini_1,tranlog,begin now //添加组名为eini_1的抽取进程，即刻为新增日志添加到抽取进程GGSCI (vm1) 11> add rmttrail /oracle/goldengate/dirdat/ma,megabytes 100,extract eini_1 //add rmttrail <trail name> extract <group name即上面创建的eini_1>GGSCI (vm1) 12> edit params eini_1 //编辑抽取进程EXTRACT EINI_1dynamicresolutionSETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg PASSWORD ufsoftRMTHOST 172.16.1.201,MGRPORT 7809 //目标数据库地址和端口TRANLOGOPTIONS EXCLUDEUSER oggRMTTRAIL /oracle/goldengate/dirdat/ma //目标端数据库的trail文件位置DDL INCLUDE ALLtable scott.*; //以scott用户下的表做测试目标端5、配置管理进程与抽取进程./ggsciGGSCI (vm1) 1> dblogin userid ogg,password ufsoftGGSCI (vm1) 2> edit params mgr //编辑管理进程#文件内容如下PORT 7809PURGEOLDEXTRACTS /dirdat,USECHECKPOINTS#保存退出#启动管理进程GGSCI (vm1) 3> start mgrGGSCI (vm1) 4> edit params GLOBALS#文件内容GGSCHEMA ogg#保存退出GGSCI (vm2) 7> add checkpointtable ogg.checkpoint //添加ogg用户下的检查点表GGSCI (vm2) 10> add replicat rini_1,exttrail /oracle/goldengate/dirdat/ma,beginnow,checkpointtable ogg.checkpoint //添加名称为rini_1的应用进程，检查点表名称为ogg.checkpoint,即刻生效GGSCI (vm2) 11> edit params rini_16、测试验证6.1、源端与目标端SQL> conn / as sysdbaSQL> alter user scott account unlock;SQL> conn scott/tigerERROR:ORA-28001: the password has expiredChanging password for scottNew password:Retype new password:Password changedConnected.6.2、源端SQL> conn scott/123456SQL> create table tbs_test(id number primary key,name varchar2(50));Table created.SQL> insert into tbs_test values (1,'lugeng');1 row created.beginfor i in 2000002..2002000 loopinsert into tbs_test values(i,'ge');commit;end loop;end;SQL> commit;Commit complete.6.3、目标端SQL> conn scott/123456Connected.SQL> desc tbs_test;Name Null? Type----------------------------------------- -------- ----------------------------ID NOT NULL NUMBER NAME VARCHAR2(50)SQL> select * from tbs_test;ID NAME---------- --------------------------------------------------1 lugeng基于PUMP的DDL同步配置源端GGSCI (vm1) 1> dblogin userid ogg,password ufsoftGGSCI (vm1) 2> edit params mgr#文件内容port 7809#保存退出GGSCI (vm1) 5> edit params eini_1#文件内容EXTRACT EINI_1dynamicresolutionSETENV (NLS_LANG=AMERICAN_AMERICA.UTF8)USERID ogg PASSWORD ufsoftRMTHOST 172.16.1.201,MGRPORT 7809TRANLOGOPTIONS EXCLUDEUSER oggexttrail /oracle/goldengate/dirdat/laDDL INCLUDE ALLtable scott.*;#保存退出GGSCI (vm1) 8> add extract eini_1,tranlog,begin 2011-11-02 17:03GGSCI (vm1) 9> add exttrail /oracle/goldengate/dirdat/la,extract eini_1GGSCI (vm1) 10> edit params pump_so#文件内容extract pump_sodynamicresolutionUSERID ogg PASSWORD ufsoftrmthost 172.16.1.201,mgrport 7809,compressrmttrail /oracle/goldengate/dirdat/matable scott.*;#保存退出GGSCI (vm1) 11> add extract pump_so,exttrailsource /oracle/goldengate/dirdat/laGGSCI (vm1) 12> add rmttrail /oracle/goldengate/dirdat/ma,extract pump_so目标端GGSCI (vm2) 1> dblogin userid ogg,password ufsoftGGSCI (vm2) 2> edit params mgr#文件内容port 7809PURGEOLDEXTRACTS /dirdat,USECHECKPOINTS#保存退出GGSCI (vm2) 5> edit params GLOBALSGGSCHEMA oggGGSCI (vm2) 6> add checkpointtable ogg.checkpointGGSCI (vm2) 7> add replicat rini_1,exttrail /oracle/goldengate/dirdat/ma,begin now,checkpointtable ogg.checkpointGGSCI (vm2) 9> edit params rini_1#文件内容REPLICAT RINI_1SETENV (NLS_LANG=AMERICAN_AMERICA.UTF8)ASSUMETARGETDEFSUSERID ogg PASSWORD ufsoftDISCARDFILE /oracle/goldengate/dirrpt/RINIaa.dsc,PURGEDDL INCLUDE ALLDDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5DDLERROR DEFAULT DISCARDDDLERROR DEFAULT IGNORE RETRYOPMAP scott.* , TARGET scott.*;#保存退出create table t (id number primary key,name varchar2(50));。
GoldenGate 10g安装配置操作手册
GoldenGate安装配置GoldenGate支持跨平台的数据实时同步操作：即源和目标可以是不同版本的ORACLE数据库。
GoldenGate需要要在源，目标库机器上都安装，并具是与数据库相匹配的版本：即根据源和目标的ORACLE版本，安装对应的goldenGate。
ogg12的版本是可以兼容11g,12c 版本的数据库，但是10g及以下版本需要找对应的版本，但是最多支持到8i。
GoldenGate是通过读取本地的数据库归档日志，投递给远程，实现同步的。
GoldenGate的日志投递方式有两种：直接投递和数据泵的方式。
原理如下图所示：两种抽取方式的结构示图两种抽取方式的区别：上面的INITIAL LOAD投递方式是直接投递，在源抽取端不缓存捕获队列数据。
而下面的DataPump数据泵方式，会在源库目录下保留抽取数据，在网络服务故障时，能保留未投递的数据不丢失，并在服务正常后能补投数据。
而两种投递方式在接收端在配置上没有区别。
要做双机互备，互为主从，配置两组反向的投递队列就好了。
注：我不推荐做双向同步，在系统故障需要恢复的时候，可能导致数据混乱。
一、操作环境环境二、数据库的准备工作下面的操作，都需要在源和目标数据库上操作。
2.1切换到归档模式SQL> archive log list; 查看归档模式Database log mode No Archive ModeAutomatic archival DisabledArchive destination /soft/u01/app/oracle/product/10.2.0/db_1/dbs/arch Oldest online log sequence 5263Current log sequence 5265如果不是归档模式，需要执行SQL> shutdown immediateSQL> startup mountSQL> alter database archivelog; #修改为归档模式SQL> alter database open;2.2禁用recycle_binSQL> show parameter recyclebin ;禁用recycle binoracle11需要重启才能生效SQL> ALTER SYSTEM SET recyclebin = OFF scope=spfile;对于10g不需要SQL> Alter system set recyclebin=off;2.3处理日志验证未使用并行日志（只针对9i,高级版本无此参数）Sql> show parameter LOG_PARALLELISM。
(完整word版)GOLDENGATE MONITOR11.2.1安装手册
1、环境说明2、文件系统设计2.1 文件系统规划2.2 文件系统创建——创建/monitor文件系统:＃ lvcreate -L 100G -n lvmonitor rootvg ＃ mkfs —t ext3 /dev/rootvg/lvmonitor--创建/oradata文件系统：＃ lvcreate -L 100G —n lvoradata rootvg＃ mkfs -t ext3 /dev/rootvg/lvoradata# mkdir /oradata＃ mount /dev/rootvg/lvoradata /oradata—-创建/u01文件系统:＃ lvcreate -L 50G -n lvu01 rootvg# mkfs —t ext3 /dev/rootvg/lvu01# mkdir /u01# mount /dev/rootvg/lvu01 /u012.3 修改/etc/fstabvi /etc/fstab添加如下内容:/dev/rootvg/lvu01 /u01 ext3 defaults 1 2/dev/rootvg/lvoradata /oradata ext3 defaults 1 2/dev/rootvg/lvmonitor /monitor ext3 defaults 1 23、资料库安装3.1 操作系统配置3.1。
1 检查操作系统包rpm -q —-qf ’%{NAME}-%{VERSION}—%｛RELEASE｝ (%｛ARCH}）\n’ binutils \ compat-libstdc++-33 \elfutils-libelf \elfutils-libelf—devel \gcc \gcc—c++ \glibc \glibc-common \glibc-devel \glibc-headers \ksh \libaio \libstdc++ \libstdc++—devel \ make \sysstat \ unixODBC \ unixODBC—devel3.1。
Oracle-11G搭建单实例GoldenGate步骤(汇编)
Oracle 11G 搭建单实例GoldenGate步骤1 GoldenGate安装准备在Oracle官网上下载GoldenGate介质，GoldenGate是包含在Fusion Middleware 类目下面，并上传到源数据库和目标数据库主机；2 GoldenGate安装过程注意：此步骤需要在两台主机上操作2.1 创建GoldenGate操作系统用户这里直接使用Oracle用户安装GoldenGate，而不创建新的用户。
2.2 创建GoldenGate安装路径[root@GMDBA ~]# mkdir -p /u01/ggs/11.2.0[root@GMDBA ~]# mv /u01/software/ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip /u01/ggs/11.2.0/ [root@GMDBA ~]# chown -R oracle:oinstall /u01/ggs/[root@GMDBA ~]# su - oracle2.3 编辑用户环境变量[oracle@GMDBA ogg]$ vi ~/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcFi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_SID=GMDBAexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export PATH=$ORACLE_HOME/bin:/u01/ggs/11.2.0:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/ggs/11.2.0:/libalias sqlplus='rlwrap sqlplus'alias rman='rlwrap rman'2.4 安装GoldenGate文件[oracle@GMDBA ~]$ cd /u01/ggs/11.2.0/[oracle@GMDBA 11.2.0]$ unzip ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zip Archive: ogg112101_fbo_ggs_Linux_x86_ora11g_32bit.zipinflating: fbo_ggs_Linux_x86_ora11g_32bit.tarinflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdfinflating: Oracle GoldenGate 11.2.1.0.1 README.txtinflating: Oracle GoldenGate 11.2.1.0.1 README.doc[oracle@GMDBA 11.2.0]$ tar -xvf fbo_ggs_Linux_x86_ora11g_32bit.tar [oracle@GMDBA 11.2.0]$ cd[oracle@GMDBA ~]$ cd /u01/ggs/11.2.0[oracle@GMDBA 11.2.0]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (GMDBA) 1> create subdirsCreating subdirectories under current directory /u01/ggs/11.2.0Parameter files /u01/ggs/11.2.0/dirprm: already exists Report files /u01/ggs/11.2.0/dirrpt: created Checkpoint files /u01/ggs/11.2.0/dirchk: created Process status files /u01/ggs/11.2.0/dirpcs: createdSQL script files /u01/ggs/11.2.0/dirsql: created Database definitions files /u01/ggs/11.2.0/dirdef: createdExtract data files /u01/ggs/11.2.0/dirdat: created Temporary files /u01/ggs/11.2.0/dirtmp: created Stdout files /u01/ggs/11.2.0/dirout: createdGGSCI (GMDBA) 2>注意：需要进入ogg的安装目录在执行ggsci[oracle@GMDBA ~]$ cd /u01/ogg/11.2.0/[oracle@GMDBA 11.2.0]$ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. GGSCI (GMDBA) 1> helpGGSCI Command Summary:Object: Command:SUBDIRS CREATEER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,LAG, REGISTER, SEND, START, STATS, STATUS, STOPUNREGISTEREXTTRAIL ADD, ALTER, DELETE, INFOGGSEVT VIEWMANAGER INFO, SEND, START, STOP, STATUSMARKER INFOPARAMS EDIT, VIEWREPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,START, STATS, STATUS, STOPREPORT VIEWRMTTRAIL ADD, ALTER, DELETE, INFOTRACETABLE ADD, DELETE, INFOTRANDATA ADD, DELETE, INFOSCHEMATRANDATA ADD, DELETE, INFOCHECKPOINTTABLE ADD, DELETE, CLEANUP, INFOCommands without an object:(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCEMININGDBLOGIN(DDL) DUMPDDL(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,SHOW, VERSIONS, ! (note: you must type the wordCOMMAND after the !to display the ! help topic.)i.e.: GGSCI (sys1)>help !commandFor help on a specific command, type HELP .Example: HELP ADD REPLICATGGSCI (GMDBA) 2>2.5 配置源数据库2.5.1 开启归档[oracle@GMDBA ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sun Dec 15 20:16:57 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 422670336 bytesFixed Size 1345380 bytesVariable Size 327157916 bytesDatabase Buffers 88080384 bytesRedo Buffers 6086656 bytesDatabase mounted.Database opened.SQL> show parameter log_archive_destNAME TYPE VALUE ------------------------------------ ----------- ------------------------------log_archive_dest stringlog_archive_dest_1 stringlog_archive_dest_10 stringlog_archive_dest_11 stringlog_archive_dest_12 stringlog_archive_dest_13 stringlog_archive_dest_14 stringlog_archive_dest_15 stringlog_archive_dest_16 stringlog_archive_dest_17 stringlog_archive_dest_18 stringlog_archive_dest_19 stringlog_archive_dest_2 stringlog_archive_dest_20 stringlog_archive_dest_21 stringlog_archive_dest_22 stringlog_archive_dest_23 stringlog_archive_dest_24 stringlog_archive_dest_25 stringlog_archive_dest_26 stringlog_archive_dest_27 stringlog_archive_dest_28 stringlog_archive_dest_29 stringlog_archive_dest_3 stringlog_archive_dest_30 stringlog_archive_dest_31 stringlog_archive_dest_4 stringlog_archive_dest_5 stringlog_archive_dest_6 stringlog_archive_dest_7 stringlog_archive_dest_8 stringlog_archive_dest_9 stringSQL> show parameter db_recoveryNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string /u01/app/oracle/fast_recovery_areadb_recovery_file_dest_size big integer 4977MSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startup mountORACLE instance started.Total System Global Area 422670336 bytesFixed Size 1345380 bytesVariable Size 327157916 bytesDatabase Buffers 88080384 bytesRedo Buffers 6086656 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.2.5.2 打开补充日志SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;SUPPLEME--------NOSQL> alter database add supplemental log data;Database altered.SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;SUPPLEME--------YES2.5.3 创建GoldenGate管理用户SQL> create user ggs identified by ggs default tablespace users temporary tablespace temp;User created.SQL> grant connect,resource to ggs;Grant succeeded.SQL> grant execute on utl_file to ggs;Grant succeeded.SQL> grant select any dictionary,select any table to ggs;Grant succeeded.SQL> grant alter any table to ggs;Grant succeeded.SQL> grant flashback any table to ggs;Grant succeeded.SQL> grant execute on DBMS_FLASHBACK to ggs; Grant succeeded.SQL>2.5.4 添加表级trandata对hr用户下的所有表进行同步[oracle@GMDBA ggs]$ cd 11.2.0/[oracle@GMDBA 11.2.0]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (GMDBA) 1> dblogin userid ggs password ggsSuccessfully logged into database.GGSCI (GMDBA) 2> add trandata hr.*Logging of supplemental redo data enabled for table HR.COUNTRIES. Logging of supplemental redo data enabled for table HR.DEPARTMENTS. Logging of supplemental redo data enabled for table HR.EMPLOYEES.Logging of supplemental redo data enabled for table HR.JOBS.Logging of supplemental redo data enabled for table HR.JOB_HISTORY. Logging of supplemental redo data enabled for table HR.LOCATIONS. Logging of supplemental redo data enabled for table HR.REGIONS.GGSCI (GMDBA) 3>2.5.5 配置源端mgr管理进程组GGSCI (GMDBA) 1> edit params mgrport 7500dynamicportlist 7501-7505autorestart extract *,waitminutes 2,retries 5GGSCI (GMDBA) 2> view params mgrport 7500dynamicportlist 7501-7505autorestart extract *,waitminutes 2,retries 5GGSCI (GMDBA) 3> start mgrManager started.GGSCI (GMDBA) 4> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING2.5.6 配置Extract抽取进程组GGSCI (GMDBA) 6> edit params ext1extract ext1dynamicresolutionuserid ggs,password ggssetenv(ORACLE_SID=GMDBA)exttrail /u01/ggs/11.2.0/dirdat/ettable hr.*;GGSCI (GMDBA) 7> view params ext1extract ext1dynamicresolutionuserid ggs,password ggssetenv(ORACLE_SID=GMDBA)exttrail /u01/ggs/11.2.0/dirdat/ettable hr.*;创建extract进程GGSCI (GMDBA) 8> add extract ext1,tranlog,begin nowEXTRACT added.GGSCI (GMDBA) 9> add exttrail /u01/ggs/11.2.0/dirdat/et,extract EXT1 EXTTRAIL added.GGSCI (GMDBA) 10> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EXT1 00:00:00 00:00:41 GGSCI (GMDBA) 11> start ext1Sending START request to MANAGER ...EXTRACT EXT1 startingGGSCI (GMDBA) 12> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXT1 00:12:29 00:00:072.5.7 配置pump投递进程组GGSCI (GMDBA) 13> edit params pump1extract pump1dynamicresolutionuserid ggs,password ggsrmthost 192.168.80.30,mgrport 7809,compressrmttrail /u01/ggs/11.2.0/dirdat/pttable hr.*;GGSCI (GMDBA) 14> add extract pump1,exttrailsource /u01/ggs/11.2.0/dirdat/et EXTRACT added.GGSCI (GMDBA) 15>ADD RMTTRAIL /u01/ggs/11.2.0/dirdat/pt, EXTRACT PUMP1 RMTTRAIL added.GGSCI (GMDBA) 16> start pump1Sending START request to MANAGER ...EXTRACT PUMP1 startingGGSCI (GMDBA) 17> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING PUMP1 00:00:00 00:04:072.6 目标端操作2.6.1 目标端用户创建SQL> create user ggs identified by ggs default tablespace users temporary tablespace temp;User created.SQL>grant connect,resource to ggs;Grant succeeded.SQL> grant execute on utl_file to ggs; Grant succeeded.SQL> grant select any table to ggs; Grant succeeded.SQL> grant insert any table to ggs; Grant succeeded.SQL> grant delete any table to ggs; Grant succeeded.SQL> grant update any table to ggs;Grant succeeded.SQL> GRANT ALTER SESSION TO ggs;Grant succeeded.SQL> GRANT SELECT ANY DICTIONARY to ggs;Grant succeeded.2.6.2 添加checkpoint表[oracle@GMDBAGC ogg]$ cd 11.2.0/[oracle@GMDBAGC 11.2.0]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (GMDBAGC) 1> edit params ./GLOBALScheckpointtable ggs.checkpointGGSCI (GMDBAGC) 1> dblogin userid ggs password ggsERROR: Unable to connect to database using user ggs. Please check privileges. ORA-00942: table or view does not exist.GGSCI (GMDBAGC) 2> dblogin userid ggs password ggsSuccessfully logged into database.GGSCI (GMDBAGC) 3> add checkpointtable ggs.checkpointSuccessfully created checkpoint table ggs.checkpoint.GGSCI (GMDBAGC) 4>2.6.3 配置mgrGGSCI (GMDBAGC) 1> edit params mgrport 7809dynamicportlist 7800-8000autostart er *autorestart extract *,waitminutes 2,retries 5lagreporthours 1laginfominutes 3lagcriticalminutes 5purgeoldextracts /u01/ggs/11.2.0/dirdat/rt*,usecheckpoints,minkeepdays 3 GGSCI (GMDBAGC) 2> start mgrManager started.GGSCI (GMDBAGC) 3> info allProgram Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING2.6.4 配置replicatGGSCI (GMDBAGC) 4> edit params replreplicat repluserid ggs,password ggsassumetargetdefsreperror default,discarddiscardfile /u01/ggs/11.2.0/dirrpt/repl.dsc,append,megabytes 50 dynamicresolutionmap hr.*,target hr.*;GGSCI (GMDBAGC) 5> add replicat repl,exttrail /u01/ggs/11.2.0/dirdat/pt REPLICAT added.GGSCI (GMDBAGC) 4> start replSending START request to MANAGER ...REPLICAT REPL startingGGSCI (GMDBAGC) 5> info allProgram Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNINGREPLICAT RUNNING REPL 00:00:00 00:00:01 3 测试源库SQL> create table test (a int,b int);Table created.SQL> insert into test values(1,1);1 row created.SQL> commit;Commit complete.SQL>目标库SQL> create table test (a int,b int);Table created.SQL>SQL> select * from test; no rows selectedSQL> select * from test;A B---------- ----------1 1 SQL>。
GoldenGate Director 安装及配置文档---精品管理资料
GoldenGate Director安装及配置文档目录1.1概述 (2)1。
2G OLDEN G ATE D IRECTOR概述 (2)1。
3G OLDEN G ATE D IRECTOR的安装 (3)1.3.1部署方案必需条件 (3)1。
3。
1.1 ............................................................................................................ Director服务器安装前提31。
3。
1.2 ............................................................................................................ Director客户端安装前提31。
3。
2安装GoldenGate Director Server (4)1.3。
3安装GoldenGate Director Client (7)1.3.4启动GoldenGate Director Server/Client (7)1。
4G OLDEN G ATE D IRECTOR的配置使用 (8)1.4.1Director Admin (8)1。
4.2基于Web的Director客户端 (11)1。
4。
2.1 ...................................................................................................................... 监控整体运行情况121。
4。
2。
2 ........................................................................................................................... 监控进程状态131.4。
oraclegoldengate安装笔记
oraclegoldengate安装笔记ORACLE GoldenGate安装测试平台：REDHAT LINUX 6DB：ORACLE 10G205一、在源数据库操作系统上新增GoldenGate的用户，需要和oracle数据库用户在一个组：二、在源数据库的操作系统上安装GoldenGate软件三、设置源数据库为归档模式，回收站为off（设置DDL复制需要），并设置为最细log四、在源数据库上创建GoldenGate的账号，并赋权限五、在目的主机DB2上新增GoldenGate的用户，需要和oracle 数据库用户在一个组：十一、配置GGS的manager 1234十二、验证结果十三、问题总结：源数据库不配置SUPPLEMENTAL_LOG_DATA_MIN为YES的话，extract会一直起不来，且为stopped状态sys@RHDB> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;SUPPLEME--------NO[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -42012-05-31 13:33:28 ERROR OGG-00730 Oracle GoldenGate Capture for Oracle, ext1.prm: No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece.2012-05-31 13:33:28 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.开启数据库的最细log模式：sys@RHDB> alter database add supplemental log data;Database altered.sys@RHDB> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;SUPPLEME--------YES-------------------------源数据库配置SUPPLEMENTAL_LOG_DATA_MIN为YES，目的数据库不配的话，extract会一直起不来，且为ABENDED状态GGSCI (RHDB-1) 11> start extract ext1Sending START request to MANAGER ...EXTRACT EXT1 startingGGSCI (RHDB-1) 12> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EXT1 00:00:00 02:15:57GGSCI (RHDB-1) 13> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT ABENDED EXT1 02:16:04 00:00:19[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -10target directories:/home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirtmp.2012-05-31 13:41:24 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to begin time May 31, 2012 11:25:26 AM.2012-05-31 13:41:24 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to Sequence 104, RBA 24428048, SCN 0.0, May 31, 2012 11:25:26 AM.2012-05-31 13:41:24 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.2012-05-31 13:41:30 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ext1.prm: Socket buffer size set to 27985 (flush size 27985).2012-05-31 13:41:30 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file/home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt0000 00, at RBA 0 (file not opened).2012-05-31 13:41:30 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt is using format RELEASE 11.2. 2012-05-31 13:41:30 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, ext1.prm: Found unsupported in-memory undo record in sequence 104, at RBA 24428048, with SCN 0.1454118 (1454118) ... Minimum supplemental logging must be enabled to prevent data loss. 2012-05-31 13:41:30 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.配置目的数据库的如下后，依然报错sys@RHDB> alter database add supplemental log data;Database altered.[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -4 ggserr.log2012-05-31 13:57:32 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file /home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt000003, at RBA 1060.2012-05-31 13:57:32 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.2012-05-31 13:57:32 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, ext1.prm: Found unsupported in-memory undo record in sequence 104, at RBA 24428048, with SCN 0.1454118 (1454118) ... Minimum supplemental logging must be enabled to prevent data loss. 2012-05-31 13:57:32 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.重启配置源端的EXTRACT，不再报错：GGSCI (RHDB-1) 30> alter extract ext1, tranlog, begin now EXTRACT altered.GGSCI (RHDB-1) 31> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT STOPPED EXT1 00:00:00 00:00:03GGSCI (RHDB-1) 32> start EXTRACT ext1Sending START request to MANAGER ...EXTRACT EXT1 startingGGSCI (RHDB-1) 33> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EXT1 00:00:00 00:00:19但在源端删除表时，目的端报错，由于目的端没有这个表，所以如下报错：[ogg@RHDB-2 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -0f ggserr.log2012-05-31 14:15:46 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle, rep1.prm: Setting current schema for DDL operation to [SYS].2012-05-31 14:15:47 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rep1.prm: Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist SQL drop table receiver."TESTTAB1" /* GOLDENGATE_DDL_REPLICATION */], no error handler present.2012-05-31 14:15:47 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.查看目的端的gg状态，REPLICAT状态变为了ABENDED:GGSCI (RHDB-2) 22> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT ABENDED REP1 00:00:33 00:02:56执行start命令后依然报错：GGSCI (RHDB-2) 23> START REPLICAT REP1Sending START request to MANAGER ...REPLICAT REP1 startingGGSCI (RHDB-2) 24> INFO ALLProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT ABENDED REP1 00:00:00 00:00:02在目的端创建表testtab1后，成功：receiver@RHDB2> create table testtab1 (id number,teststrvarchar2(12));Table created.receiver@RHDB2> select tname from tab;TNAME------------------------------TESTTAB11 row selected.receiver@RHDB2> select * from testtab1;ID TESTSTR---------- ------------1 adljfoiweur1 row selected.GGSCI (RHDB-2) 6> start replicat rep1Sending START request to MANAGER ...REPLICAT REP1 startingGGSCI (RHDB-2) 7> info allProgram Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNINGREPLICAT RUNNING REP1 00:08:06 00:00:01。
Oracle 11g 安装配置GoldenGate
Oracle 11gR2 RAC和GoldenGate都是Oracle比较热门的产品，经过简单的学习和阅读文档，配置单节点的GoldenGate进行数据的复制相信不是什么太有难度的事情，但是对于利用GoldenGate进行RAC系统到RAC系统的复制，还是有些配置的技巧和策略设置的，前阵子就遇到一个这样一个问题：假设源和目标分别是两节点的RAC系统，如何保证目标部分节点失效的时候replicate会自动切换？其实如果了解GG的工作机制和RAC的资源管理，问题的解决就十分清晰了。
今天就从系统的介绍下11gR2 RAC上OGG (Oracle GoldenGate的简称，下同)的完整配置步骤，并简单谈谈如何解决上面这个场景的问题。
第一阶段：下载OGG（可以参考之前的单节点的复制例子，不再赘述）OGG的下载地址第二阶段：OGG的安装1）登录源端的RAC系统中的任一个节点，并在ACFS上建立一个供OGG使用的共享目录，比如叫/cloudfs/goldengate2）解压OGG的安装包到/cloudfs/goldengate目录3) 设置好OGG工作的环境变量，比如export LIBRARY_PATH=/cloudfs/goldengate:$ORACLE_HOME/lib:$LD_LIBRARY_PATH4）启动ggsci并创建目录，然后进行必要的设置，启动manager$ ggsciGGSCI > create subdirs(optional, support for DDL/Sequence)Create and edit the parameter file for GLOBALS:GGSCI > EDIT PARAMS ./GLOBALSAdd this line to GLOBALS parameter file:GGSCHEMA ggsNOTE: 'ggs' is the example OGG user and will be used in the rest of this document.GGSCI > EDIT PARAMS mgrAdd the following lines to Manager parameter file:PORT 7809AUTOSTART ER *AUTORESTART ER *GGSCI > START mgr5）在目标端重复上面的步骤1-4，注意目录名的使用，我们在目标端使用/mycloudfs/goldengate以示区分。
GoldenGate软件实现一对多数据同步功能安装配置手册
GoldenGate软件实现⼀对多数据同步功能安装配置⼿册GoldenGate⼀对多数据同步安装配置⼿册2001年11⽉⼀、前⾔GoldenGate⽀持灵活的拓扑复制结构，⽐如⼀对多、多对⼀、双向复制等拓扑复制结构。
GoldenGate要实现⼀对多的复制可以通过多种办法来实现，我们这⾥来讨论主要的复制拓扑实现⽅法和机制。
数据从⼀个源端抓取出来，分发到多个⽬标端去。
⼆、安装环境概述三、GoldenGate⼀对多配置实现3.1、Oracle GoldenGate软件环境安装需求源端安装环境需求（1）⽹络：要实现GoldenGate数据复制软件源端和⽬标端的数据通信，需要开通源端和⽬标端服务器的7809到7810，7840到7890之间的⽹络端⼝。
（2）Oracle GoldenGate系统⽤户Oracle GoldenGate安装运⾏需要调⽤Oracle 的数据库产品的类库⽂件，所以建议安装Oracle GoldenGate的系统⽤户在系统的Oracle:dba⽤户组中，或则就使⽤系统Oracle ⽤户进⾏安装。
为PATH环境变量增加安装GoldenGate的路径。
（3）Oracle GoldenGate数据库⽤户goldengate（4）数据库字符集源和⽬标数据库字符集应⼀致，检查Oracle字符集命令：检查nls_lang环境变量⽬的是为了确保GoldenGate进⾏数据抽取的时候使⽤正确的NLS_LANG环境变量，使⽤以下命令确认数据库的字符集。
获得的结果主要在GoldenGate进程的参数⽂件中的setenv（NLS_LANG）参数中使⽤。
（5）安装存储空间安装GoldenGate对于存储空间的要求：应为GoldenGate创建⽂件系统，也可在现有⽂件系统中建⽴⼀个⽬录，GoldenGate对于安装⽬录没有任何限制。
GoldenGate软件本⾝占⽤不到100M空间；（6）数据队列存储空间需要在共享阵列上为GoldenGate软件划分⼀定的存储空间来存储GoldenGate队列。