Expandmenu Shrunk


  • Category Archives 未分类
  • OGG-01489 Could not add TRAN DATA for table, error [ORA-30657

    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的存在一些问题




香港马会开奖记录|香港马会开奖资料|香港马会开奖现场|香港马会走势图|香港马会开奖结果直播|香港马会n730|