OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint問題處理

paulyibinyi發表於2011-06-28
  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章