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: Shutdown abort hangs

Re: Shutdown abort hangs

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 25 Dec 1998 16:47:08 GMT
Message-ID: <36839784.13593817@news.siol.net>


On Wed, 23 Dec 1998 13:48:33 -0700, "Terry Dykstra" <tdykstra_at_cfol.ab.ca> wrote:

>Stopping the service will bring down everything. The annoying thing is that
>it's just a random problem. It will work 99 out of 100 times. The shutdown
>abort is part of my backup script: "shutdown abort, startup, shutdown" to
>ensure a clean database before backup.

Don't know why "shutdown abort" doesn't work in your case, but wouldn't the "shutdown immediate" put a database in the exactly the same clean state as "shutdown abort, startup, shutdown"? And it would finish the task more quickly as there would be no extra instance starting and database mounting/opening. And with the "shutdown immediate" the whole process is under the control of Oracle RDBMS all the way, while with "shutdown abort" it is not.

Regards,

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Dec 25 1998 - 10:47:08 CST

Original text of this message

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