![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle GoldenGate
文章平均质量分 77
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
Oracle GoldenGate DDL Synchronization configuration
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原创 2012-12-21 15:27:18 · 1184 阅读 · 0 评论 -
Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 3
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原创 2014-06-16 15:03:24 · 2659 阅读 · 0 评论 -
Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 1
Source DatabaseDB Name: zwcSchemas: HR,OE,PMVersion: 10.2.0.4RAC: NoOS Version: Red Hat Enterprise Linux Server release 5.9 x86_64OGG原创 2014-06-16 15:01:03 · 1895 阅读 · 0 评论 -
Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 2
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原创 2014-06-16 15:02:11 · 1719 阅读 · 0 评论 -
Oracle GoldenGate 12c 配置Oracle Database 12c Multitenant database
--源端数据库配置[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原创 2014-04-08 16:16:30 · 5250 阅读 · 0 评论 -
Oracle GoldenGate 12c 新特性 Credential Store and USERIDALIAS
--生成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原创 2014-04-08 13:33:18 · 2530 阅读 · 0 评论 -
MOS Oracle GoldenGate documentation
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原创 2013-10-23 21:23:27 · 3259 阅读 · 0 评论 -
Installation Oracle GoldenGate 12c on Oracle Database 12c
[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原创 2013-10-21 16:07:42 · 1588 阅读 · 0 评论 -
Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS
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原创 2013-10-17 00:10:25 · 5949 阅读 · 0 评论 -
Oracle GoldenGate EXTRACT/REPLICAT/MGR parameter Example
SOURCEmgrPORT 7839DYNAMICPORTLIST 7840-7914USERID goldengate, PASSWORD goldengate--AUTOSTART EXTRACT *AUTORESTART EXTRACT *,RETRIES 3,WAITMINUTES 5,RESETMINUTES 10 PURGEOLDEXTRACTS ./di原创 2013-10-15 15:32:51 · 2988 阅读 · 0 评论 -
Oracle GoldenGate for Oracle 11g to PostgreSQL 9.2.4 Configuration
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原创 2013-09-04 22:50:27 · 4746 阅读 · 2 评论 -
Oracle GoldenGate Trail file encryption
GoldenGate加密trail文件非常简单,只需要在extract参数中加上encrypttrail参数。extract进程就会对加入此参数后所生产的trail文件进行加密,如果目标端的replicat参数没有加上对应的decrypttrail参数解密trail文件后再入库,replicat进程就会abend源端extract参数GGSCI (gg01) 5> VIEW p原创 2012-12-21 16:27:24 · 1031 阅读 · 0 评论 -
GoldenGate Column Conversion
源端extract参数,表结构GGSCI (gg01) 82> VIEW params eorajjEXTRACT EORAJJUSERID system, PASSWORD oracleRMTHOST gg02, MGRPORT 7809RMTTRAIL /u01/app/oracle/goldengate/dirdat/jjDDL INCLUDE ALLDDLOPTIONS原创 2012-12-21 15:55:49 · 932 阅读 · 0 评论 -
GoldenGate 配置extract,replicat进程自启动
在GoldenGate中主进程是manager进程,使用start mgr启动。可以在mgr进程中添加一些参数用来在启动mgr进程的同时启动extract和replicat进程GGSCI (gg01) 130> VIEW params mgr--mgr主进程端口号PORT 7809--动态端口,当指定端口不可用时,会从以下列表中选择一个可用端口DYNAMICPORTLIST 7800-原创 2012-12-21 15:00:35 · 4107 阅读 · 1 评论 -
Oracle GoldenGate 数据加密
GoldenGate 数据加密包括 Data encryption缺省无数据加密使用CounterPane的Blowfish对称加密算法,Collector在保存数据到队列之前自动执行解压缩 可以使用密钥对于参数文件中的密码进行加密可以使用缺省密钥加密可以使用自定义密钥加密 ggsci中提供了密码加密的命令 ENCRYPT PASSWORD可以使用缺省密原创 2012-12-21 16:10:56 · 1587 阅读 · 0 评论 -
Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration
源端: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)原创 2012-12-21 14:31:32 · 3272 阅读 · 0 评论 -
GoldenGate configuration CLOB type synchronization
在GoldenGate的DML同步中,如果字段类型包含CLOB,必须在源端的extract参数文件中添加以下参数TRANLOGOPTIONS CONVERTUCS2CLOBSGGSCI (gg01) 19> VIEW params eorajjEXTRACT EORAJJUSERID system, PASSWORD oracleRMTHOST gg02, MGRPORT原创 2012-12-21 16:17:58 · 2110 阅读 · 0 评论 -
Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 4
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原创 2014-06-16 15:04:54 · 2175 阅读 · 0 评论