Re: Shutting down Oracle overnight...

Sorry about my last post, which is empty...

tumidity_at_netlink.cts.com (Joel Garry) writes:
>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?
 

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

while this trick, or any other trick involving redirection, may work under UNIX, the portable solution should be

$ sqldba command=shutdown immediate

Thanks,

--
 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