shutdown immediate长期等待,我该怎么办?

显示全部楼层 · 2005-10-30 17:05:33

警告日志中显示:SHUTDOWN: waiting for active calls to complete.
我该怎么办,有没有办法手工结束active calls
说明:以前有一个查询一直占用CPU,KILL的话几天状态也为KILLED,到操作系统上才能KILL掉,现在这个查询又出现了,我就shutdown immediate,谁知几个小时过去都不能SHUTDOWN,我该怎么办才能不影响明天的运行?重新启动操作系统肯定不可能.

千问 · 2005-10-30 17:05:33

kill掉它啊。
shutdown abort呢？
startup force呢？

千问 · 2005-10-30 17:05:33

shutdown abort

千问 · 2005-10-30 17:05:33

最初由 fusnow 发布
[B]shutdown abort [/B]
小心启不来哦

千问 · 2005-10-30 17:05:33

最初由 Toms_zhang 发布
[B]
小心启不来哦

[/B]
运气不会那么差的吧

千问 · 2005-10-30 17:05:33

最初由 fusnow 发布
[B]
运气不会那么差的吧

[/B]
不管什么故障，只要数据库还在运行中，就比较容易解决，起不来就比较头疼了！不怕一万，就怕万一！

千问 · 2005-10-30 17:05:33

shutdown abort俺碰到过一次启不来

千问 · 2005-10-30 17:05:33

现在已经进入shutdown immediate过程了，新的会话是连接不进来的。你当前的会话还有事务没有结束，而且这个事务看样子执行的时间将会很长。。。我认为你现在唯一能做的，就是到操作系统下把oracle 服务进程强行杀掉。killl -9 spid进程杀了，shutdown immediate应该会很快结束的。这样试试吧，祝你好运。

千问 · 2005-10-30 17:05:33

生产库还是不要shutdown abort比较好，否则起不来就不好玩了

千问 · 2005-10-30 17:05:33

To shut down a database immediately, use the SHUTDOWN command with the IMMEDIATE clause:
SHUTDOWN IMMEDIATE
Immediate database shutdown proceeds with the following conditions:
No new connections are allowed, nor are new transactions allowed to be started, after the statement is issued.
Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
Oracle Database does not wait for users currently connected to the database to disconnect. The database implicitly rolls back active transactions and disconnects all connected users.
The next startup of the database will not require any instance recovery procedures.