1748239 Members
3622 Online
108759 Solutions
New Discussion юеВ

uncompress problem

 
Lukas Grijander
Advisor

uncompress problem

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.
3 REPLIES 3
Santosh Nair_1
Honored Contributor

Re: uncompress problem

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
Life is what's happening while you're busy making other plans
Ovidiu D. Raita
Valued Contributor

Re: uncompress problem

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

Ovidiu
Simple solutions to complex problems
Lukas Grijander
Advisor

Re: uncompress problem

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