I'm quite aware of the need to put tablespaces into backup mode before
backing them up. What I was asking about was that once I've placed a
tablespace into backup mode, I need to backup the open datafiles of that
tablespace. Oracle provides an OCOPY.EXE program to do that because
Microsoft's copy and xcopy commands will not copy open files properly. I
wanted to know if I had to OCOPY the files first, then compress them, or can
I use the compress utility directly to copy and compress the open datafiles
without ocopy?
--
Chuck
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:ai9feb$ki0$1_at_lust.ihug.co.nz...
> You can *never* backup any Oracle database file which is "hot" without
first
> invoking some mechanism that allows Oracle subsequently to fix up the
> internal inconsistencies that *always* arise when you hot copy files.
>
> For data files, that's the 'alter tablespace begin backup' command. And
for
> control files it's the 'alter database backup controlfile to something'
> command.
>
> OCOPY does *not* do this particular trick -it simply allows you to copy
> files which NT otherwise would see as locked (and thus prevent you doing
the
> copy).
>
> Regards
> HJR
>
>
> "Chuck" <chuckh_at_softhome.net> wrote in message
> news:ai8nui$unb73$1_at_ID-85580.news.dfncis.de...
> > Anyone ever used microsoft's compress utility for disk to disk hot
backups
> > on NT or Win2k? Is it safe to backup open files directly with this
utility
> > or do you need to use ocopy first, then compress that file?
> >
> >
>
>
Received on Mon Aug 12 2002 - 13:34:30 CDT
