Re: Scheduling backups NT4

We use Arcserve on our NT servers and as part of the pre/post scripts all databases are shutdown/restarted.

--
Terry Dykstra
Canadian Forest Oil Ltd.

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
>
>
>Edwin Hartog wrote:
>>
>> We are running several Oracle instances on an Windows NT4 server. We'd
like
>> to schedule backups for these instances. Which method can be used to do
this
>> backups ? I know it's possible to use the Windows NT schedule service to
do
>> this.
>> We'd like to have a NT archive script. Does anyone already have some
scripts
>> which can be scheduled to perform the backups or where can I get
information
>> for such scripts ?
>>
>> Is there any experienced Oracle consultant/DBA out there who can explain
the
>> steps to be taken to solve this "problem" ?
>>
>> TIA
>> ---
>>
>> Edwin H. Hartog
Received on Thu Sep 09 1999 - 09:52:07 CDT