OGG-00446 Could not find archived log for sequence

0    204    1

Tags:

👉 本文共约12768个字,系统预计阅读时间或需48分钟。

前言部分

导读和注意事项

各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:

① OGG-00446 Could not find archived log for sequence 的解决方法(重点)

② OGG基本的维护、排错操作

本文简介

同事说有一套OGG的环境挂掉了,不能同步了,让处理一下,查看了进程状态和错误日志后分析得出是source端的归档日志不见了,也没有备份,最后只能重新初始化数据来解决了。

相关知识点扫盲

OGG的告警日志路径

ogg也有类似oracle的告警文件,该文件在 $OGG_HOME/ggserr.log

oracle@ZT1XPADRDB1:/gg/ogg$ l ggserr.log

-rw-rw-r-- 1 oracle dba 81355509 Jul 25 2025 ggserr.log

oracle@ZT1XPADRDB1:/gg/ogg$

故障分析及解决过程

故障环境介绍

项目source dbtarget db
db 类型rac环境rac环境
db version10.2.0.5.011.2.0.3.0
db 存储RAWASM
ORACLE_SIDoraXPADoraXPAD
db_nameoraXPADoraXPAD
主机IP地址:22.188.131.27 22.188.131.4722.188.132.82 22.188.132.85
OS版本及kernel版本AIX 5.3AIX 6.1
OS hostnameZTGXPADDB1ZT1XPADRDB1

故障发生现象及报错信息

source 端:

source端告警日志:

oracle@ZT1XPADRDB1:/gg/ogg$ tail -f ggserr.log

2020-08-03 07:47:27 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ggspump.prm: Socket buffer size set to 27985 (flush size 27985).

2020-08-03 07:47:27 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery initialization completed for target file ./dirdat/tt002073, at RBA 1153.

2020-08-03 07:47:27 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ggspump.prm: Output file ./dirdat/tt is using format RELEASE 10.4/11.1.

2020-08-03 07:47:27 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ggspump.prm: Rolling over remote file ./dirdat/tt002074.

2020-08-03 07:47:27 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery completed for target file ./dirdat/tt002074, at RBA 1119.

2020-08-03 07:47:27 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery completed for all targets.

2020-08-03 07:47:44 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ggsext.prm: 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 sequence 2598, archived = 1, use_alternate = 0Not able to establish initial position for sequence 2598, rba 89822224.

2020-08-03 07:47:44 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ggsext.prm: PROCESS ABENDING.

2020-12-29 15:37:48 ERROR OGG-01117 Oracle GoldenGate Command Interpreter for Oracle: Received signal: Program interrupt (2).

2020-12-29 15:37:48 ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.

target端告警日志:

oracle@ZT1XPADRDB1:/gg/ogg$ tail -f ggserr.log

2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.

2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.

2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.

2020-12-30 09:27:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.

2020-12-30 09:34:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start GGSREP.

2020-12-30 09:34:14 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 22.188.132.82 (START REPLICAT GGSREP ).

2020-12-30 09:34:14 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT GGSREP starting.

2020-12-30 09:34:14 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP starting.

2020-12-30 09:34:14 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP started.

2020-12-30 09:34:14 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: No unique key is defined for table RICH_CUSTPAYAMOUNTHIS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2020-12-30 09:34:14 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Aborted grouped transaction on 'XPADRPT.RICH_CUSTPAYAMOUNTHIS', Database error 1403 ().

2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.

2020-12-30 09:34:14 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: SQL error 1403 mapping XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.

2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.

2020-12-30 09:34:14 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Error mapping from XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.

2020-12-30 09:34:14 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: PROCESS ABENDING.

2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.

2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.

2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.

2020-12-30 09:37:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.

故障分析及解决过程

确认归档文件是否存在

根据报错信息,可以知道source端的thread 1 2598归档日志不存在了,如果备份存在的话可以先把备份的归档还原回来就可以了,我们看看归档是否存在?

oracle@ZTHXPADDB2:/oracle$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 30 08:50:48 2020

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

SQL> set line 9999

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------

1 1 2907 1072693248 1 NO CURRENT 1.2242E+13 30-DEC-20

2 1 2905 1072693248 1 YES INACTIVE 1.2242E+13 28-DEC-20

3 1 2906 1072693248 1 YES INACTIVE 1.2242E+13 29-DEC-20

4 2 2718 1072693248 1 YES INACTIVE 1.2242E+13 29-DEC-20

5 2 2719 1072693248 1 NO CURRENT 1.2242E+13 29-DEC-20

6 2 2717 1072693248 1 YES INACTIVE 1.2242E+13 28-DEC-20

6 rows selected.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /gg/sarch2

Oldest online log sequence 2717

Next log sequence to archive 2719

Current log sequence 2719

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTHXPADDB2:/oracle$ cd /gg/sarch2

oracle@ZTHXPADDB2:/gg/sarch2$ l

total 193332080

-rw-rw---- 1 oracle dba 1065581568 Mar 05 2020 2_2625_704996932.arc

-rw-rw---- 1 oracle dba 1065574400 Mar 06 2020 2_2626_704996932.arc

-rw-rw---- 1 oracle dba 1065574400 Mar 06 2020 2_2627_704996932.arc

-rw-rw---- 1 oracle dba 1065577472 Mar 07 2020 2_2628_704996932.arc

-rw-rw---- 1 oracle dba 1065568768 Mar 20 2020 2_2629_704996932.arc

-rw-rw---- 1 oracle dba 1065582592 Mar 21 2020 2_2630_704996932.arc

《《《《。。。。。。。。篇幅原因,有省略。。。。。。。。》》》》

-rw-rw---- 1 oracle dba 1065574400 Dec 23 13:06 2_2707_704996932.arc

-rw-rw---- 1 oracle dba 1065574400 Dec 24 00:26 2_2708_704996932.arc

-rw-rw---- 1 oracle dba 1065574912 Dec 24 13:15 2_2709_704996932.arc

-rw-rw---- 1 oracle dba 1065744384 Dec 25 02:23 2_2710_704996932.arc

-rw-rw---- 1 oracle dba 1065566208 Dec 25 19:23 2_2711_704996932.arc

-rw-rw---- 1 oracle dba 1065576960 Dec 26 09:08 2_2712_704996932.arc

-rw-rw---- 1 oracle dba 1065627648 Dec 26 23:21 2_2713_704996932.arc

-rw-rw---- 1 oracle dba 1065574400 Dec 27 12:25 2_2714_704996932.arc

-rw-rw---- 1 oracle dba 1065691648 Dec 28 04:32 2_2715_704996932.arc

-rw-rw---- 1 oracle dba 1065658368 Dec 28 21:02 2_2716_704996932.arc

-rw-rw---- 1 oracle dba 1065575936 Dec 29 10:37 2_2717_704996932.arc

-rw-rw---- 1 oracle dba 1067223552 Dec 29 23:22 2_2718_704996932.arc

-rw-r--r-- 1 oracle dba 79 Jun 27 2013 afiedt.buf

oracle@ZTHXPADDB2:/gg/sarch2$ l *1_2598*

ls: 0653-341 The file *1_2598* does not exist.

oracle@ZTHXPADDB2:/gg/sarch2$ cd /gg/sarch1

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!
OGG-00446 Could not find archived log for sequence后续精彩内容已被小麦苗无情隐藏,请输入验证码解锁本站所有文章!
验证码:
请先关注本站微信公众号,然后回复“验证码”,获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签:

Avatar photo

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

嘿,我是小麦,需要帮助随时找我哦。
  • 18509239930
  • 个人微信

  • DB宝
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部