Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
Kind Regards
Fraser McCallum
MVP Oracle Administration
www.brainbench.com
"Rom" <orom_at_systec.com> wrote in message
news:a5757b0132c_at_enews1.newsguy.com...
> Thanks for the answer.
> Thing is that I am about to create the backup scripts, but I don't have
any
> samples. do you have one by any chance?
>
> I mean, I made many of them on Unix, but NT is kinda new to me.
>
> Thanks,
> Ofer
>
>
> "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 - 12:05:47 CST