OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint问题处理

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:888

Oracle Goldengate出现报错OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint问题处理

oracle glodengate启动抽取进程不成功,状态为ABENDED
GGSCI (p670b) 24> start EPMP01
Sending START request to MANAGER ...
EXTRACT EPMP01 starting

GGSCI (p670b) 23> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EPMP01 00:00:00 165:42:10

查看EPMP01抽取进程日志:报OGG-01635 和OGG-01496 错误
2011-06-27 15:49:45 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.
Bounded Recovery Parameter:
Options = BRRESET
BRINTERVAL = 4HOURS
BRDIR = /goldengate
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
Database Version:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
2011-06-27 15:49:45 INFO OGG-01515 Positioning to begin time Jun 27, 2011 3:49:33 PM.
2011-06-27 15:49:45 INFO OGG-01516 Positioned to Sequence 46023, RBA 21520, Jun 27, 2011 3:49:33 PM.
Source Context :
SourceModule : [er.recovery]
SourceID : [/home/ecloud/workspace/Build_OpenSys_r11.1.1.0.0_078_[34104]/perforce/src/app/er/recovery.c]
SourceFunction : [RECOVERY_initialize()]
SourceLine : [1704]
2011-06-27 15:49:45 ERROR OGG-01496 Failed to open target trail file /goldengate/dirdat/HX000016, at RBA 183749692.
2011-06-27 15:49:45 ERROR OGG-01668 PROCESS ABENDING.

解决方法:

重新配置抽取进程

delete extract EPMP01
delete exttrail /goldengate/dirdat/DN

add extract EPMP01, tranlog, begin now
add exttrail /goldengate/dirdat/DN, ext EPMP01, MEGABYTES 200

启动抽取进程
start extract EPMP01

info all

GGSCI (p670b) 23> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EPMP01 00:00:00 165:42:10

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】