因为更改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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12778571/viewspace-693999/