Re: Calling dbshut for backup

Which Oracle version are you using?

I had the same problem on Oracle 8.0.5 64 bits on an HP-UX 11.00 machine, and I found an Oracle bulletin that said that the IMMEDIATE option has a bug and sometimes hangs.
I noticed that some instances don't have this problem whilke other instances on same machine do.

So I use the ABORT option, then startup in restricted mode and finally shutdown normal

Bye
Ermanno Giovanetto

Sam Jordan ha scritto nel messaggio <3743AD6D.5017AB38_at_spin.ch>...
>Hi
>
>I designed my backup scripts by looking at scripts of
>experienced db administrators. We are doing cold backups,
>so we have to shut down the db before storing all files.
>The backup script is run as cron job (under Linux) by the
>oracle user. The db is shut down using the 'dbshut' script
>which is in $ORACLE_HOME/bin.
>
>Now I have run into one problem: if a user is logged in to
>the db i.e. using sqlplus, then the backup script does hang.
>I quickly found out, that this was just because the shutdown
>command is called without 'immediate' parameter, so that the
>shutdown procedure waits for all users to log out.
>
>But the real surprise came, when I changed the shutdown command
>to 'shutdown immediate' and the script still hanged. After logging
>out of sqlplus the script immediately continued its work.
>
>Has anyone an explanation for this and a possible solution to the
>problem?
>
>bye
>--
>Sam Jordan
Received on Thu May 20 1999 - 03:48:32 CDT