FTP problem in HP unix 11i

[aneez]

Hi all,

I am facing a problem. I used to take daily back up(ftp the file to a windows2003 server) of oracle dump using ftp.I put a script in the crontab for doing this. Now i saw that, the dump file size in hp ux is 40GB but after ftp, the size showing in the windows 2003 server is 27 GB.What may be the reason for this diffrence in size. But in the syslog and root mail its not showing any error also.

the below showing is the script.

ftp -nv xx.xx.xx.xx
user anonymous xxxxx
bi
lcd /backup/ora/exp
put fullexp_*.dmp
put fullexp_*.log
bye


I am waiting for your valuable replies.

Thanks in advance,
Aneez

[Dennis Handly]

Some files on HP-UX have holes in them and if you copy them they get bigger. You seem to have the opposite case. It could mean that Windows is smarter with holes?

Are these binary or ascii files? If the latter, can you count the number of records?
Can you copy the file back and then compare or cksum?

Did the ftp output say how many bytes were copied?

[Yogeeraj_1]

Hi Aneez,

First of all verify that the dump file is valid by doing a test import with rows=n option.


Maybe the windows 2003 server is storing the file in compressed format. not sure. Please check. I do not have a test server at hand..

I would also suggest that when you export, use the "filesize=1024M" or "filesize=2048M" to limit the file size to 1GB or 2GB.

Also, if the servers are remote, try to compress the files before the transfer.


kind regards
yogeeraj

[aneez]

Hi

These are binary files.This is the live production server, so i cant copy back this much big file.In the server syslog its not showing the error and the ftp session details.Is any otherway to check the issue.

thanks and regards
Aneez

[Yogeeraj_1]

hi again,

also consider using RMAN for backup. EXP/IMP is not the recommended tool for backup.

In oracle 10g, you can even configure RMAN to compress the data files during backup.


hope this helps!

kind regards
yogeeraj

[aneez]

HI
this the raw file system for oracle. the export can be done in unix level or oracle level.

aneez

[aneez]

Hi All,

if i try above ftp to another machine its happened properly through command line. it properly done the ftp for 40gb to windowsXP machine.but yesterday i put the same in a script and run through crontab. that was not completed properly(that put only 26GB instaed of 40GB).SO what may the reasons for incomplete ftp.

i am waiting for your replies

Thanks in advance
Aneez

[Dennis Handly]

As I asked above: Did the ftp output say how many bytes were copied?

How much of the ftp output do you keep? You may also want to do a "ls" command after you copy it.