The
differences are
1. shutdown abort - is more drastic, no new
users are allowed to log in, disconnects current sessions without rollback,
recovery however would have to be done when restarted.
2.
shutdown immediate - no new users are allowed to log in, terminating current
connections, transactions terminated are rollbacked, recovery would
not happen at restart
3.
shutdown normal - no new users are allowed to log in, transactions in progress
are rollbacked, but would wait for all existing transactions to finish and users
to log off, so if a user is logged in when shutdown normal is executed, it would
wait forever.
So shutdown immediate is much quicker and safer.
...Ishrat
-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L
Subject: shutdown abort / startup restrict / shutdown vs. shutdown immedia> -----Original Message-----
> From: April Wells [mailto:[EMAIL PROTECTED]]
>
> The solutions (the ones that I got) aren't good ones.
>
> Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID
> solution'???)This might be a naive question, but why is
-> shutdown immediate
better than
-> shutdown abort / startup restrict / shutdown normal ?(That is assuming of course that no user / job will try to sneak in after you do the startup restrict)