Zhong Weicheng Study Notes

DML同步参考Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration关闭源端数据库的recyclebin,如果你是Oracle11g,可以不用关闭[oracle@gg01 ~]$ sqlplus / AS sysdbaSQL*Plus: Release 1

DDL Setup StepsSQL> grant execute on utl_file to ggs;Grant succeeded. Create GLOBALS file[oracle@zwc ~]$ cd /ggs/[oracle@zwc ggs]$ cat GLOBALS GGSCHEMA GGS run marker_s

Source DatabaseDB Name:        zwcSchemas:         HR,OE,PMVersion:          10.2.0.4RAC:                NoOS Version:     Red Hat Enterprise Linux Server release 5.9 x86_64OGG

Prepare 10g Database for OGGCreate GGS and GGS_MON Database UsersSQL> create tablespace ggs_tbs datafile '/u01/app/oracle/oradata/zwc/gg_tbs01.dbf' size 100M;Tablespace created.SQL> cr

--源端数据库配置[oracle@db12c ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.1.0 Production on Tue Apr 8 14:24:15 2014Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected t

--生成credentialstore文件[oracle@db12c ggs]$ ggsci Oracle GoldenGate Command Interpreter for OracleVersion 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBOLinux, x64, 64bit (op

NLS_LANGNote 969551.1 How is NLS_LANG Set When You Run OGG On The Superset Character Sets DatabaseNote 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.Supplement

[oracle@vmdb12c gghome]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBOLinux, x64, 64bit (optimized), Oracle 12c on

sourceOracle 11gR2 RAC#public IP192.168.1.51     vzwc1192.168.1.52     vzwc2#private IP172.168.1.51     vzwc1-priv172.168.1.52     vzwc2-priv#VIP192.168.1.151    vzwc1-vip192.168.1

SOURCEmgrPORT 7839DYNAMICPORTLIST 7840-7914USERID goldengate, PASSWORD goldengate--AUTOSTART EXTRACT *AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 10 PURGEOLDEXTRACTS ./di

Installing and setting up Oracle GoldenGate connecting to an Oracle databaseAlso please make sure the Oracle database is in archive log mode[oracle@ggos ~]$ sqlplus / as sysdbaSQL*Plus: Releas

GoldenGate加密trail文件非常简单,只需要在extract参数中加上encrypttrail参数。extract进程就会对加入此参数后所生产的trail文件进行加密,如果目标端的replicat参数没有加上对应的decrypttrail参数解密trail文件后再入库,replicat进程就会abend源端extract参数GGSCI (gg01) 5> VIEW p

源端extract参数,表结构GGSCI (gg01) 82> VIEW params eorajjEXTRACT EORAJJUSERID system, PASSWORD oracleRMTHOST gg02, MGRPORT 7809RMTTRAIL /u01/app/oracle/goldengate/dirdat/jjDDL INCLUDE ALLDDLOPTIONS

在GoldenGate中主进程是manager进程,使用start mgr启动。可以在mgr进程中添加一些参数用来在启动mgr进程的同时启动extract和replicat进程GGSCI (gg01) 130> VIEW params mgr--mgr主进程端口号PORT 7809--动态端口,当指定端口不可用时,会从以下列表中选择一个可用端口DYNAMICPORTLIST 7800-

GoldenGate 数据加密包括 Data encryption缺省无数据加密使用CounterPane的Blowfish对称加密算法,Collector在保存数据到队列之前自动执行解压缩 可以使用密钥对于参数文件中的密码进行加密可以使用缺省密钥加密可以使用自定义密钥加密 ggsci中提供了密码加密的命令 ENCRYPT PASSWORD可以使用缺省密

源端:OS: Oracle Solaris 10 x86-64DB: Oracle Database 11gR2(11.2.0.1)IP: 192.168.106.164同步表名: GGUSER.T_RSYNC目标端:OS: CentOS 4.8DB: Oracle Database 10gR2(10.2.0.5)

在GoldenGate的DML同步中,如果字段类型包含CLOB,必须在源端的extract参数文件中添加以下参数TRANLOGOPTIONS CONVERTUCS2CLOBSGGSCI (gg01) 19> VIEW params eorajjEXTRACT EORAJJUSERID system, PASSWORD oracleRMTHOST gg02, MGRPORT

Target Side SetupInstall OGG on Target SideCreates required directories for OGG[oracle@vzwc1 ggs]$ ./ggsci Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.23 1870940