因为数据问题,对某进程重新初始化。通过数据泵导出导入,之后重建进程。在启动进程的时候,报错1001-ORA-01001: invalid cursor。
ogg版本Version 19.1.0.0.210228,数据库版本Edition Release 19.0.0.0.0。
注册进程模式:add REPLICAT xxxx,PARALLEL INTEGRATED, EXTTRAIL /xxx/xxx,checkpointtable oggadmin.checkpoint
参数内容:
REPLICAT xxx
USERID xxxx@xxxx, PASSWORD xxxx
DDLERROR 1435 IGNORE
DDLERROR 2019 IGNORE
DDLERROR 4063 IGNORE
DDLERROR 6063 IGNORE
DDLERROR 904 IGNORE
DDLERROR 942 IGNORE
DDLERROR 955 IGNORE
DDLERROR 4052 IGNORE
DDLERROR 2149 IGNORE
DDLERROR 1918 IGNORE
DDLERROR 12170 IGNORE
DDLERROR 600 discard
MAP_PARALLELISM 2
MIN_APPLY_PARALLELISM 2
MAX_APPLY_PARALLELISM 8
BATCHSQL
DDLOPTIONS REPORT
REPLACEBADCHAR SKIP
DDL INCLUDE MAPPED
REPORTCOUNT EVERY 1 MINUTES, RATE
DBOPTIONS ENABLE_INSTANTIATION_FILTERING
REPERROR DEFAULT, IGNORE
APPLYNOOPUPDATES
DISCARDFILE ./dircrd/xxx.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER
map xxx.xxxx.*,target xxxx.*;
ogg报错详情:
2021-10-12 10:26:39 INFO OGG-02527 Integrated Replicat does not populate a trace table.
Source Context :
SourceModule : [ggdb.ora.ocicpp.err]
SourceID : [ggdbora/ocicpp/OCIErrorHandler.cpp]
SourceMethod : [dpiErr]
SourceLine : [121]
ThreadBacktrace : [14] elements
: [/data/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/data/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/data/ogg/libgglog.so(_MSG_Int32_String_String(CSourceContext*, int, int, char const*, char const*, CMessageFactory::MessageDisposition))]
: [/data/ogg/replicat(ggs::gglib::ggocicpp::OCIErrorHandler::dpiErr(dpi::Exception&) const)]
: [/data/ogg/replicat(ggs::gglib::ggocicpp::OCIStatement::execStatement(int))]
: [/data/ogg/replicat(ggs::gglib::ggocicpp::ORAConnection::execStmt(ggs::gglib::ggunicode::UString const*))]
: [/data/ogg/replicat(IROCI_create_inbound(ggs::gglib::ggocicpp::ORAConnection&, ggs::gglib::ggunicode::UString const&))]
: [/data/ogg/replicat()]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [/data/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/data/ogg/replicat(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/data/ogg/replicat()]
2021-10-12 10:27:10 ERROR OGG-00664 OCI Error ORA (status = 1001-ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 372
ORA-06512: at "SYS.DBMS_XSTREAM_UTL_IVK", line 2963
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 452
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9306
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1420
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9900
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9269
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 33
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 367
ORA-06512: at "SYS.DBMS_XSTREAM_UTL_IVK", line 2888
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 366
ORA-06512: at line 1