Re: Guaranteed shutdown of Oracle

James Hanway <hanwayj_at_dfo-mpo.gc.ca> writes:

> You may want to do a SHUTDOWN IMMEDIATE rather then ABORT. IMMEDIATE
> does a cleaner shutdown
>
> Nabil Courdy wrote:
>
> > I need to know if experienced Oracle
> > DBAs agree with what I have done
> > to guarantee a shutdown of an Oracle
> > 8.1.5 instance on DEC-UNIX :
> >
> > 1) svrmgrl as internal
> > 2) shutdown abort
> > 3) startup restrict
> > 4) quit
> > 5) sleep 15
> > 4) svrmgrl as internal
> > 6) shutdown
> >
> > Is this good. The only part I am worried about
> > is the shutdown abort. Can it cause any undesirable
> > results?

In some cases SHUTDOWN IMMEDIATE can hang and your database will never shutdown. On the other hand SHUTDOWN ABORT should only be use when all else fails. Fortunately you are using UNIX so I think a better way to do it would be to write an expect script that first tries SHUTDOWN IMMEDIATE and looks for "instance shut down". Then set a timeout value like 10 or 15 minutes. If the operation times out then, and only then, issue a SHUTDOWN ABORT, start the database back up and issue a SHUTDOWN IMMEDIATE to make sure your database is clean. Your database is now down to do with whatever you need.

--
David F. Newman
Oracle DBA / Unix Admin
dnewman_at_ourvillage.com Received on Thu Nov 18 1999 - 09:53:00 CST