问题描述: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. 

说明:此后抓取进程不在出现异常.