OGG-01031 由于网络中断导致datapump进程ABENDED的恢复方法

分类： Oracle

本机环境
Oracle Server - Enterprise Linux Enterprise Linux Server release 5.7 (Carthage)
Database - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
OGG - Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

症状（Symptoms）
Source
源端投递进程处于ABENDED状态，检查点在5小56分13秒之前，已经中断很久了。
GGSCI (oggsource) 20> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     ABENDED     DP1         00:00:00      05:56:13
EXTRACT     RUNNING     EX1         00:00:00      00:00:09

trail文件ex000000的检查点是5小时56分38秒之前，在该文件之后就再没投递过数据
GGSCI (oggsource) 22> info dp1

EXTRACT    DP1       Last Started 2014-08-09 21:48   Status ABENDED
Checkpoint Lag       00:00:00 (updated 05:56:38 ago )
Log Read Checkpoint  File /u01/app/oracle/gg/dirdat/ex000000
                     2014-08-09 15:49:03.000000  RBA 1182

投递进程报错OGG-01031
GGSCI (oggsource) 26> view report dp1
…
…
2014-08-09 21:48:27  ERROR   OGG-01031   There is a problem in network communication, a remote file pr
oblem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Re
ply received is Unable to open file "/u01/app/oracle/gg/dirdat/rt000000" (error 11, Resource temporar
ily unavailable)).

2014-08-09 21:48:27  ERROR   OGG-01668  PROCESS ABENDING.

Target
目标端replicat报错
GGSCI (oggtarget) 13> view report rt1
…
…
2014-08-09 16:54:12  WARNING OGG-01519  Waiting at EOF on input trail file /u01/app/oracle/gg/dirdat/
rt000000, which is not marked as complete; but succeeding trail file /u01/app/oracle/gg/dirdat/rt0000
01 exists. If ALTER ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed
 on each corresponding downstream reader.

2014-08-09 16:54:48  INFO    OGG-01021  Command received from GGSCI: STOP.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

Reading /u01/app/oracle/gg/dirdat/rt000000 , current RBA 1224, 0 records

Report at 2014-08-09 16:54:48 (activity since 2014-08-09 16:43:08)

No records were replicated.

问题原因（Cause）

由于源端到目标端的网络连接中断导致
OGG-01031  There is a problem in network communication

解决方案（Solution）

Source
投递进程产生新的文件点
GGSCI (oggsource) 44> alter extract dp1 etrollover
GGSCI (oggsource) 45> stop ex1
GGSCI (oggsource) 46> stop dp1
GGSCI (oggsource) 47> stop mgr

GGSCI (oggsource) 50> start mgr
GGSCI (oggsource) 51> start ex1
GGSCI (oggsource) 52> start dp1

Target
从序列号1开始（rt000001）
GGSCI (oggtarget) 10> stop rt1
GGSCI (oggtarget) 14> alter replicat rt1 extseqno 1 extrba 0
GGSCI (oggtarget) 15> start rt1