• 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.

  • 相关阅读:
    GdiPlus[34]: IGPGraphicsPath (一)
    GdiPlus[33]: 基本绘图与填充命令
    GdiPlus[29]: IGPPen: 虚线样式
    [征询意见]博客园logo
    [公告]网站恢复正常运行
    [公告]博客园将与博文视点合作推出一系列.NET图书
    [公告]由Bruce Zhang负责博客园的出书工作
    通过Windows Live Alerts订阅博客园首页RSS
    [征询意见]博客园新logo
    [新功能]新闻管理
  • 原文地址:https://www.cnblogs.com/hxlasky/p/12320898.html
Copyright © 2020-2023  润新知