Re: NT/2000 schedulable Process

Of course there are.... scripts. It was the statement that 'you will need to use ocopy...' that I was taking issue with.

And I still take issue with it: perhaps you could explain this little set of steps for me?

C:\Documents and Settings\howardjr>net use z: \\Mozart\Oracle\oracle\oradata The command completed successfully.

C:\Documents and Settings\howardjr>copy z:\db2\users01.dbf d:users01.bkp

        1 file(s) copied.

C:\Documents and Settings\howardjr>

1 file copied, and not a Ocopy in site. Just boring old copy. (Oh, and just for good measure, I then broke the database, restored the copy, and performed recovery, all just fine).
Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
news:kLVd8.28237$kX6.215672_at_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)

> > > > > >

> > > > > >

> > > > > >

> > > > > >

> > > > >

> > > > >

> > > >

> > > >

> > > >

> > >

> > >

> >

> >

> >

>

>