Re: Shutting down Oracle overnight...

   sd345_at_city.ac.uk (Michael Collier) writes:

> Here at City we perform a backup of the academic Oracle system by
> doing a shutdown every night and performing a dump.
>
> However if people leave Oracle processes running overnight the
> shutdown doesn't finish and the backup doesn't get done.
>
> So what I would like to do is a shutdown immediate each night.
>
> I have tried (in the dump script)...
>
> sqldba shutdown immediate
> sqldba "shutdown immediate"
> sqldba 'shutdown immediate'
>
> ...none of which do the trick. All that it ever seems to want to do is
> a plain old sqldba shutdown.
>
> Can anyone shed any light on this?
>
> Michael.
> --
> Michael Collier (Programmer) The Computer Unit,
> Email: M.P.Collier_at_uk.ac.city The City University,
> Tel: 071 477-8000 x3769 London,
> Fax: 071 477-8565 EC1V 0HB.

   Try putting "shutdown immediate;" (without quotes) into a file and    saying
   sqldba < yourfile

   --
   "See your System Administrator?" I *AM* the #%_at_!?& System Administrator!

   INTERNET: tumidity_at_netlink.cts.com (Joel Garry)    UUCP: ...!ryptyde!netlink!tumidity

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Software Engineer ...................... 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1 415.506.3390 .... Fax: +1 415.506.7299