OGG-00685 goldengate 啟動報錯 (日誌沒有切換形成歸檔導致)

OGG-00685
2011-12-31 10:11:35  INFO    OGG-01515  Positioning to begin time Dec 31, 2011 9:57:11 AM.

Source Context :
  SourceModule            : [er.redo.ora.metathr]
  SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34090]/perforce/src/app/er/redo/oracle/ocimetathr.c]
  SourceFunction          : [OCIMETATHR_get_sequence]
  SourceLine              : [848]
  ThreadBacktrace         : [13] elements
                          : [/u01/ggs/extract(CMessageContext::AddThreadContext()+0x26) [0x840b3f6]]
                          : [/u01/ggs/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x817) [0x8401b57]]
                          : [/u01/ggs/extract(_MSG_ERR_ORACLE_OLDER_LOGS_MISSING(CSourceContext*, timeval, char const*, CMessageFactory::MessageDisposition)+
0x8b) [0x83bebfb]]
                          : [/u01/ggs/extract(OCIMETATHR_get_sequence(OCIMETATHR_context_t*, short, long long, char*, unsigned int*, int*)+0x1d3) [0x82e7853]
]
                          : [/u01/ggs/extract [0x83455d8]]
                          : [/u01/ggs/extract [0x83469b1]]
                          : [/u01/ggs/extract(REDOORARDR_get_log_position(log_context_t*, log_cursor_t*, long long, unsigned int, long long, unsigned int*, l
ong long*, char*, char*)+0x4c5) [0x8354435]]
                          : [/u01/ggs/extract(REDO_position(void*, int, char*)+0x28c) [0x82eb49c]]
                          : [/u01/ggs/extract(START_EXTRACT_CHECKPOINT(chkpt_context_t*, char*, char*, char*, short, int, int, int, char*, short, short, shor
t)+0x20a) [0x812219a]]
                          : [/u01/ggs/extract [0x8172814]]
                          : [/u01/ggs/extract(main+0x68e) [0x819d32e]]
                          : [/lib/tls/libc.so.6(__libc_start_main+0xd3) [0x2fbde3]]
                          : [/u01/ggs/extract(__gxx_personality_v0+0x1c5) [0x8114ac1]]

2011-12-31 10:11:35  ERROR   OGG-00685  begin time Dec 31, 2011 9:57:11 AM prior to oldest log in log history. Last SQL executed M (select sequence#     FROM v$log_history     WHERE first_time < TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') AND     RESETLOGS_CHANGE# LIKE :resetlogs_chan
ge_number AND   >.

原因很簡單，因為資料庫剛resetlog過，比如 redo01，redo02，redo03 三個online log，
切換日誌幾次就能start EXTRACT ext1

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

GoldenGate：

GGSCI (MyOracle) 9> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting

GGSCI (MyOracle) 10> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT1        00:00:00      00:15:34    
REPLICAT    STOPPED     REP1        00:00:00      00:05:25