OGG-00446

ogg@OSS-JH-DB1:/backup/ogg$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 05:03:51
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (OSS-JH-DB1) 4> view report EXT_JH 
***********************************************************************
                 Oracle GoldenGate Capture for Oracle
      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
  AIX 5L, ppc, 64bit (optimized), Oracle 11g on Apr 23 2012 06:24:22
 
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
                    Starting at 2015-08-12 16:03:46
***********************************************************************
Operating System Version:
AIX
Version 6, Release 1
Node: OSS-JH-DB1
Machine: 00F8C8234C00
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited
Process id: 9503094
Description: 
***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
2015-08-12 16:03:46  INFO    OGG-03035  Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
extract ext_jh
dynamicresolution
userid ogg,password ***********
2015-08-12 16:03:46  INFO    OGG-03500  WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set v
alue of ZHS16GBK.
exttrail /backup/ogg/dirdat/jh
table gsinas.ews;
table gsinas.ews_task;
2015-08-12 16:03:46  INFO    OGG-01635  BOUNDED RECOVERY: reset to initial or altered checkpoint.
2015-08-12 16:03:46  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:
    /backup/ogg/BR/EXT_JH.
Bounded Recovery Parameter:
Options    = BRRESET
BRINTERVAL = 4HOURS
BRDIR      = /backup/ogg
2015-08-12 16:03:46  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:
    /backup/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
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG         = ".ZHS16GBK" 
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "ZHS16GBK" 
2015-08-12 16:03:48  INFO    OGG-00546  Default thread stack size: 196608.
2015-08-12 16:03:48  INFO    OGG-00547  Increasing thread stack size from 196608 to 1048576.
Source Context :
  SourceModule            : [er.common]
  SourceID                : [/scratch/aime1/adestore/views/aime1_staxk12/oggcore/OpenSys/src/app/er/common.cpp]
  SourceFunction          : [extract_start_point(time_elt_def *, time_elt_def *)]
  SourceLine              : [2090]
2015-08-12 16:03:48  ERROR   OGG-00446  The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC sys
tems should be created with the THREADS parameter (e.g., ADD EXT <group name>, TRANLOG, THREADS 2, BEGIN...).
2015-08-12 16:03:48  ERROR   OGG-01668  PROCESS ABENDING.
GGSCI (OSS-JH-DB1) 35> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXT_JH      00:00:00      00:05:20    
EXTRACT     RUNNING     PUSH_JH     00:00:00      00:00:07    
GGSCI (OSS-JH-DB1) 36> stop *
EXTRACT EXT_JH is already stopped.
Sending STOP request to EXTRACT PUSH_JH ...
Request processed.
GGSCI (OSS-JH-DB1) 37> delete EXTRACT EXT_JH
2015-08-12 21:32:26  WARNING OGG-01753  Cannot unregister EXTRACT EXT_JH from database because no database login was provided. You can manually unregister this group later with the UNREGISTER EXTRACT command with LOGRETENTION. Issue DBLOGIN first.
Deleted EXTRACT EXT_JH.
GGSCI (OSS-JH-DB1) 38> add extract EXT_JH ,tranlog,threads 2,begin now
EXTRACT added.
GGSCI (OSS-JH-DB1) 39> start *
Sending START request to MANAGER ...
EXTRACT EXT_JH starting
Sending START request to MANAGER ...
EXTRACT PUSH_JH starting
GGSCI (OSS-JH-DB1) 40> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT_JH      00:00:00      00:00:10    
EXTRACT     RUNNING     PUSH_JH     00:00:00      00:01:06    
GGSCI (OSS-JH-DB1) 41> exit

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-1769710/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1769710/