Re: Compress datafiles for backup

In article <4ktnoi$gp1_at_ins3.coned.com>, utrankas_at_coned.com says...
>
>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.
>

If your tape drive is already doing hardware compression, you would not benefit from compressing the files via software.

Scott Overby
sds_at_dataplusnet.com Received on Tue Apr 16 1996 - 00:00:00 CEST