Re: Compress datafiles for backup
Date: 1996/04/16
Message-ID: <4l08rj$1n92_at_mule1.mindspring.com>#1/1
This should not pose any problems. My tape drive uses hardware compresion when writing to the drive. I can get about 1.4g of oracle datafiles onto 800M tapes. A lot depends how much free space was in the oracle datafile to begin with.
utrankas_at_coned.com (Sameer Utrankar) wrote:
>My oracle database is 8GB. Tape capacity is 4GB. I have no support to
>change tapes at night during daily cron job for cold back.
>In order to fit all the data files on one single tape, I would like to
>back up as :
>tar -cvf - list_of_files_to_be_backed_up | compress > /dev/rmt/0m
>and recover as :
>uncompress < /dev/rmt/0m | tar -xvf - list_of_files_to_be_retrieved
>I am on Hp-Ux 10 and Oracle database 7.2.3.
>Any body sees any obvious problems in this ? Only worried because I
>have not heard anybody compressing files to tape. Note that this is
>for COLD BACKUP ONLY.
>Thanks
>------------------------------------
>Utrankas_at_coned.com (Sameer Utrankar)
Received on Tue Apr 16 1996 - 00:00:00 CEST