From oracle-l-bounce@freelists.org Tue Mar 30 08:36:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2UEaGI01789 for ; Tue, 30 Mar 2004 08:36:16 -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 i2UEaFo01777 for ; Tue, 30 Mar 2004 08:36:15 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 38C09634F04; Tue, 30 Mar 2004 09:31:35 -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 31777-14; Tue, 30 Mar 2004 09:31:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8FE9634D22; Tue, 30 Mar 2004 09:31:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 09:30:01 -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 2ACB9634D0E for ; Tue, 30 Mar 2004 09:30:01 -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 31212-40 for ; Tue, 30 Mar 2004 09:30:00 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id D1775634D76 for ; Tue, 30 Mar 2004 09:29:27 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 30 Mar 2004 14:37:29 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00316@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Compressing Rman Disk Backups Date: Tue, 30 Mar 2004 08:33:58 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2049 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mercadante, Thomas F Sent: Tuesday, March 30, 2004 8:28 AM To: 'oracle-l@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@FMR.COM] Sent: Tuesday, March 30, 2004 9:21 AM To: oracle-l@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@labor.state.ny.us] Sent: Monday, March 29, 2004 10:20 AM To: 'oracle-l@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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------