Oracle数据库数据恢复、性能优化»论坛 › Oracle › OGG-Oracle GoldenGate › OGG Pump 进程未能正确处理Trail 文件

0 积分	0 好友	2 主题

发消息

OGG Pump 进程未能正确处理Trail 文件

1^#

发表于 2015-1-27 08:33:53 | 查看: 10816| 回复: 9

问题描述：
源端和目标端数据库数据不同步，时间超出一周，所以重新根据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文件
Screen Shot 2015-01-27 at 08.18.45.png

从上面这张图片可以看到，e_travel 产生的Trail文件已经到了l30004**, 但是pump进程却一直停留在l3000000，请问是否这就是导致源端和目标端数据没法同步的原因，谢谢！

分享0

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2015-1-27 11:02:01

不要老截图，老老实实贴日志！

回复只看该作者道具举报

cooper168

3^#

发表于 2015-1-27 11:23:22

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)

回复只看该作者道具举报

cooper168

4^#

发表于 2015-1-27 11:24:13

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.

回复只看该作者道具举报

cooper168

5^#

发表于 2015-1-27 11:25:19

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

回复只看该作者道具举报

cooper168

6^#

发表于 2015-1-27 11:25:37

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

回复只看该作者道具举报

cooper168

7^#

发表于 2015-1-27 11:27:16

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

================================================================================

回复只看该作者道具举报

cooper168

8^#

发表于 2015-1-27 11:27:35

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

回复只看该作者道具举报

cooper168

9^#

发表于 2015-1-27 11:27:57

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

回复只看该作者道具举报

cooper168

10^#

发表于 2015-1-27 11:28:30

Liu Maclean(刘相兵发表于 2015-1-27 11:02
不要老截图，老老实实贴日志！

抱歉，现已吧日志贴上了，谢谢！

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册