Re: Fwd: How to shutdown 9i?

there's always the "worst case scenario" -- if you are sure you have good backups and can recover from them, just bring down the server without shutting down Oracle -- this is, after all, one of the scenarios Oracle recovery is designed to handle.

Before trying that, I would attempt to get in via sqlplus, as Paula suggested. However, instead of a shutdown immediate, I would do a shutdown abort -- shutdown immediate can still hang, waiting for a process to finish.

On 6/14/05, Paula_Stankus_at_doh.state.fl.us <Paula_Stankus_at_doh.state.fl.us> w= rote:
> if you can connect through sql plus as sysdba you should be able to do a =
shutdown immediate
> Also oracle does do instance recovery applying all of the online redo log=
 information before it opens the database if the database does not open gra= cefully
>=20
> Still get a good backup first making sure to archive your redo and backup=
 your archives would ensure 0 data loss
>=20
> Carel's questions about archives when a backup will be as well as questio=
ns of ensuring your application, batches and backups are not hitting the db=  at the same time ensures a fallback plan
> --------------------------
> Sent from my BlackBerry Wireless Handheld
>=20
>

--
http://www.freelists.org/webpage/oracle-l