------------------------------------------------------ 环 境:windows xp+oracle 8.1.7.0.0 机 器:1.8GHZ+256M 数据库:www(无生产数据,默认安装,应该不大) 问 题: 在DBA Studio中shutdown immediate,花了7,8个小时还是没有关掉. ------------------------------------------------------- oracle_home\admin\sid\udump的跟踪文件: *** SESSION ID:(23.5121) 2003-11-19 11:25:26.859 SHUTDOWN: waiting for detached processes to terminate. *** 2003-11-19 11:30:36.609 SHUTDOWN: waiting for detached processes to terminate. *** 2003-11-19 11:35:46.218 SHUTDOWN: waiting for detached processes to terminate. *** 2003-11-19 11:40:55.843 ... SHUTDOWN: waiting for detached processes to terminate. *** 2003-11-19 19:41:02.609 SHUTDOWN: waiting for detached processes to terminate.oracle_home\admin\sid\bdump的警告日志文件sidAlert.ora: ... Shutting down instance (immediate) License high water = 21 Wed Nov 19 11:20:02 2003 ALTER DATABASE CLOSE NORMAL Wed Nov 19 11:20:03 2003 SMON: disabling tx recovery SMON: disabling cache recovery Wed Nov 19 11:20:10 2003 Thread 1 closed at log sequence 1382 Wed Nov 19 11:20:11 2003 Completed: ALTER DATABASE CLOSE NORMAL Wed Nov 19 11:20:12 2003 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT archiving is disabled Wed Nov 19 11:25:26 2003 SHUTDOWN: waiting for detached processes to terminate. ...在7,8个小时内,CPU100%,没有办法,后来只好重启,机器重启后数据库还是open的. 看上面的日志,数据库好象早就关了,但跟踪文件的提示又是怎么回事? 我现在连shutdown都不成功,该怎么办,用shutdown abort嘛,怕startup很花时间. 是不是在shutdown前还有些工作要做?不懂.
试试:
强制启动:startup force
强制关闭:shutdown immediate参考:
http://www.oradb.net/dba/dba_035.htm
是因为数据库认为还有连接,ORACLE会等待所有的连接段开,才会关闭。
环 境:windows xp+oracle 8.1.7.0.0
机 器:1.8GHZ+256M
数据库:www(无生产数据,默认安装,应该不大)
问 题:
在DBA Studio中shutdown immediate,花了7,8个小时还是没有关掉.
-------------------------------------------------------
oracle_home\admin\sid\udump的跟踪文件:
*** SESSION ID:(23.5121) 2003-11-19 11:25:26.859
SHUTDOWN: waiting for detached processes to terminate.
*** 2003-11-19 11:30:36.609
SHUTDOWN: waiting for detached processes to terminate.
*** 2003-11-19 11:35:46.218
SHUTDOWN: waiting for detached processes to terminate.
*** 2003-11-19 11:40:55.843
...
SHUTDOWN: waiting for detached processes to terminate.
*** 2003-11-19 19:41:02.609
SHUTDOWN: waiting for detached processes to terminate.oracle_home\admin\sid\bdump的警告日志文件sidAlert.ora:
...
Shutting down instance (immediate)
License high water = 21
Wed Nov 19 11:20:02 2003
ALTER DATABASE CLOSE NORMAL
Wed Nov 19 11:20:03 2003
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Nov 19 11:20:10 2003
Thread 1 closed at log sequence 1382
Wed Nov 19 11:20:11 2003
Completed: ALTER DATABASE CLOSE NORMAL
Wed Nov 19 11:20:12 2003
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Wed Nov 19 11:25:26 2003
SHUTDOWN: waiting for detached processes to terminate.
...在7,8个小时内,CPU100%,没有办法,后来只好重启,机器重启后数据库还是open的.
看上面的日志,数据库好象早就关了,但跟踪文件的提示又是怎么回事?
我现在连shutdown都不成功,该怎么办,用shutdown abort嘛,怕startup很花时间.
是不是在shutdown前还有些工作要做?不懂.
但据高手说:这样oracle数据库是以相当于(shutdown abort)方式关闭的,好象不是很好!