OGG-00446 goldengate 抽取程式找不到相應的歸檔日誌的解

2018-09-29 09:33:38  ERROR   OGG-00446  Could not find archived log for sequence 349 thread 1 under default destinations SQL <SELECT  name    FROM v$archived_log   WHERE sequence# = :ora_se

q_no AND         thread# = :ora_thread AND         resetlogs_id = :ora_resetlog_id AND         archived = 'YES' AND         deleted = 'NO' AND         name not like '+%'         AND standby

_dest = 'NO' >, error retrieving redo file name for sequence 349, archived = 1, use_alternate = 0Not able to establish initial position for sequence 349, rba 6989328

OGG找不到歸檔日誌

解決方案

1：

恢復歸檔日誌，恢復正常之後，則能正常的啟動EX程式。如果恢復不了的話，則需下面的解決方案

2:  alter extract LCAM001,tranlog ,begin 2019-09-29 00:20:15

則能啟動，或者直接

alter extract lcam001 begin now

再手工將差異進行補齊。