oracle ogg重启,ORACLERAC重启使OGG故障处理

日志错误报告

2018-04-16 23:15:16 INFO OGG-01026 Oracle GoldenGate Capture for Oracle,

ext-all.prm: Rolling over remote file

/home/oracle/ogg/dirdat/al001269.

2018-04-16 23:15:16 INFO OGG-01053 Oracle GoldenGate Capture for Oracle,

ext-all.prm: Recovery completed for target file

/home/oracle/ogg/dirdat/al001270, at RBA 1059.

2018-04-16 23:15:16 INFO OGG-01057 Oracle GoldenGate Capture for Oracle,

ext-all.prm: Recovery completed for all

targets.

2018-04-16 23:16:38 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle,

ext-all.prm: Detect partial pdata at rba 52413456

without coinciding crash recovery marker record in log with seqno =

50552.

2018-04-16 23:16:39 INFO OGG-00991 Oracle GoldenGate Capture for Oracle,

ext-all.prm: EXTRACT EXT-ALL stopped

normally.

2018-04-16 23:20:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter

for Oracle: GGSCI command (oracle): start

EXT-ALL.

2018-04-16 23:20:09 INFO OGG-00963 Oracle GoldenGate Manager for Oracle,

mgr.prm: Command received from GGSCI on host db1

(START EXTRACT EXT-ALL ).

--

2018-04-16 23:23:09 WARNING

OGG-00938 Oracle GoldenGate Manager for Oracle,

mgr.prm: Manager is stopping at user

request.

2018-04-16 23:23:17 INFO OGG-00987 Oracle GoldenGate Command Interpreter

for Oracle: GGSCI command (oracle): stop

ext-all.

检查

GGSCI (db1) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING EXTRACT ABENDED EXT-ALL 01:24:03 00:00:18 EXTRACT RUNNING P-ALL 00:00:00 00:00:07

网上文章

在Oracle Support上找到一篇文章：GoldenGate: Extract Abend with Detect

Inconsistency in Pdata (Doc ID 1355067.1)说重启进程就可以，实际上无效。

在咨询了几个朋友后，都表示没有碰到过此类问题。一番努力后也没有什么结果，最后只好开SR求助Oracle。Oracle答复倒是挺快：

BugDB:20069033 , status 11 ,development working.

看来是碰到还没有修复的Bug了。。。不过好在还有解决该故障的Workaround：

ggsci> alter extract ELIS, thread 1, BEGIN 2014-11-20

00:35:21 ggsci> alter extract ELIS, thread 2,

BEGIN 2014-11-20 00:35:24 ggsci> start extract

ELIS

亦即通过手工分别修改Extract的两个进程的TIMESTAMP(该库是2个节点的RAC)即可解决。

实际处理,时间为执行时前1,2分钟，

也就是忽略故障段的的归档，从当前时间开始同步

ggsci> alter EXT-ALL, thread 1, BEGIN 2018-04-16

23:35:21

ggsci> alter EXT-ALL, thread 2, BEGIN 2018-04-16

23:35:21

ggsci> start EXT-ALL

处理后恢复

GGSCI (db1) 21> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING EXTRACT RUNNING EXT-ALL 00:00:00 00:00:02 EXTRACT RUNNING P-ALL 00:00:00 00:00:07