oracle lag group,OGG extract进程是running的但是lag有190个小时，report中没有报错 — oracle-tech...

GGSCI (rac1) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EPMPCE      00:00:00      01:07:30

EXTRACT     RUNNING     EXTCEN      190:43:12     00:00:09

REPLICAT    RUNNING     RORAYT      00:00:00      00:00:09

view report extcen

2014-07-09 10:23:47  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:

/OGG/goldengate/BR/EXTCEN.

Bounded Recovery Parameter:

BRINTERVAL = 4HOURS

BRDIR      = /OGG/goldengate

2014-07-09 10:23:47  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:

/OGG/goldengate/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

Database Version:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

[7m--More--(99%) [m

[KCORE 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.ZHS16GBK"

NLS_LANGUAGE     = "AMERICAN"

NLS_TERRITORY    = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

Maximum supported ASM read buffer size is 4096 KB

Maximum supported ASM read buffer size is 4096 KB

2014-07-09 10:23:48  INFO    OGG-00546  Default thread stack size: 10485760.

2014-07-09 10:23:48  INFO    OGG-01513  Positioning to (Thread 1) Sequence 61419, RBA 4273168, SCN 3053.565514431.

2014-07-09 10:23:51  INFO    OGG-01516  Positioned to (Thread 1) Sequence 61419, RBA 4273168, SCN 3053.565514431, Jun 23, 2014 5:15:04

PM.

2014-07-09 10:23:51  INFO    OGG-01513  Positioning to (Thread 2) Sequence 120003, RBA 4878352, SCN 3053.3904515219.

2014-07-09 10:23:54  INFO    OGG-01516  Positioned to (Thread 2) Sequence 120003, RBA 4878352, SCN 3053.3904515219, Jul 2, 2014 9:59:1

5 AM.

2014-07-09 10:23:54  INFO    OGG-01517  Position of first record processed for Thread 1, Sequence 61419, RBA 4273168, SCN 3053.5655144

31, Jun 23, 2014 5:15:04 PM.

2014-07-09 10:23:55  INFO    OGG-01517  Position of first record processed for Thread 2, Sequence 120003, RBA 4878352, SCN 3053.390451

5219, Jul 2, 2014 9:59:15 AM.

2014-07-09 10:23:55  INFO    OGG-01055  Recovery initialization completed for target file ./dirdat/ce000759, at RBA 1092.

2014-07-09 10:23:55  INFO    OGG-01478  Output file ./dirdat/ce is using format RELEASE 11.2.

2014-07-09 10:23:55  INFO    OGG-01026  Rolling over remote file ./dirdat/ce000759.

2014-07-09 10:23:55  INFO    OGG-01053  Recovery completed for target file ./dirdat/ce000760, at RBA 1092.

[7m--More--(99%) [m

2014-07-09 10:23:55  INFO    OGG-01057  Recovery completed for all targets.

***********************************************************************

**                     Run Time Messages                             **

***********************************************************************

2014-07-09 10:24:09  WARNING OGG-00723  Record with class# 66, slt# 14, at seqno 120013, rba 11854352 SCN 3053.3904633279 (13116439787

967) has secondary transaction ID that is duplicate of existing open uncommitted transaction.

2014-07-09 10:24:09  WARNING OGG-00715  [Thread #2] Purging transaction (transaction id: 25.14.556466, start time: 2014-07-02 11:03:23

, start seqno: 120013, start RBA: 2843664).

2014-07-09 10:24:09  WARNING OGG-00712  Updating I/O checkpoint after purging orphaned transactions on thread 2 with current position

(Seq#: 120013, RBA: 11942004).