0 Replies Latest reply: Jul 8, 2014 11:16 PM by User369527 RSS

    OGG extract进程是running的但是lag有190个小时,report中没有报错

    User369527

      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).