博主遇到Oracle 11G数据库在每天凌晨2点自动关闭并重启的问题。根据alert日志，该现象可能与Resource Manager计划和自动SQL调优任务有关。文中寻求解决方案，涉及的日志切换、后台进程活动和数据库关闭过程被详细记录。
各位大牛，求帮助！oracle 11G新安装的库，安装时选择了自动备份。现在到了凌晨2:00，oracle实例就自动关闭再启动。求原因及解决办法！以下是alert:
Mon Oct 21 22:00:00 2013
Setting Resource Manager plan SCHEDULER[0x3189]
EFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Oct 21 22:00:00 2013
Starting background process VKRM
Mon Oct 21 22:00:00 2013
VKRM started with pid=19, OS id=28698
Mon Oct 21 22:00:02 2013
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Mon Oct 21 22:00:25 2013
Thread 1 cannot allocate new log, sequence 8
Private strand flush not complete
Current log# 1 seq# 7 mem# 0: /oracle/oradata/ifeng/redo01.log
Thread 1 advanced to log sequence 8 (LGWR switch)
Current log# 2 seq# 8 mem# 0: /oracle/oradata/ifeng/redo02.log
Mon Oct 21 22:01:17 2013
XDB installed.
XDB initialized.
Mon Oct 21 22:01:43 2013End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue Oct 22 00:33:37 2013Thread 1 cannot allocate new log, sequence 9
Private strand flush not complete
Current log# 2 seq# 8 mem# 0: /oracle/oradata/ifeng/redo02.log
Thread 1 advanced to log sequence 9 (LGWR switch)
Current log# 3 seq# 9 mem# 0: /oracle/oradata/ifeng/redo03.log
Tue Oct 22 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler windowClearing Resource Manager plan via parameter
Tue Oct 22 02:00:31 2013
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Tue Oct 22 02:00:33 2013
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 17
Stopping Job queue slave processes, flags = 7Job queue slave processes stopped
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Tue Oct 22 02:00:37 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Oct 22 02:00:37 2013
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 9
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
扫一扫
2447
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
