暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

goldengate extract process abending caused by nologging DDL

原创 Anbob 2013-01-30
1149
I use goldengate(for oracle) to do a SCHEMA synchronized,include DDL operrations. when the the EXTRACT process was running to capture the changes ,then if you try do a DDL such as "alter table t_a no logging" on the capture table will cause EXT process ABENDING, I hit these errors today.
ogg version:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized)
# vi ggserr.log
"
2013-01-30 14:25:45 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext1.prm: Problem in resolving [HYSH.NCME_MAP]: Failed to validate table HYSH.
NCME_MAP. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it., try to fix this issue in
order to avoid possible fatal error.
2013-01-30 14:25:45 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext1.prm: Gathering metadata for [HYSH.NCME_MAP] not successful even though ob
ject was resolved, retrying [4] times with 1 second interval.
2013-01-30 14:25:46 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext1.prm: Problem in resolving [HYSH.NCME_MAP]: Failed to validate table HYSH.
NCME_MAP. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it., try to fix this issue in
order to avoid possible fatal error.
2013-01-30 14:25:46 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext1.prm: Gathering metadata for [HYSH.NCME_MAP] not successful even though ob
ject was resolved, retrying [3] times with 1 second interval.
2013-01-30 14:25:47 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext1.prm: Problem in resolving [HYSH.NCME_MAP]: Failed to validate table HYSH.
NCME_MAP. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it., try to fix this issue in
order to avoid possible fatal error.
2013-01-30 14:25:47 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext1.prm: Gathering metadata for [HYSH.NCME_MAP] not successful even though ob
ject was resolved, retrying [2] times with 1 second interval.
2013-01-30 14:25:48 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext1.prm: Problem in resolving [HYSH.NCME_MAP]: Failed to validate table HYSH.
NCME_MAP. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it., try to fix this issue in
order to avoid possible fatal error.
2013-01-30 14:25:48 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext1.prm: Gathering metadata for [HYSH.NCME_MAP] not successful even though ob
ject was resolved, retrying [1] times with 1 second interval.
2013-01-30 14:25:49 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext1.prm: Problem in resolving [HYSH.NCME_MAP]: Failed to validate table HYSH.
NCME_MAP. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it., try to fix this issue in
order to avoid possible fatal error.
2013-01-30 14:25:49 ERROR OGG-00521 Oracle GoldenGate Capture for Oracle, ext1.prm: Object was resolved, however in the same resolution call both DDL hi
story and database metadata resolution failed, cannot recover, SCN [3631144], object id [56605].
2013-01-30 14:25:49 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
....
2013-01-30 15:01:46 WARNING OGG-01961 Oracle GoldenGate Capture for Oracle, ext1.prm: NOLOGGING option is detected on table HYSH.NCME_MAP. Redo for this t
able is not available for capture by Extract.
"

SQL> select force_logging from v$database;
FOR
---
YES
SQL> select objectid,optime,startscn,metadata_text from GGMGR.GGS_DDL_HIST where objectname='NCME_MAP' and fragmentno=1 order
2 by 3
3*
SQL> /
OBJECTID OPTIME STARTSCN METADATA_TEXT
---------- ------------------- ---------- --------------------------------------------------
56605 2013-01-30 14:25:29 3631129 ,G1='ALTER TABLE ncme_map nologging
',
56605 2013-01-30 14:27:38 3631185 ,G1='ALTER TABLE ncme_map logging
',
56605 2013-01-30 14:30:27 3631252 ,G1='ALTER TABLE ncme_map LOGGING
',
56605 2013-01-30 14:30:28 3631271 ,G1='ALTER TABLE ncme_map LOGGING
',

TIP:
MY OGG MANAGER user is GGMGR,capture hysh schema change.
at 2013-01-30 14:25:29,a nologging DDL operation on the tablle.when force logging option was introduced on database level . then Oracle Database ignores any NOLOGGING setting on table level until the database is taken out of force logging mode.
Cause
Prior to v11.2 extract logs a warning message and keeps the extract running which can cause data loss. When user upgrades from v11.1.1.1.x to 11.2, an extract abended with "ERROR OGG-01960 Failed to validate table." From OGG version 11.2 onward, the default behavior is to make the extract abend when it encounters a table/partition created with nologging option.
As a temporary workaround, DBOPTIONS ALLOWNOLOGGING can be added after USERID parameter in the extract parameter file. This parameter will cause the extract to log a warning message and continue to run. However, there is a chance for data loss. Resync in required.
GGSCI () 2> edit params ext1
--Add the following parameter
DBOPTIONS ALLOWNOLOGGING
GGSCI () 1> start ext ext1
GGSCI () 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:08

extend read:

skip a transaction in goldengate(跳过一个事务OGG)

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论