Re: shutdown scripts

From: Stephen Dance <steved_at_D1059kellock.co.uk>
Date: Fri, 18 Dec 1998 11:52:12 -0000
Message-ID: <75dfj5$r6f$1@flex.london.pipex.net>

I've just set up our 7.3.3 database (3 instances) to autoshutdown for cold backups.
I use AT (via the resource kit GUI) to run SHUTDOWN.BAT at a certain time Monday - Friday.
The batch files produce logs of the process so you can see any errors.

xxxx = the relevent internal passwords for each instance yyyy = instance identifiers
zzzz
wwww

SHUTDOWN.BAT
svrmgr23.exe @shutdown.sql > c:\log\shutdown.log

net stop oraclestartyyyy>> c:\log\shutdown.log
net stop oraclestartzzzz >> c:\log\shutdown.log
net stop oraclestartwwww >> c:\log\shutdown.log
net stop oracleserviceyyyy >> c:\log\shutdown.log

net stop oracleservicezzzz >> c:\log\shutdown.log net stop oracleservicewwww >> c:\log\shutdown.log

SHUTDOWN.SQL
connect internal/xxxxx @yyyy
shutdown immediate;
connect internal/xxxxx @zzzz
shutdown immediate;
connect internal/xxxxx @wwww
shutdown immediate;

To restart run
STARTUP.BAT

net start oraclestartyyyy > c:\log\startup.log
net start oraclestartzzzz>> c:\log\startup.log
net start oraclestartwwww >> c:\log\startup.log

--
To reply remove D1059

Ed Lufker wrote in message <75caft$hhm$1_at_sloth.swcp.com>...
>Hi All;
>
>
>
>
> Does anyone have database shutdown scripts that will run on an NT
>platform. Any examples of using at to schedule theses shutdowns????
>
>
>thanks in advance for any help here
>eddie lufker
Received on Fri Dec 18 1998 - 05:52:12 CST