RE: Compressing Rman Disk Backups
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Mar 2004 08:44:12 -0600
Sorry to be late in this thread, and I'm not sure if anyone has mentioned
this... but Oracle 10g provides for REAL compression of RMAN backups when
they are created. Not the old "we don't back up unused blocks" but real,
honest to goodness compression.
All this and more in Oracle Database 10g New Features by Moi! It's available
NOW! Wooo Hooo!
Robert
-----Original Message-----
From: DENNIS WILLIAMS
To: oracle-l@xxxxxxxxxxxxx
Sent: 3/30/2004 8:33 AM
Subject: RE: Compressing Rman Disk Backups
Tom
I think you are on the right track. I was at an Oracle presentation
last
week where they stated that in some respects disk is approaching the
cost of
tape. I think a lot of enterprises are moving toward adding a little
additional disk and having a single shared tape backup facility.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante, Thomas F
Sent: Tuesday, March 30, 2004 8:28 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Compressing Rman Disk Backups
All,
After thinking about this more, we are considering two things:
Adding more disk space to the backup directory to be able to hold a full
Rman backup, or going directly to tape.
I am no longer considering compressing the rman backups on disk. Only
because, if we fall into a recovery scenario, I may not have room to
completly uncompress the full rman backup. That would leave me with
juggling a restore with uncompressing a file, letting rman work on it,
wait
for rman to finish with it, ask for the next file, compress the first
and
uncompress the second... talk about spinning plates. Just not a way to
run
a business.
So we are reviewing cost differences between adding disk and backing up
to
tape.
thanks again for all the replies.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Khedr, Waleed [mailto:Waleed.Khedr@xxxxxxx]
Sent: Tuesday, March 30, 2004 9:21 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Compressing Rman Disk Backups
Did you consider looking for compressed file systems? I don't know if
there
is any for UNIX but my guess would be why not :)
Probably the compression would be on the file system block level to
allow
concurrency.
May be there is an option during the create and the mount of the file
system
that allows it to be compressed without buying other products.
Regards,
Waleed
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]
Sent: Monday, March 29, 2004 10:20 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Compressing Rman Disk Backups
All,
I am attempting to perform Rman disk backups on a data warehouse. While
the
disk backup runs fine, the size of the output files are, of course,
huge.
What I would like to do is to pipe the output of the Rman backup while
it is
running to something like Gzip so that the file gets created compressed.
My
other option is to break the backup into a tablespace by tablespace
multi-Rman run process and gzip or compress the files in between each
step.
Anybody found a way to do this?
thanks
PS - Oracle 9.2.0.3 on Sun Unix.
Tom Mercadante
Oracle Certified Professional
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
