本机环境
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
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博客 ” ，链接：https://blog.itpub.net/29047826/viewspace-1255022/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
