Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compressing Rman Disk Backups/Roberts 10g new features book

RE: Compressing Rman Disk Backups/Roberts 10g new features book

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 30 Mar 2004 10:56:16 -0600
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B85086DC@okcexg3.kmg.com>


If you compress your RMAN backup, doesn't that defeat one of the main features of RMAN? Namely RMAN's ability to pick the correct backup during a restore. RAMN would think all the backups are on a pipe somewhere.

Ron Smith

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman Robert - IL Sent: Tuesday, March 30, 2004 10:51 AM
To: 'M Rafiq '; 'oracle-l_at_freelists.org ' Subject: RE: Compressing Rman Disk Backups/Roberts 10g new features book

In fact, the discount you get on Amazon or Bookpool is better than what *I* get as the author (go figure)... :-) Yer best bet is either of those sites...

Cheers!

Robert

-----Original Message-----

From: M Rafiq
To: oracle-l_at_freelists.org
Sent: 3/30/2004 10:36 AM
Subject: RE: Compressing Rman Disk Backups/Roberts 10g new features book

Nice to hear about your new book. Any list members discount?

Regards
Rafiq

From: Freeman Robert - IL <FREEMANR_at_tusc.com> Reply-To: oracle-l_at_freelists.org
To: "'oracle-l_at_freelists.org '" <oracle-l_at_freelists.org> Subject: RE: Compressing Rman Disk Backups 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_at_freelists.org
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_at_lifetouch.com
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F Sent: Tuesday, March 30, 2004 8:28 AM
To: 'oracle-l_at_freelists.org'
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_at_FMR.COM] Sent: Tuesday, March 30, 2004 9:21 AM
To: oracle-l_at_freelists.org
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_at_labor.state.ny.us] Sent: Monday, March 29, 2004 10:20 AM
To: 'oracle-l_at_freelists.org'
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Get reliable access on MSN 9 Dial-up. 3 months for the price of 1! (Limited-time offer)
http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361 ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org put
'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Mar 30 2004 - 10:52:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US