由于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.0This problem can occur on any platform.
Symptoms
Cannot connect to the instance from sqlplus as any userMessages:
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/