| copy or ocopy with hotbackup on Win2K? [message #53731] |
Tue, 08 October 2002 10:08  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
