NT hot backup

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 14 Aug 2002 10:31:21 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70280C5AB@lnewton.leeds.lfs.co.uk>

Chuck,

if copy and xcopy don't work, but ocopy does, then I suspect that ocopy to a safe place first and then compress would be the best way. At least that way you can get your TS back out of backup mode quickly, rather than having to wait for the compress to finish as well. That way, you will know that by using ocopy you will indeed have a reasonable chance of beeing 99% certain that you have a decent copy of the files.

To use compress on an 'open' file will probably hit a similar problems to that with copy/xcopy.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----

From: Chuck [mailto:chuckh_at_softhome.net] Posted At: Monday, August 12, 2002 7:35 PM Posted To: server
Conversation: NT hot backup
Subject: Re: NT hot backup

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 Received on Wed Aug 14 2002 - 04:31:21 CDT