Re: shutdown mmediate gets hung

hpuxrac wrote:
> Prem, my first advice is to think about taking an oracle course like
> database fundamentals 1.
>
> Why do you shutdown your database every sunday? Is it for a cold
> backup?
>
> Shutdown abort normally doesn't cause problems that oracle instance
> recovery cannot deal with but most oracle dba's reserve using it only
> when absolutely necessary.
>
> When is it necessary? Usually only when a shutdown immediate is
> hanging for some reason.
>
> No you should not change a startup to a startup restrict blindly
either.

As you have pointed out reason for shutting down database is for "cold" backup.

Reason for using shutdown abort is not to wait indefintely for shutdown to happen late in the night if some process is connected to database. If I am not mistaken, Oracle recommends this procedure: shudtown abort, startup, shutdown immediate when one is trying to put shudtown script for automatc shutdown during system reboots etc. Script has always woked fine, problem hapened this Sunday. Received on Mon Jan 31 2005 - 16:41:27 CST