联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
源端数据库从11.2.0.4升级到19c版本(目标端本身就是19.1版本ogg),对应的ogg也从11.2升级到了19.1版本,ogg的trail文件传输到目标端之后,replicat进程直接ABENDED
GGSCI (xifenfei) 3> info replicat HISCA01,detail
REPLICAT HISCA01 Last Started 2024-12-06 17:18 Status ABENDED
Checkpoint Lag 00:00:00 (updated 13:35:38 ago)
Log Read Checkpoint File /data/ogg/dirdat/his/re000148
2024-12-06 01:12:04.078756 RBA 51446
查看view report查看报错详细
***********************************************************************
** Run Time Messages **
***********************************************************************
2024-12-06 17:50:55 INFO OGG-02243 Opened trail file /data/ogg/dirdat/his/re000148 at 2024-12-06 17:50:55.559447.
2024-12-06 17:50:55 INFO OGG-02232 Switching to next trail file /data/ogg/dirdat/his/re000000149
at 2024-12-06 17:50:55.559447 due to EOF. with current RBA 51,446.
Source Context :
SourceModule : [er.replicat.processloop]
SourceID : [er/replicat/processloop.cpp]
SourceMethod : [processReplicatLoop]
SourceLine : [1111]
ThreadBacktrace : [12] elements
: [/data/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/data/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/data/ogg/libgglog.so(_MSG_Int32_String(CSourceContext*, int, int, char const*, CMessageFactory::MessageDisposition))]
: [/data/ogg/replicat()]
: [/data/ogg/replicat(ggs::er::ReplicatContext::run())]
: [/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()]
2024-12-06 17:50:55 ERROR OGG-02171 Error reading LCR from data source. Status 524, data source type TrailDataSource.
Source Context :
SourceModule : [er.replicat.ReplicatContext]
SourceID : [er/replicat/ReplicatContext.cpp]
SourceMethod : [onTrailFormatChange]
SourceLine : [564]
ThreadBacktrace : [17] elements
: [/data/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/data/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/data/ogg/libgglog.so(_MSG_String_String_String(CSourceContext*, int, char const*, char const*,
char const*, CMessageFactory::MessageDisposition))]
: [/data/ogg/replicat(ggs::er::ReplicatContext::onTrailFormatChange(char const*, unsigned short, unsigned short) const)]
: [/data/ogg/replicat(ggs::gglib::ggtrail::TrailDataSource::updateTrailCompat(ggs::gglib::ggtrail::TrailFile const&))]
: [/data/ogg/replicat(ggs::er::ReplicatTrailDataSource::updateTrailCompat(ggs::gglib::ggtrail::TrailFile const&))]
: [/data/ogg/replicat(ggs::gglib::ggtrail::TrailDataSource::
readNextTrailRecord(ggs::gglib::gglcr::CommonLCR**, long*, int&, int&, bool, bool))]
: [/data/ogg/replicat(ggs::er::ReplicatTrailDataSource::readLCR(ggs::gglib::gglcr::CommonLCR**, long&, bool&))]
: [/data/ogg/replicat(ggs::er::ReplicatContext::processReplicatLoop())]
: [/data/ogg/replicat(ggs::er::ReplicatContext::run())]
: [/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()]
2024-12-06 17:50:55 ERROR OGG-02771 Input trail file /data/ogg/dirdat/his/re000000149 format RELEASE 19.1
is different from previous trail file form at RELEASE 11.2.
trail文件情况
[oracle@xifenfei his]$ ls -ltr total 2167648 -rw-r----- 1 oracle oinstall 157604039 Nov 14 11:44 re000144 -rw-r----- 1 oracle oinstall 499999979 Nov 21 16:48 re000145 -rw-r----- 1 oracle oinstall 499999866 Dec 2 10:06 re000146 -rw-r----- 1 oracle oinstall 266123675 Dec 6 03:36 re000147 -rw-r----- 1 oracle oinstall 51446 Dec 6 04:15 re000148 -rw-r----- 1 oracle oinstall 1211 Dec 6 04:15 re000000149 -rw-r----- 1 oracle oinstall 43711175 Dec 6 17:50 re000000150
大概的意思就是解析完成了148文件,但是在解析149文件时发现trail的版本从11.2变成了19.1,从而导致进程abend.
解决这个问题,需要人工重新指定解析149文件即可
GGSCI (xifenfei) 5> Alter replicat HISCA01 EXTSEQNO 149, EXTRBA 0
2024-12-06 17:53:01 INFO OGG-06594 Replicat HISCA01 has been altered.
Even the start up position might be updated, duplicate suppression remains active in next startup.
To override duplicate suppression, start HISCA01 with NOFILTERDUPTRANSACTIONS option.
REPLICAT altered.
GGSCI (xifenfei) 6> start HISCA01
Sending START request to MANAGER ...
REPLICAT HISCA01 starting
GGSCI (xifenfei) 8> stats HISCA01
Sending STATS request to REPLICAT HISCA01 ...
Start of Statistics at 2024-12-06 17:53:20.
Replicating from U_XFF_A.T_XFF to U_XFF_B.T_XFF:
*** Total statistics since 2024-12-06 17:53:12 ***
Total inserts 431.00
Total updates 0.00
Total deletes 307.00
Total upserts 0.00
Total discards 0.00
Total operations 738.00
*** Daily statistics since 2024-12-06 17:53:12 ***
Total inserts 431.00
Total updates 0.00
Total deletes 307.00
Total upserts 0.00
Total discards 0.00
Total operations 738.00
*** Hourly statistics since 2024-12-06 17:53:12 ***
Total inserts 431.00
Total updates 0.00
Total deletes 307.00
Total upserts 0.00
Total discards 0.00
Total operations 738.00
*** Latest statistics since 2024-12-06 17:53:12 ***
Total inserts 431.00
Total updates 0.00
Total deletes 307.00
Total upserts 0.00
Total discards 0.00
Total operations 738.00
End of Statistics.