2020-08-03 07:47:44 ERROR OGG-00446 Could not find archived log for sequence 2598 thread 1 under alternative destinations. SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>. Last alternative log tried /gg/sarch2/1_2598_704996932.arc, error retrieving redo file name for...
1、异常重现 2024-07-14 13:04:09 ERROR OGG-00446 Could not find archived log for sequence 14 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AN...
在Oracle中,OGG-00446 Could not find archived log for sequence错误的处理办法是什么? ♣ 答案部分 如果面试官问到维护OGG曾经碰到的一次故障处理过程,那么就可以拿这个错误作为案例来说明。OGG-00446主要是归档文件丢失引起,处理办法就是将缺失的归档日志找回来。如果找不到所需归档日志,那么可以按照如下2种办法...
【故障解决】OGG-00446 错误解决 简介:【故障解决】OGG-00446 Could not find archived log for sequence 一.1 BLOG文档结构图 一.2 前言部分 一. 【故障解决】OGG-00446 Could not find archived log for sequence 一.1BLOG文档结构图 一.2前言部分 一.2.1导读和注意事项 各位技术爱好者,看完本文后,你可以...
OGG-00446 Could not find archived log for sequence 12 thread 1 under default 1. 这个错误通常是由于GoldenGate无法找到指定序列和线程下的归档日志而引起的。本文将详细介绍解决这个问题的步骤和相关代码。 解决步骤 下面是解决OGG-00446错误的步骤,可以用表格形式展示: ...
OGG 的一些错误编号,包含了很多种不同的原因。00446 就是这样的一种,不同的原因有不同的提示。本文包含两种: Missing filename opening checkpoint file could not find archived log 下面看分析与解决方法。 1.1Missing filename opening checkpoint file
28ERROROGG-00446Oracle GoldenGate CaptureforOracle,lxjy1.prm:Could not find archived logforsequence160thread1underdefaultdestinationsSQL<SELECTnameFROMv$archived_logWHEREsequence#=:ora_seq_noANDthread#=:ora_threadANDresetlogs_id=:ora_resetlog_idANDarchived='YES'ANDdeleted='NO'ANDname not like'+%'...
OGG-00446也指明了Could not find archived log for sequence 144299 thread 1,我们将故障点以后的ogg进行移回归档目录操作。 因为脚本是用root跑的,权限也都有所改变。再将权限重新赋给oracle用户和它的属组 root@SIDDB01 # cd /oracle/oradata/archlog/sidarchlog/ ...
alternate = 0Not able to establish initial position for sequence 144299, rba 243031568. OGG-00446也指明了Could not find archived log for sequence 144299 thread 1,我们将故障点以后的ogg进行移回归档目录操作。 因为脚本是用root跑的,权限也都有所改变。再将权限重新赋给oracle用户和它的属组 ...
2015-06-0519:19:12 ERROR OGG-00446 Could not find archived log forsequence 34 thread 1 under alternative destinations. SQL <>.Last alternative log tried/mnt/tianbaobao/archdata/1_34_876139873.dbf. Failed to open redofile /mnt/tianbaobao/archdata/1_34_876139873.dbf for sequence 34during ...