Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NT/2000 schedulable Process

Re: NT/2000 schedulable Process

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Sat, 23 Feb 2002 23:40:56 -0000
Message-ID: <kLVd8.28237$kX6.215672@NewsReader>


Howard, what happens if your sick.... no backups?

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a58o61$e8n$1_at_lust.ihug.co.nz...
> Odd. I do hot copies on Win2K and XP, simply by using Explorer, and doing
> the deed with my mouse. Just thought I'd mention it.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
> news:6RQd8.9386$jM1.71584_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.
> >
> > 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 - 17:40:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US