OGG-01031 由於網路中斷導致datapump程式ABENDED的恢復方法

quanshengaa發表於2016-06-14
本機環境
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/15797451/viewspace-2119823/，如需轉載，請註明出處，否則將追究法律責任。

相關文章