GoldenGate不能把源庫的資料傳送到備庫,不能停止源庫傳送程式

mengzhaoliang發表於2011-04-28

因為更改goldengate的傳送程式引數,更改了裡面需要傳送的Oracle資料庫使用者。
導致不能把源庫的資料傳送到備庫中,備庫的goldengate的dirdat目錄下沒有源庫的資料。

傳輸程式的日誌資訊:
2011-04-28 09:52:51  INFO    OGG-01478  Output file /oragg/oggst/dirdat/st is using format RELEASE 10.4/11.1.
2011-04-28 09:52:51  WARNING OGG-01438  Checkpoint marked as from graceful shutdown, but records found after checkpoint in trail /oragg/oggst/dirdat/st.  Expected EOF Seqno 0, RBA 0.  Found Seqno 5, RBA 14443024.
2011-04-28 09:52:51  INFO    OGG-01026  Rolling over remote file /oragg/oggst/dirdat/st000006.


1、不能停止
GGSCI (CBDBS01) 28> stop pumpst

Sending STOP request to EXTRACT PUMPST ...

Recovery is not complete.  This normal stop will wait and checkpoint recovery's
work when recovery has finished. To force Extract to stop now, use the SEND EXTR
ACT PUMPST, FORCESTOP command.

2、系統強制kill 傳輸程式:
檢視程式:
CBDBS01-> ps -ef|grep gg
    root   738   719  0  Dec 30  ?         0:14 /usr/sbin/evmlogger -o /var/run/
evmlogger.info -l /var/evm/adm/logfiles/evmlogger.log
  oraoms 12592  8152  0 09:49:20 ?         1:15 /oragg/oggst/extract PARAMFILE /
oragg/oggst/dirprm/extst.prm REPORTFILE /oragg/oggst/dirrpt/EXTST.rpt PROCESSID
EXTST USESUBDIR
    grid  2656  2562  0  Dec 30  ?         0:00 /oracle/crs_home/product/11.2.0/
grid/bin/evmlogger.bin -o /oracle/crs_home/product/11.2.0/grid/evm/log/evmlogger
.info -l /oracl
  oraoms  8152     1  0  Mar 24  ?         8:01 ./mgr PARAMFILE /oragg/oggst/dir
prm/mgr.prm REPORTFILE /oragg/oggst/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
  oraoms 12738  8152  0 09:52:46 ?         0:09 /oragg/oggst/extract PARAMFILE /
oragg/oggst/dirprm/pumpst.prm REPORTFILE /oragg/oggst/dirrpt/PUMPST.rpt PROCESSI
D PUMPST USESUB
  oraoms 16546 12721  1 14:00:28 pts/ta    0:00 grep gg

殺死程式:
CBDBS01-> kill 12738

3、更改傳輸的時間,以前的資料不需要傳輸:
GGSCI (CBDBS01) 29>alter extract pumpst, begin 2011-04-28 09:55:34

4、啟動傳輸程式:
GGSCI (CBDBS01) 30>start pumpst

可以把程式傳輸到備庫了。

 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-693999/,如需轉載,請註明出處,否則將追究法律責任。

相關文章