OGG-00685 begin time <time> prior to oldest log in log history

今天早生产库的某个逻辑备库部署ogg同步几张表，报上述错误

去mos查询，得如下解决办法

APPLIES TO:

Oracle GoldenGate - Version 11.1.1.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

OGG-00685  begin time <time> prior to oldest log in log history. 

Last SQL executed 

<SELECT MAX(sequence#)   FROM (select sequence#     FROM v$log_history     

WHERE first_time < TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') AND     

RESETLOGS_CHANGE# LIKE :resetlogs_change_number AND   >.

CHANGES

A startup condition only.

CAUSE

This is a startup bug error where certain initial log positions are not resolved at initialization. 
This should happen only if the first log switching didn't occur after the db was created and before extract was started

It is bug ( 11839680).

SOLUTION

It is resolved by performing a database log switch.

Other causes and solutions:

If some of the nodes in RAC are not active, OGG will hit this error when trying to find the redo logs for those inactive nodes. 

The solution in this case is to exclude those inactive nodes from GG, e.g. THREADOPTIONS PROCESSTHREADS SELECT 1 

在extract 抽取文件中添加THREADOPTIONS PROCESSTHREADS SELECT 1 这一行参数以后，问题 解决