CNDBA社区
去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 这一行参数以后，问题 解决
版权声明：本文为博主原创文章，未经博主允许不得转载。
OGG-00685 begin time
