Uncompress -- - File Too Large

[Vinesh Dhevcharran]

Hi,

I have oracle datafiles that ar 2GB in size. I have done an export and the exported file compressed is as follows:
1118475115 Jan 3 12:12 UCT01.dmp.Z

The export was done with a pipe to the compressed file. When trying to uncompress the file, I get the following:
ORACLE8>>uncompress UCT01.dmp.Z
UCT01.dmp: File too large
ORACLE8>>ls -al UCT01.dmp.Z
-rw-r--r-- 1 oracle dba

Any ideas about this?
We are running HP-UX 11.0.B on an L2000

[Ian Dennison_1 · Accepted solution]

Does your destination file system has VxFS 'largefiles' set?

Cheers, Ian Dennison

[Dietmar Konermann]

Hi!

Your uncompress version is obviously not large-file-aware.

As a workaround this should work for you:

uncompress -c UCT01.dmp

Best regards...
Dietmar.

[Stefan Farrelly]

Try;

zcat UCT01.dmp.Z > UCT01.dmp

Either that or you need largefiles on your filesystem, you can check if its on by doing;

fsadm /dev//r

And it should return;
nomultifsets
nolargefiles

And you can set it on with;
fsadm -o largefiles

Then the uncompress should work.

[Vinesh Dhevcharran]

Hi,

Examination of my fstab indicates that the filesystem was mounted with nolargefiles.
1. If I activate this as indicated above, what are the implications?
2. Does this in any way affect any of the existing database files?
3. Can I do this on the fly or do I need to be in single user mode?
Many Thanks
Vinesh

[Heiner E. Lennackers]

1. It enables only large file possibility, no other impacts
2. no impact on database files
3. If you have the OnlineJFS or AdvanceJFS you can do it on the fly, otherwise the filesystem hat to be umounted.

Heiner

[Robert-Jan Goossens]

Hi,

If you have vxfs filesytems you can do it on the fly, hfs first umount change and mount again.

Robert-Jan.

[Gerhard Roets]

You could enable largefiles for it you would just need to do a umount and a mount of that mount point.

Make sure oracle is not running though else your umount will fail if any datasets are open. I would start here since if your file is just more than 2Gb it will fail to uncompress succesfully. After doing that look at the uncompress with 2Gb limit workarounds as above.

[Vinesh Dhevcharran]

Hi,

I did a umount of /aleph/tmp and then tried the following (in runlevel 3):
fsadm -o largefiles /aleph/tmp
fsadm: /etc/default/fs is used for determining the file system type
vxfs fsadm: /aleph/tmp is not the root inode of a vxfs file sytem

I also tried changing the options in the vfstab from nolargefiles to largefiles without much luck.

Any suggestions???

Thanks
Vinesh

[Vinesh Dhevcharran]

Hi,

Solved the problem, I simply removed largefiles from the fstab and did a mount.
I then uncompressed the file and it worked.

Many Thanks nevertheless

Vinesh