ITPub博客

首页 > Linux操作系统 > Linux操作系统 > OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint问题处理

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

原创 Linux操作系统 作者:paulyibinyi 时间:2011-06-28 23:06:58 0 删除 编辑
  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  

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-700922/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6597824