OGG Pump 进程未能正确处理Trail 文件
问题描述：源端和目标端数据库数据不同步，时间超出一周，所以重新根据SCN号对数据库做导出，并恢复到目标端，在此同时源端的抓取进程一直在运行，源端的pump进程处于停止状态，待目标端数据恢复后，开启源端的pump进程和目标端的rep进程，并发现源端和目标端的trail文件大小差异很大，源端和目标端所有进程都正常运行无错误或异常记录，但是在目标端的业务表中并无最新的数据。
源端文件：
目标端收到的文件：
pump 进程参数配置：
extract p_travel
dynamicresolution
gettruncates
passthru
rmthost 10.142.78.253,mgrport 5070, compress
rmttrail ./dirdat/r3
table sajet.G_SN_TRAVEL;
检查源端的抓取进程：
源端抓取进程产生的Trail文件
从上面这张图片可以看到，e_travel 产生的Trail文件已经到了l30004**, 但是pump进程却一直停留在l3000000，请问是否这就是导致源端和目标端数据没法同步的原因，谢谢！ 不要老截图，老老实实贴日志！ GGSCI (mesrac2) 2> info e_travel
EXTRACT E_TRAVEL Last Started 2015-01-26 22:56 Status RUNNING
Checkpoint Lag 00:00:02 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2015-01-27 11:12:25 Thread 1, Seqno 6248, RBA 1237156
SCN 2.2249714244 (10839648836)
Log Read Checkpoint Oracle Redo Logs
2015-01-27 11:12:25 Thread 2, Seqno 6109, RBA 77835264
SCN 2.2249714249 (10839648841)
GGSCI (mesrac2) 3> view report e_travel
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:32:12
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-01-26 22:56:24
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: mesrac2
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 7746
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2015-01-26 22:56:24 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: zh_CN
, LC_ALL:.
extract e_travel
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid ogg,password ******
dynamicresolution
gettruncates
exttrail ./dirdat/l3
numfiles 1000
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000
tranlogoptions altarchivelogdest instance MESDB2 /oraarch,altarchivelogdest instance MESDB1 /oraarch
TABLE SAJET.G_SN_TRAVEL;
2015-01-26 22:56:24 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oraogg/ogg/BR/E_TRAVEL.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /oraogg/ogg
2015-01-26 22:56:24 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oraogg/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
2015-01-26 22:56:25 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 1: p17550_Redo Thread
1.
2015-01-26 22:56:25 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.
2015-01-26 22:56:25 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 6244, RBA: 2109
0832, SCN: 2.2247142093 (10837076685), Timestamp: 2015-01-26 19:40:32.000000, Thread: 1.
2015-01-26 22:56:25 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 6244, RBA: 210913
28, SCN: 2.2247142093 (10837076685), Timestamp: 2015-01-26 19:40:32.000000, Thread: 1.
2015-01-26 22:56:25 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 1: p17550_Redo Thread
1.
2015-01-26 22:56:25 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 2: p17550_Redo Thread
2.
2015-01-26 22:56:25 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.
2015-01-26 22:56:26 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 6106, RBA: 3092
7376, SCN: 2.2247142094 (10837076686), Timestamp: 2015-01-26 19:40:33.000000, Thread: 2.
2015-01-26 22:56:26 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 6106, RBA: 309278
72, SCN: 2.2247142094 (10837076686), Timestamp: 2015-01-26 19:40:33.000000, Thread: 2.
2015-01-26 22:56:26 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 2: p17550_Redo Thread
2.
2015-01-26 22:56:26 INFO OGG-01579 BOUNDED RECOVERY: VALID BCP: CP.E_TRAVEL.000000008.
2015-01-26 22:56:26 INFO OGG-01629 BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>
>.
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.AL32UTF8"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
2015-01-26 22:56:27 INFO OGG-00546 Default thread stack size: 10485760.
2015-01-26 22:56:27 INFO OGG-01513 Positioning to (Thread 1) Sequence 6244, RBA 193658896, SCN 2.224
7629266.
2015-01-26 22:56:27 INFO OGG-01516 Positioned to (Thread 1) Sequence 6244, RBA 193658896, SCN 2.2247
629266, 2015-1-26 下午10:55:53.
2015-01-26 22:56:27 INFO OGG-01513 Positioning to (Thread 2) Sequence 6106, RBA 135488016, SCN 2.224
7629340.
2015-01-26 22:56:27 INFO OGG-01516 Positioned to (Thread 2) Sequence 6106, RBA 135488016, SCN 2.2247
629340, 2015-1-26 下午10:55:56.
2015-01-26 22:56:27 INFO OGG-01517 Position of first record processed for Thread 2, Sequence 6106, R
BA 135488016, SCN 2.2247629340, 2015-1-26 下午10:55:56.
2015-01-26 22:56:27 INFO OGG-01517 Position of first record processed for Thread 1, Sequence 6244, R
BA 193658896, SCN 2.2247629266, 2015-1-26 下午10:55:53.
2015-01-26 22:56:27 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/l30004
12, at RBA 76124666.
2015-01-26 22:56:27 INFO OGG-01478 Output file ./dirdat/l3 is using format RELEASE 11.2.
2015-01-26 22:56:27 INFO OGG-01026 Rolling over remote file ./dirdat/l3000412.
2015-01-26 22:56:28 INFO OGG-01053 Recovery completed for target file ./dirdat/l3000413, at RBA 1083
.
2015-01-26 22:56:28 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
TABLE resolved (entry SAJET.G_SN_TRAVEL):
TABLE "SAJET"."G_SN_TRAVEL";
2015-01-26 22:56:33 WARNING OGG-00869 No unique key is defined for table 'G_SN_TRAVEL'. All viable colu
mns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define t
he key.
Using the following key columns for source table SAJET.G_SN_TRAVEL: WORK_ORDER, SERIAL_NUMBER, MODEL_ID,
VERSION, ROUTE_ID, PDLINE_ID, STAGE_ID, PROCESS_ID, TERMINAL_ID, NEXT_PROCESS, CURRENT_STATUS, WORK_FLAG,
IN_PROCESS_TIME, OUT_PROCESS_TIME, IN_PDLINE_TIME, OUT_PDLINE_TIME, ENC_CNT, PALLET_NO, CARTON_NO, CONTA
INER, QC_NO, QC_RESULT, CUSTOMER_ID, WARRANTY, REWORK_NO, EMP_ID, SHIPPING_ID, CUSTOMER_SN, RC_NO, INNERB
OX_NO, WIP_PROCESS, EC, RP_STATION, RECOUNT_TYPE, WEIGHT, LAST_PROCESS_ID, LAST_TERMINAL_ID, REWORK_CNT,
MODEL_NAME, ENABLED, RECID.
2015-01-27 02:56:34 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p17550_Redo Thre
ad 1: start=SeqNo: 6246, RBA: 197371920, SCN: 2.2248318956 (10838253548), Timestamp: 2015-01-27 02:56:31.
000000, end=SeqNo: 6246, RBA: 197385728, SCN: 2.2248318991 (10838253583), Timestamp: 2015-01-27 02:56:32.
000000, Thread: 1.
2015-01-27 02:56:34 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 2: p17550_Redo Thre
ad 2: start=SeqNo: 6108, RBA: 121694224, SCN: 2.2248318963 (10838253555), Timestamp: 2015-01-27 02:56:31.
000000, end=SeqNo: 6108, RBA: 121740288, SCN: 2.2248319055 (10838253647), Timestamp: 2015-01-27 02:56:33.
000000, Thread: 2.
2015-01-27 06:56:45 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p17550_Redo Thre
ad 1: start=SeqNo: 6246, RBA: 396068880, SCN: 2.2248864527 (10838799119), Timestamp: 2015-01-27 06:56:40.
000000, end=SeqNo: 6246, RBA: 396122624, SCN: 2.2248864770 (10838799362), Timestamp: 2015-01-27 06:56:43.
000000, Thread: 1.
2015-01-27 06:56:45 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 2: p17550_Redo Thre
ad 2: start=SeqNo: 6108, RBA: 275654160, SCN: 2.2248864722 (10838799314), Timestamp: 2015-01-27 06:56:42.
000000, Thread: 2, end=SeqNo: 6108, RBA: 275654656, SCN: 2.2248864722 (10838799314), Timestamp: 2015-01-2
7 06:56:42.000000, Thread: 2.
2015-01-27 10:56:50 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p17550_Redo Thre
ad 1: start=SeqNo: 6247, RBA: 400148496, SCN: 2.2249669669 (10839604261), Timestamp: 2015-01-27 10:56:46.
000000, end=SeqNo: 6247, RBA: 400321024, SCN: 2.2249669902 (10839604494), Timestamp: 2015-01-27 10:56:48.
000000, Thread: 1.
2015-01-27 10:56:50 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 2: p17550_Redo Thre
ad 2: start=SeqNo: 6109, RBA: 67138576, SCN: 2.2249669785 (10839604377), Timestamp: 2015-01-27 10:56:47.0
00000, end=SeqNo: 6109, RBA: 67152896, SCN: 2.2249669904 (10839604496), Timestamp: 2015-01-27 10:56:48.00
0000, Thread: 2. GGSCI (mesrac2) 4> info e_travel, detail
EXTRACT E_TRAVEL Last Started 2015-01-26 22:56 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint Oracle Redo Logs
2015-01-27 11:15:33 Thread 1, Seqno 6248, RBA 4397584
SCN 2.2249718653 (10839653245)
Log Read Checkpoint Oracle Redo Logs
2015-01-27 11:15:32 Thread 2, Seqno 6109, RBA 78520916
SCN 2.2249718631 (10839653223)
Target Extract Trails:
Remote Trail Name Seqno RBA Max MB
./dirdat/l3 413 80116996 100
Extract Source Begin End
/oradata/MESDB/redo07a.log 2015-01-26 22:55 2015-01-27 11:15
/oradata/MESDB/redo09a.log * Initialized * 2015-01-26 22:55
/oradata/MESDB/redo06a.log * Initialized * First Record
/oradata/MESDB/redo06a.log 2015-01-22 16:30 2015-01-25 11:39
/oradata/MESDB/redo09a.log 2015-01-10 16:27 2015-01-22 16:30
/oradata/MESDB/redo07a.log 2015-01-07 13:51 2015-01-10 16:27
/oradata/MESDB/redo09a.log 2015-01-07 09:07 2015-01-07 13:51
Not Available 2015-01-06 19:18 2015-01-07 09:07
Not Available 2015-01-06 19:18 2015-01-07 00:26
/oradata/MESDB/redo09a.log 2015-01-06 19:18 2015-01-07 00:21
/oradata/MESDB/redo07a.log 2014-12-17 16:56 2015-01-06 19:18
/oradata/MESDB/redo10a.log 2014-11-11 15:58 2014-12-17 16:56
/oradata/MESDB/redo10a.log 2014-11-07 15:20 2014-11-11 15:58
Not Available 2014-10-30 09:27 2014-11-07 15:20
/oradata/MESDB/redo07a.log 2014-10-13 13:21 2014-10-30 09:28
Not Available 2014-10-01 08:08 2014-10-13 13:21
/oradata/MESDB/redo08a.log 2014-09-20 16:44 2014-10-01 08:08
Not Available 2014-09-19 17:20 2014-09-20 16:44
Not Available * Initialized * 2014-09-19 17:20
Current directory /oraogg/ogg
Report file /oraogg/ogg/dirrpt/E_TRAVEL.rpt
Parameter file /oraogg/ogg/dirprm/e_travel.prm
Checkpoint file /oraogg/ogg/dirchk/E_TRAVEL.cpe
Process file /oraogg/ogg/dirpcs/E_TRAVEL.pce
Stdout file /oraogg/ogg/dirout/E_TRAVEL.out
Error log /oraogg/ogg/ggserr.log GGSCI (mesrac2) 5> info p_travel
EXTRACT P_TRAVEL Last Started 2015-01-27 07:56 Status STOPPED
Checkpoint Lag 00:00:00 (updated 02:47:37 ago)
Log Read Checkpoint File ./dirdat/l3000000
First Record RBA 0 GGSCI (mesrac2) 6> view report p_travel
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:32:12
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2015-01-27 07:56:49
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: mesrac2
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 19253
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2015-01-27 07:56:49 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: zh_CN, LC_ALL:.
extract p_travel
dynamicresolution
gettruncates
passthru
rmthost 10.142.78.253,mgrport 5070
rmttrail ./dirdat/r3
table sajet.G_SN_TRAVEL;
2015-01-27 07:56:49 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oraogg/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
2015-01-27 07:56:54 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2015-01-27 07:56:54 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/r3000586, at RBA 6249.
2015-01-27 07:56:54 INFO OGG-01478 Output file ./dirdat/r3 is using format RELEASE 11.2.
2015-01-27 07:56:54 INFO OGG-01026 Rolling over remote file ./dirdat/r3000587.
2015-01-27 07:56:54 INFO OGG-01053 Recovery completed for target file ./dirdat/r3000587, at RBA 6215.
2015-01-27 07:56:54 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
2015-01-27 08:31:42 INFO OGG-01021 Command received from GGSCI: STOP.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2015-01-27 08:31:42 (activity since 2015-01-27 07:56:49)
Output to ./dirdat/r3:
No records extracted.
REDO Log Statistics
Bytes parsed 0
Bytes output 63
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 64G cache force paging = 96G
buffer min = 64K buffer highwater = 8M
pageout eligible size = 8M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================ RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: p_travel id: p19253_BLOB instance: 0 tid: (nil)
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0
POOL INFO group: p_travel id: p19253_BLOB instance: 0 tid: (nil)
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: p_travel id: p19253_BLOB instance: 0 tid: (nil)
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0
POOL INFO group: p_travel id: p19253_BLOB instance: 0 tid: (nil)
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0 GGSCI (mesrac2) 7> info p_travel, detail
EXTRACT P_TRAVEL Last Started 2015-01-27 07:56 Status STOPPED
Checkpoint Lag 00:00:00 (updated 02:48:35 ago)
Log Read Checkpoint File ./dirdat/l3000000
First Record RBA 0
Target Extract Trails:
Remote Trail Name Seqno RBA Max MB
./dirdat/r3 587 6278 100
Extract Source Begin End
./dirdat/l3000000 * Initialized * First Record
./dirdat/l3000000 * Initialized * First Record
./dirdat/l3000000 * Initialized * First Record
./dirdat/l3000000 * Initialized * First Record
Current directory /oraogg/ogg
Report file /oraogg/ogg/dirrpt/P_TRAVEL.rpt
Parameter file /oraogg/ogg/dirprm/p_travel.prm
Checkpoint file /oraogg/ogg/dirchk/P_TRAVEL.cpe
Process file /oraogg/ogg/dirpcs/P_TRAVEL.pce
Stdout file /oraogg/ogg/dirout/P_TRAVEL.out
Error log /oraogg/ogg/ggserr.log Liu Maclean(刘相兵 发表于 2015-1-27 11:02 static/image/common/back.gif
不要老截图，老老实实贴日志！
抱歉，现已吧日志贴上了，谢谢！
页:
[1]