Shutdown immediate hangs with message "WARNING: aiowait timed out x times" [message #632252] |
Wed, 28 January 2015 06:36 |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
Hi,
I have a database that has some important data in it. In this DB , by mistake I ran an import of a huge 69 million rows table. It ran out of UNDO tablespace. I killed import. But then I saw that the table was shown as 'locked' in the v$locked_object. Thereafter I checked the os 'spid' of this session and killed that spid on Solaris. That freed up the object. But then I found that my instance had terminated. When I tried to open the instance, it gave ORA-600 and it did not open. So I tried 'shutdown immediate'. On this command it is hanging for more than one hour with following messages in alert log:
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 33
Wed Jan 28 05:52:35 2015
Active call for process 5424 user 'oracle' program 'oracle@db4 (P004)'
Active call for process 5426 user 'oracle' program 'oracle@db4 (P005)'
Active call for process 5455 user 'oracle' program 'oracle@db4 (P019)'
Active call for process 5459 user 'oracle' program 'oracle@db4 (P021)'
Active call for process 5467 user 'oracle' program 'oracle@db4 (P025)'
Active call for process 5477 user 'oracle' program 'oracle@db4 (P030)'
SHUTDOWN: waiting for active calls to complete.
Wed Jan 28 05:56:08 2015
WARNING: aiowait timed out 1 times
Wed Jan 28 06:06:08 2015
WARNING: aiowait timed out 2 times
Wed Jan 28 06:16:08 2015
WARNING: aiowait timed out 3 times
Wed Jan 28 06:26:08 2015
WARNING: aiowait timed out 4 times
Wed Jan 28 06:36:08 2015
WARNING: aiowait timed out 5 times
Can someone please suggest on how to fix/troubleshoot the issue? I don't have any backup unluckily!!
Thanks,
OrauserN
[Updated on: Wed, 28 January 2015 06:37] Report message to a moderator
|
|
|