Re: Scheduling backups NT4

From: Edwin Hartog <hartoge_at_logica.com>
Date: Thu, 9 Sep 1999 15:57:26 +0200
Message-ID: <7r8eca$5gj@romeo.logica.co.uk>

This example is for one instance. What to do if you're having about 6,7 instances ? Do I have to schedule this number of batch jobs or can I schedule one batch job for all these instances ? If this can be done in one batch job, somehow I have to use the "set ORACLE_SID=<new SID>", or not ?

TIA,
Edwin

Brian Peasland wrote in message <37D6A385.344B25B1_at_edcmail.cr.usgs.gov>...
>At another shop that I used to work at, we ran Oracle on NT. We did
>nightly backups (cold) of our database. I used the 'at' function to
>schedule a batch job to run at a certain time. The script that I ran did
>something like:
>
> signon with server manger
> shutdown database
> exit server manager
> use DOS copy commands to backup files (you can use any method here)
> signon with server manger
> startup database
> exit server manager
>
>That's it. If you don't like 'at', the Windows NT Resource Kit should
>have a Unix like 'cron' utility.
>
>HTH,
>Brian
Received on Thu Sep 09 1999 - 08:57:26 CDT