问题描述:OGG抓取进程异常报警OGG-00446 Could not find archived log,如下所示:
数据库:oracle 11.2.0.4
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' AND deleted = 'NO' AND name not like '+%' AND standby_dest = 'NO' >, error retrieving redo file name for sequence 14, archived = 1, use_alternat
e = 0Not able to establish initial position for sequence 14, rba 21462544.
2024-07-14 13:04:09 ERROR OGG-01668 PROCESS ABENDING.
2、解决方案
--查看线程与序列号
sys@TMIS> select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 29
--修改抓取进程的序列号和线程号
GGSCI (leo-oracle-11g) 2> alter extract exta,extseqno 30,thread 1,extrba 0
EXTRACT altered.
GGSCI (leo-oracle-11g) 3> start exta
Sending START request to MANAGER ...
EXTRACT EXTA starting
GGSCI (leo-oracle-11g) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED DPEA 00:00:00 425:20:01
EXTRACT RUNNING EXTA 00:00:00 00:00:01
3、后台日志
2024-07-14 13:17:53 WARNING OGG-01423 No valid default archive log destination directory found for thread 1.
2024-07-14 13:17:53 INFO OGG-01513 Positioning to Sequence 30, RBA 0, SCN 0.0.
2024-07-14 13:17:53 INFO OGG-01560 Positioned to Sequence 30, RBA 0, SCN 0.0.
2024-07-14 13:17:53 INFO OGG-01055 Recovery initialization completed for target file /home/oracle/ogg/dirdat/la000000, at RBA 1176.
2024-07-14 13:17:53 INFO OGG-01478 Output file /home/oracle/ogg/dirdat/la is using format RELEASE 11.2.
2024-07-14 13:17:53 INFO OGG-01026 Rolling over remote file /home/oracle/ogg/dirdat/la000000.
2024-07-14 13:17:53 INFO OGG-01053 Recovery completed for target file /home/oracle/ogg/dirdat/la000001, at RBA 1114.
2024-07-14 13:17:53 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
2024-07-14 13:17:53 INFO OGG-01517 Position of first record processed Sequence 30, RBA 1040, SCN 0.2026423, Jul 14, 2024 11:04:27 AM.
说明:此后抓取进程不在出现异常.