Re: "Thou shalt use 'Shutdown Abort' whenever you shutdown the database." Makes sense?

From: Miles Thomas <thomasm_at_"at".logica."dot".com>
Date: 1997/05/07
Message-ID: <01bc5aca$bf38de00$2d22ea9e_at_UKP01436.logica.co.uk>#1/1

Steve Phelan <stevep_at_pmcgettigan.demon.co.uk> wrote in article <33702D30.D2B07040_at_pmcgettigan.demon.co.uk>...
> > yes, I fully agree, shutdown normal is useless, shutdown immediate
> > is not
> > reliable... shutdown abort is the only option that does the job...
> >
> > --
> >

---

> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943
> > Geneva - Switzerland *
> > *******************************************
> >
> > "I am the one who steps from the shadows" - John Constantine
> >

---

> >
> > --
> >

---

> >
> > Nilo Segura Chinchilla * e-mail
> > nilo.segura_at_cern.ch
> > Computing and Network Division *
> > nilo_at_sundb02.cern.ch
> > European Laboratory for Particle Physics * phone +41 +22 7674943

> 
>  Sorry, I have to disagree here... :-)
> 
> We have a shell script which fires of every night without problem to
> perform our cold backups: It checks for connected Oracle sessions first,
> and kills off (with the *UNIX kill* command, and *not an Oracle kill
> session command*) any sessions it finds; it then pauses for 60 seconds,
> then performs a shutdown immediate. This script has worked fine for 4
> years on two different sites, both of which were UNIX based (HP-UX and
> AIX).
> 
> Steve Phelan.
> 
> 

O yes, indeed, a Unix kill -9 does work, as long as you are not using the Multi-threaded server: in which case you have no background processes to kill, and can only use Oracle kill sessions.

Also, on non-unix platforms (NT especially), you can't see the background processes to kill them off. Again, the only solution is a Oracle kill sessions.

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.

Received on Wed May 07 1997 - 00:00:00 CEST