今天早生产库的某个逻辑备库部署ogg同步几张表,报上述错误
去mos查询,得如下解决办法
APPLIES TO:
Oracle GoldenGate - Version 11.1.1.0.0 and laterInformation 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 这一行参数以后,问题 解决