Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ftp and database file being corrupted

Tony Kim
Occasional Contributor

ftp and database file being corrupted

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.
3 REPLIES
Bill McNAMARA_1
Honored Contributor

Re: ftp and database file being corrupted

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
It works for me (tm)
John Strang
Regular Advisor

Re: ftp and database file being corrupted

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
If you never make a mistake you'll never make anything.
A. Clay Stephenson
Acclaimed Contributor

Re: ftp and database file being corrupted

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.

If it ain't broke, I can fix that.