问题描述: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.
说明:此后抓取进程不在出现异常.
- 1.
- 2.
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9.
- 10.
- 11.
- 12.
- 13.
- 14.
- 15.
- 16.
- 17.
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26.
- 27.
- 28.
- 29.
- 30.
- 31.
- 32.
- 33.
- 34.
- 35.
- 36.
- 37.
- 38.
- 39.
- 40.
- 41.
- 42.
- 43.
- 44.
- 45.
- 46.
- 47.
- 48.
- 49.
- 50.
- 51.
- 52.
- 53.
- 54.
- 55.
- 56.
- 57.
- 58.
- 59.
- 60.
- 61.