纠结了两天OGG 错误~实在是找不到解决办法~请指教

yzm1987

系统环境：linux CentOS 64bit
数据库环境：oracle 11G 11.2.3

之前按照官方文档，一切都正常配置。但到最后执行

GGSCI (single) 32> start extract ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (single) 33> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     STOPPED     EXT1        00:00:00      02:47:36   

始终不能start 状态。查询日志
2013-07-13 08:09:06  ERROR   OGG-00685  Oracle GoldenGate Capture for Oracle, ext1.prm:  begin time Jul 13, 2013 5:21:30 AM prior to oldest log in log history. Last SQL executed <SELECT 1   FROM dual  WHERE TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') <    (SELECT MIN(first_time)       FROM v$log_history      WHERE thread# = :ora_thread)>.
2013-07-13 08:09:06  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.
2013-07-17 10:17:13  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop *.

在网上查询资料，说什么需要切换日志，因为资源库与目标库 archivelog 不统一。后来执行
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

完了以后，继续执行
GGSCI (single) 32> start extract ext1
还是起不了，日志中查询一直报 OGG-00685 错误。

yzm1987

今天按照上述方法试了一下，结果还是不行。

源端 ggserr.log
2013-07-18 04:49:17  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, ext1.prm:  No valid default archive log destination directory found for thread 1.
2013-07-18 04:49:20  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, ext1.prm:  Positioning to begin time Jul 13, 2013 5:21:30 AM.
2013-07-18 04:49:20  ERROR   OGG-00685  Oracle GoldenGate Capture for Oracle, ext1.prm:  begin time Jul 13, 2013 5:21:30 AM prior to oldest log in log history. Last SQL executed <SELECT 1   FROM dual  WHERE TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') <    (SELECT MIN(first_time)       FROM v$log_history      WHERE thread# = :ora_thread)>.
2013-07-18 04:49:20  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.

OGG-01423 看了一下，说要打开补充日志
SQL> Select                                                         
  2  SUPPLEMENTAL_LOG_DATA_MIN
  3  ,SUPPLEMENTAL_LOG_DATA_PK
  4  ,SUPPLEMENTAL_LOG_DATA_UI
  5  ,SUPPLEMENTAL_LOG_DATA_FK
  6  ,SUPPLEMENTAL_LOG_DATA_ALL from v$database;

SUPPLEMENTAL_LOG_DATA_MI SUPPLEMEN SUPPLEMEN SUPPLEMEN SUPPLEMEN
------------------------ --------- --------- --------- ---------
YES                      NO        NO        NO        NO

源端配置的参数文件
GGSCI (single) 39> edit params ext1

extract ext1
userid ogguser@TARGET, password ogguser
rmthost target, mgrport 7809
rmttrail /oracle/ggate/dirdat/lt
ddl include mapped objname sender.*;
table sender.*;


目标端
GGSCI (target) 23> view report rep1
***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
    Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:48:07

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


                    Starting at 2013-07-31 04:11:37
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Thu Sep 3 03:28:30 EDT 2009, Release 2.6.18-164.el5
Node: target
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 8179

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2013-07-31 04:11:37  INFO    OGG-03035  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
replicat rep1
HANDLECOLLISIONS
ASSUMETARGETDEFS
userid ogguser@SINGLE,password *******
discardfile /u01/app/oracle/ggs/dirdat/rep1_discard.txt, append, megabytes 10
DDL INCLUDE ALL
DDERROR DEFAULT IGNORE RETRYOP

Source Context :
  SourceModule            : [ggdb.ora.db]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/ggdbora/dboci.c]
  SourceFunction          : [odbc_param]
  SourceLine              : [1384]
  ThreadBacktrace         : [8] elements
                          : [/u01/app/oracle/ggs/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b214b8e106e]]
                          : [/u01/app/oracle/ggs/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int,
...)+0x2cc) [0x2b214b8dd44c]]
                          : [/u01/app/oracle/ggs/libgglog.so(_MSG_ERR_STARTUP_PARAM_UNRECOGNIZED(CSourceContext*, char con
st*, CMessageFactory::MessageDisposition)+0x31) [0x2b214b8d19d3]]
                          : [/u01/app/oracle/ggs/replicat(odbc_param(char*, char*)+0x7b5) [0x5f6125]]
                          : [/u01/app/oracle/ggs/replicat(get_infile_params(time_elt_def*, time_elt_def*, char**)+0x1352)
[0x522192]]
                          : [/u01/app/oracle/ggs/replicat(main+0x117) [0x548137]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x390e61d994]]
                          : [/u01/app/oracle/ggs/replicat(__gxx_personality_v0+0x322) [0x4be48a]]

2013-07-31 04:11:38  ERROR   OGG-00014  Unrecognized parameter: DDERROR. Parameter could be misspelled or unsupported.

2013-07-31 04:11:38  ERROR   OGG-01668  PROCESS ABENDING.


目标段参数文件
GGSCI (target) 25> edit params rep1

replicat rep1
HANDLECOLLISIONS
ASSUMETARGETDEFS
userid ogguser@SINGLE,password ogguser
discardfile /u01/app/oracle/ggs/dirdat/rep1_discard.txt, append, megabytes 10
DDL INCLUDE ALL
DDERROR DEFAULT IGNORE RETRYOP
map sender.*,target receiver.*;

目标端补充日志
SQL> Select                                                         
  2  SUPPLEMENTAL_LOG_DATA_MIN
  3  ,SUPPLEMENTAL_LOG_DATA_PK
  4  ,SUPPLEMENTAL_LOG_DATA_UI
  5  ,SUPPLEMENTAL_LOG_DATA_FK
  6  ,SUPPLEMENTAL_LOG_DATA_ALL from v$database;

SUPPLEMENTAL_LOG_DATA_MI SUPPLEMEN SUPPLEMEN SUPPLEMEN SUPPLEMEN
------------------------ --------- --------- --------- ---------
YES                      NO        NO        NO        NO


现在有点想再重新配置一边了~~不知道是哪里出了问题。