dbdao吧 关注:1,189贴子:4,072
  • 2回复贴,共1

Oracle GoldenGate报OGG-01973

只看楼主收藏回复

各位:这两天我这一套goldengate每天在22:左右报OGG-01973
环境:
os是rhel6
66.3与66.177做双向的dml同步
db是11204
goldengate是Version 12.1.2.1.6 20803560 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150422.0008.01_FBO
在66.177上进程EXTA_MTG在22:00以后abended
日志中报错如下:
2016-01-26 22:24:03 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, exta_mtg.prm: The redo record indicates data loss on object 122,438.
2016-01-27 22:15:36 ERROR OGG-01973 Oracle GoldenGate Capture for Oracle, exta_mtg.prm: The redo record indicates data loss on object 122,575.
view param EXTA_MTG
EXTRACT exta_mtg
SETENV (ORACLE_HOME = "/apps/oracle/product/11.2.0")
USERID ggs@FWLOV, PASSWORD ggs
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 90000
TRANLOGOPTIONS DBLOGREADER
EXTTRAIL /apps/ggs/files/dirdat/l_
DYNAMICRESOLUTION
TABLEEXCLUDE newlvfusrolw.SYS_EXPORT_SCHEMA_0*;
TABLEEXCLUDE newlvfusrolw.SYS_EXPORT_TABLE_0*;
tranlogoptions excludeuser ggs
TABLE newlvfusrolw.*;
把EXTA_MTG启动后就可以正常运行,我在数据库里也查不到这两个object_id
SQL>select owner,object_name,object_type from dba_objects where object_id=122438;
no rows selected
SQL>select owner,object_name,object_type from dba_objects where object_id=122575;
no rows selected
在66.3上也查不到这两个对象
各位,大家谁遇到过这种情况,这个情况我应该从何入手,还是可能忽略呢?


1楼2016-01-28 10:32回复
    楼主,这个问题解决了吗? 如何解决的?


    2楼2016-12-09 10:21
    回复
      别说我挖坟,其实我遇到和您一样的问题,各路大神还求指导。


      IP属地:北京3楼2017-12-06 11:37
      回复