Home » RDBMS Server » Backup & Recovery » copy or ocopy with hotbackup on Win2K?
copy or ocopy with hotbackup on Win2K? [message #53731] Tue, 08 October 2002 10:08 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
I'am a bit puzzeled by the following:
We have a Win2K Server +sp2 using 8i 8.1.7.4.1 Standard Edition. The database
runs in archive mode. We use the "traditional" hot backup method by placing the
tablespaces in backup mode (begin backup), followed by a copy of the files to a
staging disk, followed by the "alter tablespace .. end backup" command.
So we just use the Win2000 "copy" to copy files. Should we actually use the
oracle "ocopy" tool instead ?

Could you please explain ?

Thanks in advance !
Re: copy or ocopy with hotbackup on Win2K? [message #53736 is a reply to message #53731] Tue, 08 October 2002 16:21 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Oracle created the ocopy command for Windows platform, to avoid having carrupted backup files when using the Windows copy command. The copy command assumes that the files being copied are closed (not used by anyone else), since ocopy is using the shared file mode.

When you "freeze" datafile for backup, Oracle still writes to the file, and if you use the copy command, that couldn't happend, and you end up with "fuzzy" backup files.

Use ocopy and so you can sleep well at night :-))

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Re: copy or ocopy with hotbackup on Win2K? [message #53752 is a reply to message #53736] Wed, 09 October 2002 09:47 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Yes, thanks a lot !
Previous Topic: Backup Method To Read Only Database
Next Topic: Recovery from old backup + archive logs
Goto Forum:
  


Current Time: Thu Mar 28 17:35:17 CDT 2024