【环境】
源端: redhat6,oracle 10g,ogg版本11.2.1.0.6
目标端: redhat6,oracle 10g,ogg版本11.2.1.0.6
【故障现象】
目标库
GGSCI (single19) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP_DZDA 00:00:00 963:54:15
REPLICAT RUNNING REP_LSTP 00:00:00 00:00:01
REPLICAT ABENDED REP_RKXT 00:00:00 963:54:09
【故障原因】
2025-07-16 16:38:36 ERROR OGG-01091 Unable to open file "/oracle/ogg/dirdat/rk057366" (error 2, No such file or directory).
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Reading /oracle/ogg/dirdat/rk057366, current RBA 0, 0 records
Report at 2025-07-16 16:38:36 (activity since 2025-07-16 16:38:35)
No records were replicated.
2025-07-16 16:38:36 ERROR OGG-01668 PROCESS ABENDING.
【解决方法】
首先确定ogg进程最后正常的时间
ggsci >info REP_DZDA
ggsci >info REP_RKXT

2.然后将应用进程设置到第1步查询出的时间点之前启动:
ggsci >ALTER REPLICAT REP_DZDA BEGIN 2025-06-06 11:18:20
ggsci >ALTER REPLICAT REP_RKXT BEGIN 2025-06-06 11:19:10
3.编辑进程,添加HANDLECOLLISIONS参数:
ggsci > edit params REP_DZDA
ggsci > edit params REP_RKXT
将HANDLECOLLISIONS参数加入,保存退出。
4.启动进程,查看进程状态为running。
ggsci > start replicat REP_DZDA
ggsci > start replicat REP_RKXT
ggsci > start REP_DZDA
ggsci > start REP_RKXT

查看运行报告
ggsci > view report REP_DZDA
ggsci > view report REP_RKXT




