Oracle GoldenGate
Sharqueen
Dave said The import thing in life is to have a great aim and the determination to attain it .I say yes.
展开
-
【OGG】extract不抓取日志--running状态--不能stop和kill--自动abended
2014-01-08 goldengate 奇葩的事Iogg进程一致运行好好的,昨天晚上10点半左右extract进程开始不工作了,短信报警一直提醒。早上来到公司,查看了下,没有任何报错,进程也一直在运行,但是就是不抓取日志,Time Since Chkpt一直在累积增长。GGSCI(dbrac) 26> info all Program Status Gro原创 2014-01-08 14:46:53 · 4160 阅读 · 0 评论 -
OGG 添加extract失败 OGG-01756
--添加extract进程出错GGSCI > add extract extcus44,tranlog,beginnow2014-04-01 13:10:01 WARNING OGG-01756Cannot register EXTRACT EXT1 with database because of the following SQL error: OCIError ORA-06550:原创 2014-04-01 13:28:11 · 3900 阅读 · 0 评论 -
OGG-01008 Extract displays Discarding bad record (discard recs=1) when using filter or where clause
Applies to:Oracle GoldenGate - Version 10.0.0.1 and laterInformation in this document applies to any platform.Symptoms 1. I am using filter or where clause in extract parameter file an原创 2014-05-05 15:14:38 · 1090 阅读 · 0 评论 -
【OGG】常用参数、函数
常用extract 参数文件GGSCI (EPCDB1) 2> view param extgh extractextghuseridggs, password ggsTRANLOGOPTIONS CONVERTUCS2CLOBS --本地字符集为UTF,同步数据类型有CLOB,需要加此参数(OGG11版本以后就不用了)warnlon原创 2014-05-08 13:36:54 · 13031 阅读 · 0 评论 -
【OGG-01414】extract abend CACHEMGR: tran id: 0 length memtran
GoldenGate Extract abends:OGG-01414 CACHEMGR: tran id: 0 length memtran: 0x0000000103cba020. (文档 ID1555670.1)rac一节点配置了OGG,在启动extract进程不久后报错:OGG-01414CACHEMGR: tran id: 0 length memtran: 0x0000000103原创 2014-05-12 16:10:30 · 2342 阅读 · 0 评论 -
【OGG-01161】源端表结构发生变化导致replicat进程abend
错误日志如下:2014-05-21 09:31:34 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, r54gh1.prm: Bad column index (35) specified for tableGH.APP_INFO, max columns = 35.2014-05-21 09:31:34 ERRO原创 2014-05-21 10:08:01 · 9844 阅读 · 0 评论 -
【OGG】extract 异常恢复 BR – BOUNDED RECOVERY
BR – BOUNDED RECOVERY适用于 Extract 进程(仅适用于 Oracle数据库)使用 BR 参数可以控制 GoldenGate 的 Bounded Recovery (BR) 功能。Bounded Recovery 功能仅支持 Oracle 数据库。Bounded Recovery 是通用 Extract 检查点工具的组件之一,可以保证当Extract 进程出于任原创 2014-05-28 16:59:53 · 2856 阅读 · 0 评论