Re: NT/2000 schedulable Process

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. 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 - 17:44:17 CST