2019-05-10 17:06:21 INFO OGG-01014 Positioning with begin time: May 10, 2019 5:06:12 PM, starting record time: May 10, 2019 5:05:10 PM at extseqno 19, e
xtrba 411396271.
2019-05-10 17:06:26 INFO OGG-01226 Socket buffer size set to 100000 (flush size 300000).
Source Context :
SourceModule : [er.recovery]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/recovery.c]
SourceFunction : [RECOVERY_initialize]
SourceLine : [1723]
ThreadBacktrace : [7] elements
: [/u01/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f35e994206e]]
: [/u01/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f35e993e44c]]
: [/u01/ggs/libgglog.so(_MSG_ERR_RECOVERY_OPEN_FAILED(CSourceContext*, char const*, int, CMessageFactory::MessageDisposition)+0x3c)
[0x7f35e991fa28]]
: [/u01/ggs/extract(RECOVERY_initialize()+0x646) [0x525266]]
: [/u01/ggs/extract(main+0x4a5) [0x56ca65]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3b6621ed1d]]
: [/u01/ggs/extract(__gxx_personality_v0+0x38a) [0x4e8b7a]]
2019-05-10 17:06:26 ERROR OGG-01496 Failed to open target trail file ./dirdat/fb000042, at RBA 60367083.
2019-05-10 17:06:26 ERROR OGG-01668 PROCESS ABENDING.
解决办法:
--前滚重新生成一个新的队列文件
alter extract exxxx etrollover
附:
--从指定时间重新抓取(重新抓取数据前提:归档文件没有删除)
alter extract xxxxx, tranlog, begin 2018-12-31 08:00
--重置抽取进程,本地文件序列号从0开始生成。
alter extract exxxx,extseqno 0,extrba 0
--重置读取进程,重新从0号trial文件开始读取。
alter replicat rxxxx,extseqno 0,extrba 0