shutdown immediate hangs after dissmount
ImixApr 6 2009 — edited Apr 6 2009we have an legacy system 9.2 which shutdowns for cold rman backup every night via cron. been running for years but 3 out of the last 6 runs the database hass hung during a shutdown immediate after the db has been dismounted.
any ideas why it is hanging.
(shutdown abort, startup shutdown immediate fixes the db but causing issues without backup)
from the alert log
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 6
Sat Apr 4 22:48:16 2009
alter database close
ORA-1109 signalled during: alter database close...
Sat Apr 4 22:48:16 2009
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
from a trace that is generated at the time:
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
28044
*** SESSION ID:(8.1) 2009-04-04 22:48:13.644
OPIRIP: Uncaught error 1089. Error stack:
ORA-01089: immediate shutdown in progress - no operations are permitted