天天看點

OGG報錯OGG-01496  Failed to open target trail file

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
           

繼續閱讀