Re: Compressing Rman Disk Backups

From: Philip Douglass <philip.douglass_at_il.proquest.com>
Date: Mon, 29 Mar 2004 11:14:28 -0500
Message-ID: <028701c415a8$e9276a60$d7f918ac@sirs.com>

Not bloddy likely... I can't even find the docs for the MML API. Besides, this is over my head. Dammit Jim, I'm a DBA not a programmer!

Original Message ----- From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> To: <oracle-l_at_freelists.org> Sent: Monday, March 29, 2004 11:07 AM Subject: RE: Compressing Rman Disk Backups

Cool idea, Philip!

(Let us all know when you've got it wrapped up and debugged! ;-))

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

From: Douglass, Philip
Sent: Monday, March 29, 2004 11:05 AM
To: oracle-l_at_freelists.org
Subject: Re: Compressing Rman Disk Backups

I suppose you could manage it with named pipes, and a gzip process sucking on them. Might be kind of tricky with how rman does multiple backupsets.

I've always thought it would be incredibly useful to have a perl module that functioned as an MML for Rman. Just something that would open up the API so we could write perl backends that could:

    compress backupsets
    push backups over a network
    save backupsets to the least full backup partition.     interface with third-party backup software that doesn't support Oracle     etc...

I don't know if that is feasible or not, but I'd love to see something like this.

Original Message ----- From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> To: <oracle-l_at_freelists.org> Sent: Monday, March 29, 2004 10:19 AM 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

Received on Mon Mar 29 2004 - 10:12:37 CST