Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: database could not be started

Re: database could not be started

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 14 Aug 2003 10:55:18 +0200
Message-ID: <bhfipn$d4s$1@news.fujitsu-siemens.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US