Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database could not be started
"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> schrieb im Newsbeitrag
news:82E_a.18089$Ea.7339_at_fe03.atl2.webusenet.com...
> Ok. But, "for the record"...
>
> You say a "Shutdown abort, startup restrict, shutdown immediate." should
> always handle a clean shutdown...
>
> (1) According to the 8.1.7 docs, the 2nd step of "crash recovery" is -
> "Opening the database. Instead of waiting for all transactions to be
rolled
> back before making the database available, Oracle allows the database to
be
> opened as soon as cache recovery is complete" . Actually, looks like a
> type-o there ... "cache" instead of "crash".
>
> The "crash recovery" should happen automatically when you startup after a
> shutdown abort - correct? So, this process is actually occurring in the
> background when you would be issueing a shutdown immediate? This sounds
> like a potential problem?
At least on 9i it isn't. I did that already. You startup and then the
shutdown
immediate completes only after the recovery and rollbacks are completed,
which can take a long time.
Lots of Greetings!
Volker
Received on Thu Aug 14 2003 - 03:55:18 CDT