ogg 查看某条更新_一则OGG捕获进程abended(与reovery checkpoint有关）的处理过程

系统事件:

周1一大早接到某保险客户电话，说某套系统源端OGG捕获进程ABENDED了，并且延时达34小时之久。考虑到目标端ODS数据仓库层需要实时同步过来的数据，火速赶往之，去看看到底是什么情况导致的。

查看报错信息：

GGSCI> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING EXTRACT ABENDED EDBCONTR 00:00:12 35:24:15EXTRACT RUNNING PDBCONTR 00:00:00 00:00:08 EXTRACT RUNNING PODSDBSY 00:00:00 00:00:08

尝试重新start ,进程还是ABENDED，查看具体错误信息：

GGSCI > view report EDBCONTR

***********************************************************************

Oracle GoldenGate Capture for Oracle

Version 10.4.0.19 Build 002

Linux, IA64, 64bit

(optimized), Oracle 10 on Sep 23 2009 16:34:26

Copyright (C) 1995, 2009, Oracle and/or its

affiliates. All rights reserved.

Starting at 2014-06-30 11:30:21

***********************************************************************

--More--(89%)

2014-06-30 11:31:51 GGS

ERROR 500 Could not find archived log for sequen

ce 101258 thread 2 under default destinations SQL

ved_log WHERE sequence# =

:ora_seq_no

AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id

AND archived = 'YES'

AND d

eleted = 'N>, error retrieving redo file name for sequence

101258, archived = 1,

use_alternate = 0Not able to establish initial

p