最近遇到這個問題,其實提示很簡單了。 去oracle 論壇看下,有人回覆了 Extract was off for two long. All redo logs have been switched. You have to provide archive logs to Oracle defau ...
最近遇到這個問題,其實提示很簡單了。
去oracle 論壇看下,有人回覆了
Extract was off for two long. All redo logs have been switched.
You have to provide archive logs to Oracle default destination or configure destination in GG parameter file.
If you don't have archive logs you have to resynchronize the two databases.
大概意思
由於線程2為1的歸檔日誌已經被刪除,導致goldengate 抽取進程停止:
解決方法:
1、恢復刪除的歸檔日誌,重新啟動抽取進程;
rman target ggs/ggs@orcl
RMAN>restore archivelog from logseq 1 until logseq 587 ;
GGSCI>start ext ext
fuck恢復報錯
3、通過v$archived_log查詢到下個日誌的時間點,重新指定抽取進程的時間點,啟動抽取進程;
GGSCI>alter extract extjms2 ,begin 2014-11-20 00:20:15
GGSCI>start extjms2
4.實在不行就從現在啟動。
這個會缺失數據的!!!!
GGSCI> alter extract ext begin now
GGSCI> start ext ext