Re: NT/2000 schedulable Process

OK fine it works for you, I was commenting based on some very old experience! Way back when I first did a hot backup of Oracle on NT version 3.x the backup scripts written by our NT support people using xcopy failed! So I looked up the Oracle manual and it said use ocopy.... the current 8.1.7 manual still has this advice and so I naturally assumed it was current. Perhaps MS fixed their copy stuff in a version/patch since and never told Oracle.

BTW I'm curious, are you updating the contents of your files while doing these hot backups as that was where our problems were occurring? Also where in NZ are you? I'm from Wellington originally.

:)

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a59agd$tnd$1_at_lust.ihug.co.nz...
> 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)
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>
Received on Sat Feb 23 2002 - 18:46:32 CST