goldengate Not able to establish initial position for begin time

环境:

OS:Centos 7

DB:12c

extep报错如下

Source Context :
  SourceModule            : [er.redo.ora]
  SourceID                : [/scratch/aime/adestore/views/aime_adc00jza/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]
  SourceMethod            : [startCheckPointing]
  SourceLine              : [10485]
  ThreadBacktrace         : [14] elements
                          : []
                          : []
                          : [/goldengate12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/goldengate12c/extract()]
                          : [/goldengate12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [eading::MainThread::Run(int, char**))]
]
                          : [
                          : [/goldengate12c/extract()]
                          : [/goldengate12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)]
                          : [) [0x7b98e1]]
                          : [/goldengate12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
                          : [/goldengate12c/extract()]
                          : [/lib64/libc.so.6(__libc_start_main)]
                          : [/goldengate12c/extract()]

2020-02-17 11:14:55  ERROR   OGG-00446  error retrieving redo log sequence for begin time 2020-02-17 11:08:16.000000 Not able to establish initial position for begin time 2020-02-17 11:08:16.000000.

2020-02-17 11:14:55  ERROR   OGG-01668  PROCESS ABENDING.

解决办法:
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@localhost goldengate12c]$ sqlplus /nolog

SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 17 11:13:55 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/archlog
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1
SQL> alter system switch logfile;

System altered.

posted @   slnngk  阅读(791)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
点击右上角即可分享
微信分享提示