我更改了一下参数文件

重启一下mgr

GGSCI (jhyb01) 14> start mgr

Manager started.

GGSCI (jhyb01) 15> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EXTY1       00:00:00      18:53:38

EXTRACT     RUNNING     PMPY1       00:00:00      00:00:23

GGSCI (jhyb01) 16> view param exty1

EXTRACT exty1

setenv (ORACLE_SID=jjh1)

setenv (ORACLE_HOME=/oracle/product/10.2/db_1)

setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

USERID goldengate, PASSWORD goldengate

TRANLOGOPTIONS ASMUSER sys@asm1, ASMPASSWORD oracle

TRANLOGOPTIONS ASMUSER sys@asm2, ASMPASSWORD oracle

TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance jhybora1  +DG02/jhybora/archivelog/, ALTARCHIVELOGDEST primary instance jhybora

2 +DG02/jhybora/archivelog/

TRANLOGOPTIONS DBLOGREADER

DISCARDFILE ./dirrpt/exty1.dsc,APPEND,MEGABYTES 50

WARNLONGTRANS 2h,CHECKINTERVAL 3m

EXTTRAIL ./dirdat/y1, megabytes 50

FETCHOPTIONS NOUSESNAPSHOT

Dynamicresolution

--DDL INCLUDE MAPPED

--DDLOPTIONS ADDTRANDATA

table JHYB.*;

GGSCI (jjh01) 17> view report exty1

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

Oracle GoldenGate Capture for Oracle

Version 11.2.1.0.4 14636914 OGGCORE_11.2.1.0.4_PLATFORMS_121007.2020

AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Oct  8 2012 05:14:48

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

Starting at 2014-11-18 16:35:23

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

Operating System Version:

AIX

Version 6, Release 1

Node: jhyb01

Machine: 00F775984C00

soft limit   hard limit

Address Space Size   :    unlimited    unlimited

Heap Size            :    unlimited    unlimited

File Size            :    unlimited    unlimited

CPU Time             :    unlimited    unlimited

Process id: 13041876

Description:

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

**            Running with the following parameters                  **

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

2014-11-18 16:35:23  INFO    OGG-03035  Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.

EXTRACT exty1

setenv (ORACLE_SID=jjh1)

Set environment variable (ORACLE_SID=jjh1)

setenv (ORACLE_HOME=/oracle/product/10.2/db_1)

Set environment variable (ORACLE_HOME=/oracle/product/10.2/db_1)

setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

USERID goldengate, PASSWORD **********

TRANLOGOPTIONS ASMUSER sys@asm1, ASMPASSWORD ******

TRANLOGOPTIONS ASMUSER sys@asm2, ASMPASSWORD ******

TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance jhybora1  +DG02/jhybora/archivelog/, ALTARCHIVELOGDEST primary instance jhybora

2 +DG02/jhybora/archivelog/

TRANLOGOPTIONS DBLOGREADER

DISCARDFILE ./dirrpt/exty1.dsc,APPEND,MEGABYTES 50

WARNLONGTRANS 2h,CHECKINTERVAL 3m

EXTTRAIL ./dirdat/y1, megabytes 50

FETCHOPTIONS NOUSESNAPSHOT

Dynamicresolution

table JHYB.*;

2014-11-18 16:35:24  INFO    OGG-01635  BOUNDED RECOVERY: reset to initial or altered checkpoint.

2014-11-18 16:35: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:

/ogg/BR/EXTY1.

Bounded Recovery Parameter:

Options    = BRRESET

BRINTERVAL = 4HOURS

BRDIR      = /ogg

2014-11-18 16:35: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:

/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 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

PL/SQL Release 10.2.0.5.0 - Production

CORE    10.2.0.5.0      Production

TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio

NLSRTL Version 10.2.0.5.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 1024 KB

2014-11-18 16:35:24  WARNING OGG-01423  No valid default archive log destination directory found for thread 1.

Maximum supported ASM read buffer size is 1024 KB

2014-11-18 16:35:25  WARNING OGG-01423  No valid default archive log destination directory found for thread 2.

2014-11-18 16:35:25  INFO    OGG-00546  Default thread stack size: 196608.

2014-11-18 16:35:25  INFO    OGG-00547  Increasing thread stack size from 196608 to 1048576.

还是启动不了exty1,

查看ggserr.log

tail -f ggserr.log

file alloc: mmap(MAP_SHARED)  file free: munmap

target directories:

/ogg/dirtmp.

2014-11-18 16:35:24  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, exty1.prm:  No valid default archive log destination directory found for thread 1.

2014-11-18 16:35:25  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, exty1.prm:  No valid default archive log destination directory found for thread 2.

2014-11-18 16:35:25  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, exty1.prm:  Default thread stack size: 196608.

2014-11-18 16:35:25  INFO    OGG-00547  Oracle GoldenGate Capture for Oracle, exty1.prm:  Increasing thread stack size from 196608 to 1048576.

2014-11-18 16:35:29  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, pmpy1.prm:  Socket buffer size set to 27985 (flush size 27985).

2014-11-18 16:35:29  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, pmpy1.prm:  No recovery is required for target file ./dirdat/y1000000, at RBA 0 (file not opened).

2014-11-18 16:35:29  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, pmpy1.prm:  Output file ./dirdat/y1 is using format RELEASE 11.2.