From oracle-l-bounce@freelists.org Mon Mar 29 10:04:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2TG4Jv27865 for ; Mon, 29 Mar 2004 10:04:19 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2TG4Jo27856 for ; Mon, 29 Mar 2004 10:04:19 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFF61634708; Mon, 29 Mar 2004 11:01:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03600-59; Mon, 29 Mar 2004 11:01:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 050F06344DD; Mon, 29 Mar 2004 11:01:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 29 Mar 2004 10:59:55 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B77B634567 for ; Mon, 29 Mar 2004 10:59:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03142-70 for ; Mon, 29 Mar 2004 10:59:55 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5EB9263465E for ; Mon, 29 Mar 2004 10:59:54 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i2TG7o913813 for ; Mon, 29 Mar 2004 11:07:50 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Mon, 29 Mar 2004 11:07:52 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Compressing Rman Disk Backups Date: Mon, 29 Mar 2004 11:07:51 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B453D5@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Compressing Rman Disk Backups Thread-Index: AcQVp8zgoWecN3OTTcm9cRIuYBGAPgAAB4ig From: "Bobak, Mark" To: X-OriginalArrivalTime: 29 Mar 2004 16:07:52.0023 (UTC) FILETIME=[FCEB7E70:01C415A7] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1980 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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" To: 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@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@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@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 -----------------------------------------------------------------