暂无图片
分享
周伟
2021-01-19
ORA-00312,ORA-00338 日志 2 (用于线程 1) 比控制文件更新

请教各位专家:

出现这个问题的数据库是一套11204的RAC, RHEL 7.7 平台。数据库暂时没有做RMAN备份,最近也没有做什么recovery动作,1号节点alert日志里面就出现下面的报错:

Errors in file /u01/app/oracle/diag/rdbms/hsrisk/hsrisk1/trace/hsrisk1_arc3_35722.trc:
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003’
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001’

trc 文件内容:

DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: ‘DB_STRUCTURE_INTEGRITY_CHECK’ (Async) -----
Successfully dispatched
----- END DDE Action: ‘DB_STRUCTURE_INTEGRITY_CHECK’ (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
DDE: Problem Key ‘ORA 312’ was flood controlled (0x1) (no incident)
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003’
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001’
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003’
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001’
logfile 2 header verification failed:338

实在想不明白,在没有做controlfile restore的情况下,怎么会出现 redo log 里面的状态信息比control file 里面的记录还要新呢?我尝试将redo进行了切换,是没有问题的,循环切换了一整偏都没问题。

收藏
分享
4条回答
默认
最新
周伟

添加一点发生这个问题的alert log:

Tue Jan 19 00:19:06 2021
Archived Log entry 6669 added for thread 1 sequence 4312 ID 0xb79403fb dest 1:
Tue Jan 19 00:19:17 2021
ORACLE Instance hsrisk1 - Cannot allocate log, archival required
Thread 1 cannot allocate new log, sequence 4314
All online logs need archiving
Examine archive trace files for archiving errors
Current log# 1 seq# 4313 mem# 0: +HSRISK_REDO/hsrisk/onlinelog/group_1.261.1045240301
Current log# 1 seq# 4313 mem# 1: +HSRISK_FLASH/hsrisk/onlinelog/group_1.257.1045240301
Tue Jan 19 00:19:32 2021
Archived Log entry 6671 added for thread 1 sequence 4311 ID 0xb79403fb dest 1:
Tue Jan 19 00:19:32 2021
Archived Log entry 6672 added for thread 1 sequence 4310 ID 0xb79403fb dest 1:
Tue Jan 19 00:19:32 2021
Thread 1 advanced to log sequence 4314 (LGWR switch)
Current log# 2 seq# 4314 mem# 0: +HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001
Current log# 2 seq# 4314 mem# 1: +HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003
Errors in file /u01/app/oracle/diag/rdbms/hsrisk/hsrisk1/trace/hsrisk1_arc3_35722.trc:
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003’
ORA-00338: 日志 2 (用于线程 1) 比控制文件更新
ORA-00312: 联机日志 2 线程 1: ‘+HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001’
Archived Log entry 6673 added for thread 1 sequence 4313 ID 0xb79403fb dest 1:
Tue Jan 19 00:19:47 2021
Thread 1 cannot allocate new log, sequence 4315
Checkpoint not complete
Current log# 2 seq# 4314 mem# 0: +HSRISK_REDO/hsrisk/onlinelog/group_2.256.1045240001
Current log# 2 seq# 4314 mem# 1: +HSRISK_FLASH/hsrisk/onlinelog/group_2.258.1045240003
Tue Jan 19 00:20:08 2021
Thread 1 advanced to log sequence 4315 (LGWR switch)
Current log# 7 seq# 4315 mem# 0: +HSRISK_REDO/hsrisk/onlinelog/group_7.262.1045241967
Current log# 7 seq# 4315 mem# 1: +HSRISK_FLASH/hsrisk/onlinelog/group_7.263.1045241967
Tue Jan 19 00:20:09 2021
Archived Log entry 6674 added for thread 1 sequence 4314 ID 0xb79403fb dest 1:
Tue Jan 19 00:33:15 2021
Thread 1 advanced to log sequence 4316 (LGWR switch)
Current log# 3 seq# 4316 mem# 0: +HSRISK_REDO/hsrisk/onlinelog/group_3.259.1045239977
Current log# 3 seq# 4316 mem# 1: +HSRISK_FLASH/hsrisk/onlinelog/group_3.259.1045239977
Tue Jan 19 00:33:15 2021
Archived Log entry 6675 added for thread 1 sequence 4315 ID 0xb79403fb dest 1:

从日志上看,有redo切换比较快,归档不及时的现象。日志切换很快的现象我经常碰到,但还是第一次碰到伴随 ORA-00338, ORA-00312的现象。

暂无图片 评论
暂无图片 有用 0
李真旭

请问是dataguard环境么?如果不是的话;可能命中bug了。

Bug 15931893 - ORA-338 may be written to the alert log on startup even though they are ignored (Doc ID 15931893.8)

暂无图片 评论
暂无图片 有用 0
周伟

@李真旭
谢谢回答,不是DG环境。这个错误是在数据库正常open运行的过程当中出现的。我也有找到一些描述,说是在redo切换过快的情况下,会导致controlfile的更新速度跟不上redo的切换速度,但是我从来没有见过在这样的情况下,会报这种错误的。

暂无图片 评论
暂无图片 有用 0
周伟
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
手机用户6579
2023-06-05
怎么解决的呢
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏