GoldenGate疑似BUG:info all查看不到extract现象:
info all查看不到extract ext2,但是info ext2却可以显示状态。
GGSCI (UNID1) 20> ADD EXTRACT ext2, SOURCEISTABLE
ERROR: EXTRACT EXT2 already exists.
GGSCI (UNID1) 21> info all
Program Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
EXTRACT RUNNING EXT_APP 00:00:00 00:00:04
EXTRACT RUNNING PMP_APP 00:00:00 00:00:07
GGSCI (UNID1) 22> info ext2
EXTRACT EXT2 Initialized 2013-11-08 09:08 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE分析:怀疑是GG的BUG导致,版本为11.2.1.0.5,OS为OEL5.4
解决方法:删除EXT2并重建
GGSCI> DELETE EXTRACT EXT2
GSCI> ADD EXTRACT EXT2 <paramaters>
验证:
GGSCI> INFO ALL
GGSCI> SEND EXTRACT EXT2 , REPORT
GGSCI> VIEW REPORT EXT2
相关阅读:RAC环境下管理OGG-HA http://www.linuxidc.com/Linux/2012-07/65796.htmRAC环境下配置OGG同步 http://www.linuxidc.com/Linux/2012-07/65794.htmGoldenGate单向表DML同步 http://www.linuxidc.com/Linux/2013-04/82942.htmOracle GoldenGate 系列:Extract 进程的恢复原理 http://www.linuxidc.com/Linux/2013-04/82563.htmOracle GoldenGate安装配置 http://www.linuxidc.com/Linux/2013-02/79455.htmOracle goldengate的OGG-01004 OGG-1296错误 http://www.linuxidc.com/Linux/2011-08/40951.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12如何处理HANG住的DBRMAN Restore异常终止,报错:Cannot allocate memory相关资讯 GoldenGate
- Oracle Goldengate在HP平台裸设备 (今 11:04)
- GoldenGate for Oracle 数据一致性 (10/10/2015 19:41:17)
- 使用GoldenGate 实现Oracle for (09/16/2015 09:42:31)
| - GoldenGate中使用FILTER,COMPUTE (07月27日)
- GoldenGate 实现Oracle for Oracle (09/20/2015 13:49:00)
- Oracle GoldenGate 学习教程二、配 (08/27/2015 09:19:01)
|
本文评论 查看全部评论 (0)