Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown abort hangs
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)
![]() |
![]() |