Re: NT/2000 schedulable Process

"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message news:tOVd8.9919$jM1.77116_at_NewsReader...
> You will need to use Oracle's ocopy util if you are going to do hot
backups,
> this and various other backup options are covered in this otn article,
it's
> for 8.0.4 but it's still all OK info:
> http://technet.oracle.com/doc/windows/server.804/a55924/ch13.htm. Also you
> may need to subscribe to otn to get it but that's free and worthwhile.
Ocopy
> exists because NT's copy and xcopy won't copy open files and Oracle files
> during a hot backup are open.

But this simply isn't true, as I've just demonstrated (at least to my own satisfaction!) in another post in this thread (your comments on that still welcome). Plain ol' "copy" works just fine (as does, as I earlier mentioned, using explorer). I don't think I've ever used ocopy. Actually, I don't just 'don't think', I *know* I've never used it.

Regards
HJR
>It's also useful if you decide to put any
> files on RAW partitions as it can handle this.
>
> Kind Regards
>
> Fraser McCallum
> MVP Oracle Administration
> www.brainbench.com
>
> "Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
> news:qhgd8.21852$kX6.165104_at_NewsReader...
> > NT's equivalent of CRON is the AT command. That plus a script file with
> the
> > sqlplus and system commands in it should do the job. If it's an existing
> dB
> > check they probably have scripts for doing the backups etc, you could
get
> > some ideas from them.
> >
> > Regards
> >
> > Fraser McCallum
> > MVP Oracle Administration
> > www.brainbench.com
> >
> > "Rom" <orom_at_systec.com> wrote in message
> > news:a53unt01lgv_at_enews1.newsguy.com...
> > > Hi,
> > >
> > > Most of my work involves Unix servers, but now I have to prepare a
> process
> > > on NT.
> > > The process should log in to Oracle, execute one SQL statement, log
out,
> > > perform some system functions, log in again and execute another
> statement.
> > > I need this process to be schedulable.
> > >
> > > Is there an easy way to do that?
> > >
> > > Thanks for your help.
> > >
> > > Ofer Rom, DBA(OCP)
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
Received on Sat Feb 23 2002 - 18:06:27 CST