Home -> Usenet -> comp.databases.oracle -> Compress datafiles for backup

Compress datafiles for backup

From: Sameer Utrankar <utrankas_at_coned.com>
Date: 1996/04/15
Message-ID: <4ktnoi$gp1_at_ins3.coned.com>#1/1 






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 Mon Apr 15 1996 - 00:00:00 CEST












Original text of this message