1.
問題:goldengate同步無反應,不成功,ggserr也沒有報錯日志,進程不abended
解決:原因是投遞進程pump讀取不到trail文件,或者說說pump設置讀取trail文件路徑是錯誤的。
2.看實際案例,有三個進程組配置好了:抓取數(shù)據(jù)進程組ext1,傳送數(shù)據(jù)組pump1,應用數(shù)據(jù)組rep1,三個進程組都啟動正常運行,ggserr也沒有報錯,ext1能正常從數(shù)據(jù)庫抓取數(shù)據(jù)。但是因為pump進程組不能傳送數(shù)據(jù),所以,同步無反應。
GGSCI (paytest01) 45> info extract ext1
EXTRACT EXT1 Last Started 2017-10-26 18:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint Oracle Redo Logs
2017-10-27 11:57:15 Seqno 104, RBA 737280
SCN 0.3095938 (3095938)
GGSCI (paytest01) 51> info pump1
EXTRACT PUMP1 Last Started 2017-10-27 12:01 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File dirdat/sp000000
First Record RBA 0
GGSCI (oracle93.weconex.com) 25> info replicat rep1
REPLICAT REP1 Last Started 2017-10-26 18:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File dirdat/rp000000
First Record RBA 0
3.分析問題:pump進程讀取目錄dirdat目錄下的sp文件,但是該目錄下有這些文件。如:
[oracle@paytest01 gg]$ ls -l dirdat -h
total 3.1M
-rw-rw-rw- 1 oracle oinstall 24K Oct 26 18:30 sp000001
-rw-rw-rw- 1 oracle oinstall 246K Oct 26 18:34 sp000002
-rw-rw-rw- 1 oracle oinstall 2.9M Oct 27 11:31 sp000003
4.最后發(fā)現(xiàn)問題:pump1進程讀取的是sp000000文件,但是只有sp000001文件,當然 First Record RBA是0.
如果pump進程組路徑設置錯誤,也會出現(xiàn)一樣的情況:goldengate同步無反應,不成功,ggserr也沒有報錯日志,進程不abended 。
網(wǎng)站標題:goldengate同步無反應,不成功,ggserr也沒有報錯日志,進程不abended
標題來源:
http://weahome.cn/article/jjdspo.html