Large file limitation

[Ted Blahunka]

We are currently using HP-UX 10.20 and due to the large file size limitation of 2GB we are unable to uncompress a file for import into an Oracle DB. I have been told that there may be a way to pipe the uncompress command to a file and then perform the import using the newer uncompressed file of less than 2GB. Is anyone aware of this method?

[Bill Hassell]

Not sure I understand the problem. compress and uncompress are largefile compatible just as 10.20 is largefile compatible. The filesystem that is to hold largerfiles must be created (or modified with fsadm) and also mlunted with a largefile option.

[Marcin Wicinski · Accepted solution]

Hi,
Just create fs supporting large files:

/usr/sbin/fsadm -F [hfs|vxfs] -o largefiles /dev/vgXX/lvolX

or modify existing fs with fsadm to support large files.

Later,

[Alan Riggs]

The above answers are correct. Simply setting your filesystem to accomodate large files will allow the uncompress.

As a point of interest, I will note that we use a piped compression for our oracle exports in order to minimize the size requirements for our filesystem. I would imagine that you could modify the sequence to support the import, too, though I have not tested such a solution. For export:

rm /export/oracle/fullAPPDEV.dmp.Z
/usr/sbin/mknod /export/oracle/fullAPPDEV.dmp p
compress < /export/oracle/fullAPPDEV.dmp > /export/oracle/fullAPPDEV.dm
p.Z &
sleep 5
$ORACLE_HOME/bin/exp fullexp/exp FULL=Y file=/export/oracle/fullAPPDEV.dmp log=/export/oracle/logs/fullAPPDEV.log
rm /export/oracle/fullAPPDEV.dmp

#NOTE: the rm commands clean up the previous export and the named pipe.

[Ridzuan Zakaria]

Hi,

You can you the following command to import uncompress .dmp file :

rm /oracle/data/temp/exp.dmp
mknod /oracle/data/temp/exp.dmp p
uncompress -v < /oracle/data/temp/exp.dmp.Z > /oracle/data/temp/e
xp.dmp &

sleep 5

imp parfile=imp.par

You can create imp.par with whatever import parameter that fix your requirement.

thanks

[Sanjay_6]

Hi Ted,

If you have an existing filesystem u can modify the largefile parameter for that filesystem either through SAM or through the comamnd line.

For SAM use SAM ---> Disk and Filesystems --> Select the filesystem ---> Selct Action ----> Modify ----> Modify vxfs default / parameters ---> set the flag largefiles on , Select Ok and exit.

Through command line
umount /mount_point
fsadm -F vxfs -o largefiles /dev/vg_name/lv_name
mount /dev/vg_name/lv_name

If you doing this through your command line, modify the /etc/fstab file so that largefile option is refelected in the mount parameters corresponding to this lv.

Hope this helps.

Thanks