topic Re: ftp and database file being corrupted in Operating System - HP-UX

ftp and database file being corrupted

Tony Kim — Tue, 23 Apr 2002 13:41:23 GMT

Can anyone tell me if an FTP process not related to Orcle database could possibly corrupt a ".dbf" file? Many years ago, I had similar experience of file corruption while doing an independent file transfer via FTP.

Does anyone have any additional info on this?

Thanks in advance.

Re: ftp and database file being corrupted

Bill McNAMARA_1 — Tue, 23 Apr 2002 13:45:32 GMT

It'd be rare..
Have a look at PHNE_23949, there is not much talk about file corruption.. I would start looking for other networking patches.

Later,
Bill

Re: ftp and database file being corrupted

John Strang — Tue, 23 Apr 2002 13:49:01 GMT

Hi Tony,

My immediate thought is that you might be trying to ftp the file as ascii instead of binary.

When at the ftp> prompt type 'bin' to set to binary mode.

HTH,

John

Re: ftp and database file being corrupted

A. Clay Stephenson — Tue, 23 Apr 2002 13:53:52 GMT

If by 'not-related' then you mean routine FTP transfers that are not Oracle files then NO. I have used FTP scripts in both shell and Perl for years in an environment that was also running Oracle and have never experienced database corruption.

On the other hand, if you are transferring database files via FTP then I can think of two possible concerns: 1) ASCII rather than BINARY transfers 2) FTP/OS imposed limits on maximum file sizes.