TABLE resolved (entry GGATE.GGS_MARKER):
  TABLE GGATE.GGS_MARKER;

Using the following key columns for source table GGATE.GGS_MARKER: SEQNO, FRAGMENTNO, OPTIME.

2012-08-23 10:54:02  INFO    OGG-01487  DDL found, operation [create table Q_ALERT_LOG_peppdb1(text varchar2(500))organization external (type oracle_loader default dire
ctory Q_ALERT_LOG_peppdb1_loc access parameters (records delimited by newline nologfile nobadfile nodiscardfile readsize 1048576 fields ldrtrim REJECT ROWS WITH ALL NUL
L FIELDS (text (1:500) char(500))) location(‘alert_peppdb1.log’)) reject limit unlimited  (size 363)], start SCN [29517506653], commit SCN [29517506686] instance [peppd
b1 (1)], DDL seqno [292507], marker seqno [287588].

2012-08-23 10:54:02  INFO    OGG-00487  DDL operation included [include all], optype [CREATE], objtype [TABLE], objowner [FOGLIGHT], objname [Q_ALERT_LOG_PEPPDB1].

2012-08-23 10:54:02  INFO    OGG-00497  Writing DDL operation to extract trail file.

Source Context :
  SourceModule            : [ggdb.ora.ddl]
  SourceID                : [/home/ecloud/workspace/Build_OpenSys_r11.1.1.0.0_078_[34103]/perforce/src/gglib/ggdbora/ddloraext.c]
  SourceFunction          : [RetAbdAddTData(Config_t *, char *, const DBSchemaName_t &, const DBTableName_t &)]
  SourceLine              : [1228]

2012-08-23 10:54:02  ERROR   OGG-01489  Could not add TRAN DATA for table, error [ORA-30657: operation not supported on external organized table, SQL ALTER TABLE “FOGLI
GHT”.”Q_ALERT_LOG_PEPPDB1″ ADD SUPPLEMENTAL LOG GROUP “GGT_Q_ALERT_LOG_PEP_83302” (TEXT) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */], error code [30657], operation [ALTER
 TABLE “FOGLIGHT”.”Q_ALERT_LOG_PEPPDB1″ ADD SUPPLEMENTAL LOG GROUP “GGT_Q_ALERT_LOG_PEP_83302” (TEXT) ALWAYS  /* GOLDENGATE_DDL_REPLICATION */ (size 147)].

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
Report at 2012-08-23 10:54:02 (activity since 2012-08-23 10:54:01)

 

–11g BR put log transaction in Cache
–DDL support
ddl include all
ddloptions addtrandata,report
………….

/*
曾经尝试添加(11.1可能不支持该命令)

DDLERROR DEFAULT IGNORE
无效果

*/

1.
注释掉
–11g BR put log transaction in Cache
–DDL support
ddl include all
–ddloptions addtrandata,report
启动
GGSCI (peppdb1) 20>  info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     EXT1        00:00:03      00:00:00   
EXTRACT     RUNNING     PUMPEXT1    00:00:00      00:00:08   

 
2.还原配置
–11g BR put log transaction in Cache
–DDL support
ddl include all
-ddloptions addtrandata,report

启动正常

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     EXT1        00:00:03      00:00:00   
EXTRACT     RUNNING     PUMPEXT1    00:00:00      00:00:08   

结论:之前一直也告警这个错误但是没有导致ext1 abend
采取这个方式处理的话,可能在某些环节略过了add trandata这一环节(之前add trandata有告警)
也从一些侧面反映了ogg的存在一些问题