今天啟動一個extract時，出現以下錯誤：

2011-10-16 22:41:02? ERROR?? OGG-00446? Oracle GoldenGate Capture for Oracle, e430rks2.prm:? Could? not ? find ? archived ? log ?for sequence 10770 thread 1 under default destinations? SQL ?<SELECT? name??? FROM v$archived_log?? WHERE sequence# = :ora_seq_no AND???????? thread# = :ora_thread AND???????? resetlogs_id = :ora_resetlog_id AND???????? archived = 'YES' AND???????? deleted = 'NO>, error retrieving redo file name for sequence 10770, archived = 1, use_alternate = 0Not able to establish initial position for sequence 10770, rba 78960656.
2011-10-16 22:41:02? ERROR?? OGG-01668? Oracle GoldenGate Capture for Oracle, e430rks2.prm:? PROCESS ABENDING.

原因是extract 所需的archived log已經被清走，不在log_archive_dest指定的目錄下，解決方法很簡單，只要把sequence 從10770開始到當前的archived log重新拷貝回log_archive_dest目錄下即可。

總結

以上是生活随笔為你收集整理的OGG-00446 ERROR: Could not find archived log的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。