rgb_rgb的博客

源端安装Linux64:[oracle@sgpc146 ggs]$ pwd/s01/ggs[oracle@sgpc146 ggs]$ lltotal 268088-rw-r--r-- 1 root root 274247680 Oct 10 20:19 fbo_ggs_Linux_x64_ora11g_64bit.tar[oracle@sgpc146 ggs]$ tar -xvof f

mssql 2008-->ogg11.1-->oracle11.2问题：2016-05-17 11:01:34 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repma.prm: REPLICAT REPMA starting.2016-05-17 11:01:34 INFO OGG-00996 Or

windows 环境下实现goldengate监控脚本1.windows 环境下建立11.bat文件内容如下：d:\ggs\ggsci paramfile c:\22.txt >d:\expdp\22.log3.windows 环境下建立22.txt，文件内如下：info allinfo * 4.windows 环境下建立计划任务，每分钟执行一次批处理脚本

环境介绍：$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBOLinux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38

源端：Logdump 32 >ghdr onLogdump 33 >detail onLogdump 34 >pos 89094608Reading forward from RBA 89094608 Logdump 35 >n___________________________________________________________________ Hdr-

2016-11-24 13:17:35  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for SQL Server:  GGSCI command (Administrator): edit params .\GLOBALS.2016-11-24 13:17:56  INFO    OGG-03036  Oracle Gol

问题：2017-02-18 20:48:48  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to lock file "/nas/mas/dirdat/mo007767" (error 13, Permission denied).  Lock currently held by process

ERROR: Database operation failed: Couldn't connect to gp. ODBC error: SQLSTATE 81 native database error 0. 523 80Failed to open data source gp for user gpadmin.ggs_Linux_x64_PostgreSQL_64bit.tar

原文：http://www.cnblogs.com/quanweiru/p/4957633.html本文主要介绍OGG中一些过滤或计算函数的用法，以及sqlexec的基本用法SQLPREDICATE在使用OGG初始化时，可以添加此参数到extract中，用于选择符合条件的记录，下面是OGG官方文档中的描述 ：“在用OGG初始化数据时，使用SQLPredicate是比

--DS==============12.2==================GGSCI (adg) 6> info *EXTRACT    EXT_TC    Last Started 2017-08-17 18:06   Status STOPPEDCheckpoint Lag       00:00:56 (updated 00:00:06 ago)Log Read

原文：http://blog.itpub.net/27243841/viewspace-1067942/从Oracle Goldengate 11g版本开始，oracle引入了一种新的capture mode，称为Integrated Capture Mode。传统的capture mode被称为classic capture mode。在classic capture mode中，gol

OGG-COLMAP-列映射COLMAP官方语法定义：COLMAP availabilityThe COLMAP option is available with the following parameters:Syntax TABLE , TARGET ,COLMAP ([USEDEFAULTS, ] = );Or...MAP , TARGET ,CO

GGSCI (P550) 4> help GGSCI Command Summary:  Object:          Command: SUBDIRS          CREATE ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP EXTRACT          ADD, AL

2013-07-13 12:17:24  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extb.2013-07-13 12:17:24  INFO    OGG-00963  Oracle GoldenGate Manager for Or

原文：http://blog.youkuaiyun.com/liqfyiyi/article/details/69778441.数据库thread与sid不对应问题描述：GGS ERROR  500  抽取进程extu1起不来，提示找不到thread2的归档（没有保留哪天具体的报错信息）问题分析：rac数据库曾经删除又重建一个节点，故thread2对

软件下载：https://edelivery.oracle.com/EPD/WelcomePage/get_form?ARU_LANG=ZHSc:\ggs>logdumpOracle GoldenGate Log File Dump UtilityVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100Copyright

源：dblogin userid ggs@SGERP5_146,password ggsadd trandata 000.tcyanginfo trandata 000.tcyangadd extract initmydb, sourceistable -- sourceistabl表示直接从表中读取数据info extract initmydb, task extract init

--加源端进程：--extractADD EXTRACT EXTA, TRANLOG, BEGIN 2012-11-21 00:01:00 ADD EXTTRAIL ./dirdat/ea, EXTRACT EXTA, MEGABYTES 200ADD EXTRACT EXTB, TRANLOG, BEGIN 2012-11-21 00:01:00 ADD EXTTRAIL .

$./logdumpOracle GoldenGate Log File Dump UtilityVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.Logdu

可以利用goldengate恢复oracle误操作的 delete 或者 Insert 操作，主要是由于ogg有reverse功能，有时间再实验。

原文：http://blog.youkuaiyun.com/yangzhawen/article/details/7839555gg for sqlserver 2008 R2 开启后，sqlserver的日志会出现暴涨的情况，解决办法如下：1.先确认是否数据库设置问题导致如：1)查看ggerror中，是否有报错！2)然后确认log备份使用的是log backup同时没有使用压缩.3)

2013-01-29 14:23:17  ERROR   OGG-01028  Formatting error on: table name 000.TBCONTRACTBALANCE, rowid AAAMb2AB+AABp6KAAj, XID 33.22.36594, position (Seqno 878, RBA 1170383260). Invalid numeric data det

原文：http://www.oracle.com/technetwork/cn/articles/datawarehouse/oracle-sqlserver-goldengate-1396114-zhs.html 使用 Oracle GoldenGate 在 Microsoft SQL Server 和 Oracle Database 之间复制事务作者：Nikolay Manchev

ERROR   OGG-01489%s/TB201301_/TB201304_/gERROR   OGG-002222013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa06.prm:  The column(s) used for the @RANGE filt

ERROR   OGG-03517  Oracle GoldenGate Delivery for Oracle, test.prm:  Conversion from character set UTF-16 of source column description to character set zhs16gbk of target column DESCRIPTION failed bec