Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling backups NT4
One way would be to use the 'net stop' and 'net start' commands to
shutdown/startup the instances in your batch file. These commands let you
start/stop pretty much any NT service you want. You can easily shutdown
all 6 or 7 this way.
Jason
Edwin Hartog <hartoge_at_logica.com> wrote in message
news:7r8eca$5gj_at_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 - 10:03:18 CDT