topic uncompress problem in Operating System - HP-UX

uncompress problem

Lukas Grijander — Wed, 19 Sep 2001 15:42:14 GMT

Hi all.

To backup my oracle DB I do the following:

alter tablespace xxx begin backup
host cp /d1/datafile1 /d2/datafile1
host cp /d1/datafile2 /d2/datafile2
alter tablespace xxx end backup
compress -f /d2/datafile1
compress -f /d2/datafile2

... another tablespaces.

Now I?m going to test this backup trying to restore it in another box.

uncompress /d2/datafile1
uncompress /d2/datafile1
...

but with some files (not all of them) uncompress says

uncompress: corrupt input

the same occurs trying uncompress on the original box (so it isn?t a copy between machines problem).

The backup process log say?s nothing about problems with compress

#which compress
/usr/bin/compress:
$Revision: 82.1.1.2 $
PATCH_11_00: compress.o 99/09/03

Thank you in advance.

Re: uncompress problem

Santosh Nair_1 — Wed, 19 Sep 2001 16:27:03 GMT

Slightly off topic...how about using gzip instead of compress...it generally get better compression than does compress.

Also, instead of cp'ing how about doing something like gzip -c /d1/datafile1 > /d2/datafile1.gz, which would compress on the fly thus reducing space requirements on /d2.

-Santosh

Re: uncompress problem

Ovidiu D. Raita — Thu, 20 Sep 2001 01:37:02 GMT

Are the datafiles bigger than 2GB? If yes, try gzip.

Ovidiu

Re: uncompress problem

Lukas Grijander — Thu, 20 Sep 2001 16:02:52 GMT

Thank's all

I'll try gzip, but with --fast option because before using compress I was using gzip -> better compression ratio but worst times (cp+compress 4 hours, cp+gzip 12 hours ...)

Rafa