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