Re: shutdown immediate not going , backup fail

SHUTDOWN IMMEDIATE can take some time to complete. So many people code their shutdowns as follows:

SHUTDOWN ABORT
STARTUP RESTRICT
SHUTDOWN IMMEDIATE The SHUTDOWN ABORT kills all active sessions and transactions. But the database needs some recovery, so the database is started and recovery is performed. The RESTRICT option ensures that no other sessions are started (provided you haven't granted RESTRICTED SESSION to non-DBA accounts). Then SHUTDOWN IMMEDIATE is performed to cleanly shutdown the database in preparation for your cold backup.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"