Extract abended without any errors
I am using goldengate 11.1.1.1 on a 64bit oracle 11GR2 at windows 2008 server.I have setup a capture and a data pump process on the source ,and a replicat process on the target.
Now the data pump and the replicat process work well,but the capture extract abended.If I restart the capture extract,It failed to abend again.I open the ggserr file but find no errors,and the exttrail and rmttrail would rollover after each restart.
This is the content from the ggserr file:
2011-09-09 15:41:13 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t starting.
2011-09-09 15:41:13 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t restarted automatically.
2011-09-09 15:41:13 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t starting.
2011-09-09 15:41:14 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioning to Sequence 1481, RBA 29864464.
2011-09-09 15:41:14 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioned to Sequence 1481, RBA 29864464, 2011-9-9 下午02:43:53.
2011-09-09 15:41:14 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t started.
2011-09-09 15:41:14 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, e_t.prm: Recovery initialization completed for target file d:\ggs\dirdat\td000686, at RBA 1331, CSN 6015415010.
2011-09-09 15:41:14 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, e_t.prm: Output file d:\ggs\dirdat\td is using format RELEASE 10.4/11.1.
2011-09-09 15:41:14 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, e_t.prm: Rolling over remote file d:\ggs\dirdat\td000686.
2011-09-09 15:41:14 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, e_t.prm: Position of first record processed Sequence 1481, RBA 29864464, SCN 1.1720447707, 2011-9-9 下午02:43:53.
2011-09-09 15:43:19 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t starting.
2011-09-09 15:43:19 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t restarted automatically.
2011-09-09 15:43:19 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t starting.
2011-09-09 15:43:20 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioning to Sequence 1481, RBA 29864464.
2011-09-09 15:43:20 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioned to Sequence 1481, RBA 29864464, 2011-9-9 下午02:43:53.
2011-09-09 15:43:20 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t started.
2011-09-09 15:43:20 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, e_t.prm: Recovery initialization completed for target file d:\ggs\dirdat\td000687, at RBA 1331, CSN 6015415010.
2011-09-09 15:43:20 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, e_t.prm: Output file d:\ggs\dirdat\td is using format RELEASE 10.4/11.1.
2011-09-09 15:43:20 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, e_t.prm: Rolling over remote file d:\ggs\dirdat\td000687.
2011-09-09 15:43:20 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, e_t.prm: Position of first record processed Sequence 1481, RBA 29864464, SCN 1.1720447707, 2011-9-9 下午02:43:53.
2011-09-09 15:43:20 INFO OGG-01054 Oracle GoldenGate Capture for Oracle, e_t.prm: Recovery completed for target file d:\ggs\dirdat\td000688, at RBA 1331, CSN 6015415010.
2011-09-09 15:43:20 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, e_t.prm: Recovery completed for all targets.
2011-09-09 15:46:01 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t starting.
2011-09-09 15:46:01 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT e_t restarted automatically.
2011-09-09 15:46:01 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t starting.
2011-09-09 15:46:02 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioning to Sequence 1481, RBA 29864464.
2011-09-09 15:46:02 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, e_t.prm: Positioned to Sequence 1481, RBA 29864464, 2011-9-9 下午02:43:53.
2011-09-09 15:46:02 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, e_t.prm: EXTRACT e_t started.
2011-09-09 15:46:02 INFO OGG-01056 Oracle GoldenGate Capture for Oracle, e_t.prm: Recovery initialization completed for target file d:\ggs\dirdat\td000688, at RBA 1331, CSN 6015415010.
2011-09-09 15:46:02 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, e_t.prm: Output file d:\ggs\dirdat\td is using format RELEASE 10.4/11.1.
2011-09-09 15:46:02 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, e_t.prm: Rolling over remote file d:\ggs\dirdat\td000688.
2011-09-09 15:46:03 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, e_t.prm: Position of first record processed Sequence 1481, RBA 29864464, SCN 1.1720447707, 2011-9-9 下午02:43:53.
The exttrail and rmttrail file is very small ,only 2K size.the default trail file size is set to 10M.
This is the relative rpt content:
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1 OGGCORE_11.1.1_PLATFORMS_110421.2040
Windows x64 (optimized), Oracle 11g on Apr 22 2011 00:19:58
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-09-10 18:57:39
***********************************************************************
Operating System Version:
Microsoft Windows Server 2008 Standard Edition, on x64
Version 6.0 (Build 6002: Service Pack 2)
Process id: 8172
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract e_fz_t
SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid goldengate,password ********************************* ENCRYPTKEY DEFAULT
EXTTRAIL d:\ggs\dirdat\td
GETUPDATEBEFORES
IGNOREREPLICATES
GETAPPLOPS
WARNLONGTRANS 2h, CHECKINTERVAL 3m
tracetable goldengate.tb_trace
table schema1.*;
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = D:\ggs
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:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
2011-09-10 18:57:40 INFO OGG-01513 Positioning to Sequence 1481, RBA 29868048.
2011-09-10 18:57:40 INFO OGG-01560 Positioned to Sequence 1481, RBA 29868048.
2011-09-10 18:57:40 INFO OGG-01056 Recovery initialization completed for target file d:\ggs\dirdat\td001131, at RBA 1331, CSN 6015415010.
2011-09-10 18:57:40 INFO OGG-01478 Output file d:\ggs\dirdat\td is using format RELEASE 10.4/11.1.
2011-09-10 18:57:40 INFO OGG-01026 Rolling over remote file d:\ggs\dirdat\td001131.
***********************************************************************
** Run Time Messages **
***********************************************************************
2011-09-10 18:57:40 INFO OGG-01517 Position of first record processed Sequence 1481, RBA 29868048, SCN 1.1720447711, 2011-9-9 下午02:43:58.
TABLEWildcard resolved (entry schema1.TB_*):
table schema1.TB_QSD_PRINT;
Can any give me some advise to resolve the problem ?Don't tell me to add paramer such as :tablexclued schema1.tb_qsd_print to the prm file.I think this is not a best way to fix the problem.