Today My product environment using OGG(Version 11.2.1.0.1) the EXTRACT PROCESS ABBENDED. In the following example the output of the ggserr.log
I searched in MOS and find the answer
note 1510691.1
Cause
This issue happens when the extract hits the table DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMBP_TEMP_CMP when the source db is Oracle 11gR2. Since these tables are created and dropped dynamically by Oracle, by the time we check the object ID reported in the error messege, the object ID is already gone.
Solution
The idea is to exclude these tables from replication by doing the below:
tableexclude *.DBMS_TABCOMP_TEMP*
For the extract, to show the object names in question instead of object id, the fix will be from OGG v11.2.1.0.5
2013-09-29 10:03:15 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, eicmec.prm: Object with object number 81069 is compressed. Table compression is not supported.
2013-09-29 10:03:15 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eicmec.prm: PROCESS ABENDING.
sys@ICME>select table_name,owner from dba_tables where COMPRESSION='ENABLED' and OWNER=;
-- none
sys@ICME>select name from obj$ where obj#=81069;
no rows selected复制
I searched in MOS and find the answer
note 1510691.1
Cause
This issue happens when the extract hits the table DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMBP_TEMP_CMP when the source db is Oracle 11gR2. Since these tables are created and dropped dynamically by Oracle, by the time we check the object ID reported in the error messege, the object ID is already gone.
Solution
The idea is to exclude these tables from replication by doing the below:
tableexclude *.DBMS_TABCOMP_TEMP*
For the extract, to show the object names in question instead of object id, the fix will be from OGG v11.2.1.0.5
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
【专家有话说第五期】在不同年龄段,DBA应该怎样规划自己的职业发展?
墨天轮编辑部
1487次阅读
2025-03-13 11:40:53
Oracle RAC ASM 磁盘组满了,无法扩容怎么在线处理?
Lucifer三思而后行
902次阅读
2025-03-17 11:33:53
RAC 19C 删除+新增节点
gh
551次阅读
2025-03-14 15:44:18
2月“墨力原创作者计划”获奖名单公布
墨天轮编辑部
506次阅读
2025-03-13 14:38:19
Oracle DataGuard高可用性解决方案详解
孙莹
381次阅读
2025-03-26 23:27:33
墨天轮个人数说知识点合集
JiekeXu
326次阅读
2025-04-01 15:56:03
XTTS跨版本迁移升级方案(11g to 19c RAC for Linux)
zwtian
314次阅读
2025-04-08 09:12:48
Oracle SQL 执行计划分析与优化指南
Digital Observer
278次阅读
2025-04-01 11:08:44
切换Oracle归档路径后,不能正常删除原归档路径上的归档文件
dbaking
271次阅读
2025-03-19 14:41:51
风口浪尖!诚通证券扩容采购Oracle 793万...
Roger的数据库专栏
268次阅读
2025-03-24 09:42:53
热门文章
移除DataGuard Standby配置导致Primary启动失败
2023-08-17 21262浏览
使用dblink产生的”SELECT /*+ FULL(P) +*/ * FROM XXXXX P ” 解析
2023-06-20 20877浏览
Troubleshooting 'ORA-28041: Authentication protocol internal error' change password 12c R2 DB
2020-04-08 13597浏览
浅谈ORACLE免费数据库Oracle Database XE (Express Edition) 版
2018-10-31 7528浏览
High wait event ‘row cache mutex’ in 12cR2、19c
2020-08-14 5537浏览