ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [950], ORA-00950: no er

 

进程日志报错

 

2019-11-13 20:25:49  INFO    OGG-00482  DDL found, operation [---捞取宽带订单总量明细

---捞取宽带订单总量明细

drop tab---捞取宽带订单总量明细

le n_phb_ktsx

 (size 64)].

 

2019-11-13 20:25:49  INFO    OGG-00489  DDL is of mapped scope, after mapping new operation [---捞取宽带订单总量明细

---捞取宽带订单总量明细

drop tab---捞取宽带订单总量明细

le "IOM"."N_PHB_KTSX"

 (size 72)].

 

2019-11-13 20:25:49  INFO    OGG-10451  DDL operation included [INCLUDE MAPPED], optype [DROP], objtype [TABLE], catalog "XORDDB1", objowner "IOM", objname "N_PHB_KTSX

".

 

2019-11-13 20:25:49  INFO    OGG-01407  Setting current schema for DDL operation to IOM.

 

2019-11-13 20:25:49  INFO    OGG-00484  Executing DDL operation.

 

Source Context :

  SourceModule            : [ggapp.ddl]

  SourceID                : [../gglib/ggapp/ddlrep.c]

  SourceMethod            : [DDLREP_handleDDLError]

  SourceLine              : [768]

  ThreadBacktrace         : [15] elements

                          : [/oggbak/ggs19c/libgglog.so(CMessageContext::AddThreadContext())]

                          : [/oggbak/ggs19c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]

                          : [/oggbak/ggs19c/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory::MessageDisposition))]

                          : [/oggbak/ggs19c/replicat(DDLREP_handleDDLError(ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, bool, ggs::ggl

ib::ggunicode::UString const&, ggs::gglib::ggunicode::UString&, int, RepConfig_t*, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, ggs::g

glib::ggunicode::UString const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)8>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)7>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)1

>&, long*))]

                          : [/oggbak/ggs19c/replicat()]

                          : [/oggbak/ggs19c/replicat()]

                          : [/oggbak/ggs19c/replicat()]

                          : [/oggbak/ggs19c/replicat(ggs::er::ReplicatContext::run())]

                          : [/oggbak/ggs19c/replicat()]

                          : [/oggbak/ggs19c/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]

                          : [/oggbak/ggs19c/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]

                          : [/oggbak/ggs19c/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]

                          : [/oggbak/ggs19c/replicat(main)]

                          : [/lib64/libc.so.6(__libc_start_main)]

                          : [/oggbak/ggs19c/replicat()]

 

2019-11-13 20:25:49  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [950], ORA-00950: 无效 DROP 选项

], no error handler present.

 

 

此问题是因为源端，在ddl的时候带有注释，在replicate段添加删除参数即可