MMNL absent for 28312 secs; Foregrounds taking over

由于TSM 备份挂起(失败了) ,发现ALERT 里有如下的日志

Wed Mar 28 09:00:00 2007
MMNL absent for 28312 secs; Foregrounds taking overWed Mar 28 09:00:26 2007
Thread 1 advanced to log sequence 4593
Current log# 2 seq# 4593 mem# 0: /dev/rlvredo21_1g
Current log# 2 seq# 4593 mem# 1: /dev/rlvredo22_1g
Wed Mar 28 09:01:18 2007

在METALINK 上查找了一下,给出的结果虽然不完全相同,但还是参考一下

[@more@]

SQL*Plus Connection Fails With Ktsmg_update_mql(): Mmnl Absent For 1201 Secs; Foregrounds Taking Over
	文档 ID:	注释:340663.1	类型:	PROBLEM
	上次修订日期:	01-MAR-2006	状态:	REVIEWED

In this Document
Symptoms
Cause
Solution
References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.3.0
This problem can occur on any platform.

Symptoms

Cannot connect to the instance from sqlplus as any user

Messages:

Wed Nov 9 11:53:47 2005
ALTER SYSTEM SET fast_start_mttr_target=3600 SCOPE=MEMORY;
Wed Nov 9 11:54:03 2005
MTTR advisory is disabled because either FAST_START_IO_TARGET or
LOG_CHECKPOINT_INTERVAL is set
Wed Nov 9 11:54:07 2005
ALTER SYSTEM SET fast_start_mttr_target=1200 SCOPE=MEMORY;
Wed Nov 9 12:23:44 2005
KTSMG_UPDATE_MQL(): MMNL absent for 1201 secs; Foregrounds taking over

Cause

Bug 3364646 Ora-600 [Kebm_Mmon_Main_1], [12805]

Unpublished bug with fix in 10.2 and backport to 10.1.0.4.

Solution

To implement the workaround, please execute the following steps:

1. Kill -9 smon
2. Check for memory segments: sysresv
Review Note 123322.1 on how to use this command
3. Startup
4. Check alertlog for errors
5. Query database for normal function.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7318139/viewspace-907213/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7318139/viewspace-907213/