Re: NT/2000 schedulable Process

Would love to catch up in that case... you are only across the Tasman (or I am!), 'cause this is Sydney calling!!

I confess that originally, I was not updating the contents of the file (I only have so many keyboards and so many hands). But just in case, I've repeated the experiment with a 'create table blah tablespace users as select * from dba_objects order by secondary', which kept it going for a while (it also helped that I'd set sort_area_size for the session to 128 bytes). And the results are the same).

As for the Oracle docs, yeah... even the current Backup and Recovery training course material has a slide with the infamous 'ocopy' on it. (This is the same documentation, of course, that says a locally managed SYSTEM tablespace is perfectly feasible, even if they've only just got around to that in 9i release 2!!).

Try it and see... I would like to know for sure that it's not just some particular bit of magic I'm happening to pull off here.

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


"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
news:QIWd8.28336$kX6.217041_at_NewsReader...


> 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)

> > > > > > > >

> > > > > > > >

> > > > > > > >

> > > > > > > >

> > > > > > >

> > > > > > >

> > > > > >

> > > > > >

> > > > > >

> > > > >

> > > > >

> > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>