Re: Best Way to Shutdown?

well the types have been thrown around but this is what I use: SHUTDOWN IMMEDIATE, then a STARTUP RESTRICT then a SHUTDOWN NORMAL, then do the backup.

It has not failed me after 4 years of doing it. What you dont want to do it a shutdown abort and then do a backup, for the database is "not" in a consistent state, now we will watch the arguments begin about consistent state.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the
FREE, drop column script
ICQ UIN:  2832230(&oracle, home).