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

  • 相关阅读:
    第二季-专题11-世界一下变大了-MMU
    第二季-专题10-C语言环境初始化
    第二季-专题9--代码搬移不可少
    第二季-专题8-不用内存怎么行
    第二季-专题6-点亮指路灯
    第二季-专题7-ARM跑快了---时钟初始化
    第二季-专题5-核心初始化
    第二季-专题4-我是bootloader设计师
    消除苹果系统对边框的优化
    css3
  • 原文地址:https://www.cnblogs.com/hxlasky/p/12320898.html
Copyright © 2020-2023  润新知