From oracle-l-bounce@freelists.org Fri Jun 17 14:59:17 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5HJxFUt026446 for ; Fri, 17 Jun 2005 14:59:15 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5HJxFNi026442 for ; Fri, 17 Jun 2005 14:59:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8BFB1BC402; Fri, 17 Jun 2005 13:55:54 -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 13093-03; Fri, 17 Jun 2005 13:55:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 216B41BCF53; Fri, 17 Jun 2005 13:55:54 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5736D.EE5BE09F" Subject: RE: backups to disk Date: Fri, 17 Jun 2005 14:54:03 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: backups to disk Thread-Index: AcVzTqEo01haBJK5RrGT5aVmddT6MgAG+LHzAAC4VJA= From: "Mercadante, Thomas F (LABOR)" To: Cc: X-OriginalArrivalTime: 17 Jun 2005 18:54:04.0500 (UTC) FILETIME=[EECD7940:01C5736D] X-archive-position: 21321 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Thomas.Mercadante@labor.state.ny.us Precedence: normal Reply-To: Thomas.Mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5736D.EE5BE09F Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Paula, =20 I wrote korn scripts to perform rman backups to disk followed by gzip'ing the resulting file. We keep about one weeks worth of backups on disk (3 backups). The directory is backed to tape nightly. I have another script that simply removes files from this directory (things more than 9 days old). =20 If you need a file from tape, the sysadmins will need to get it for you. The bad news is that you need about 2.5 times of disk space for this type of setup. But Ruth is correct. The Rman backups run in about 15 minutes. =20 Tom =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Paula_Stankus@doh.state.fl.us Sent: Friday, June 17, 2005 2:30 PM To: breitliw@centrexcc.com; mgogala@allegientsystems.com Cc: Patty.Charlebois@greenshield.ca; oracle-l@freelists.org Subject: Re: backups to disk =20 Wanting to do our backups to disk as tape media and hware so unreliable and system admin group wants us to have them run our backups and restores which would just slow down the whole process Any way to keep storage costs down considering one week worth of backups and using all the tricks for types of tablespaces and backups??? -------------------------- Sent from my BlackBerry Wireless Handheld ------_=_NextPart_001_01C5736D.EE5BE09F Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Re: backups to disk

Paula,

 

I wrote korn scripts to perform = rman backups to disk followed by gzip’ing the resulting file.  We = keep about one weeks worth of backups on disk (3 backups).  The directory is = backed to tape nightly.  I have another script that simply removes files from = this directory (things more than 9 days old).

 

If you need a file from tape, the sysadmins will need to get it for you.


The bad news is that you need about 2.5 times of disk space for this = type of setup.  But Ruth is correct.  The Rman backups run in about 15 = minutes.

 

Tom

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of = Paula_Stankus@doh.state.fl.us
Sent: Friday, June 17, = 2005 2:30 PM
To: = breitliw@centrexcc.com; mgogala@allegientsystems.com
Cc: Patty.Charlebois@greenshield.ca; oracle-l@freelists.org
Subject: Re: backups to = disk

 

Wanting to do our backups to disk as tape media and hware so unreliable and = system admin group wants us to have them run our backups and restores which = would just slow down the whole process

Any way to keep storage costs down considering one week worth of backups = and using all the tricks for types of tablespaces and backups???
--------------------------
Sent from my BlackBerry Wireless Handheld

------_=_NextPart_001_01C5736D.EE5BE09F-- -- http://www.freelists.org/webpage/oracle-l