From oracle-l-bounce@freelists.org Mon Aug 8 13:17:02 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j78IH1RV007024 for ; Mon, 8 Aug 2005 13:17:01 -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 j78IGwIP007013 for ; Mon, 8 Aug 2005 13:16:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 151811DD1B0; Mon, 8 Aug 2005 13:16:56 -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 31341-08; Mon, 8 Aug 2005 13:16:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B7371DCA77; Mon, 8 Aug 2005 13:16:55 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 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: RMAN restore times Date: Mon, 8 Aug 2005 11:16:27 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C45023613F5@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RMAN restore times thread-index: AcWZFiINC32QbRO+Szi7m5co6GxyjQAAod/wABwwEiAAEe+GMACbTGRg From: "Allen, Brandon" To: , "Hallas, John, Tech Dev" , "Lora Martin" , X-archive-position: 23578 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Somckit, We're using NetBackup 5.1 on an ADIC Scalar tape library with LTO-1 drives (or so I've been told from the admins - it's all behind the scenes to me), on which I typically get a little under 20MB/second for both backups and restores At this rate, you'd be looking at about 15 hours for 1TB. Regards, Brandon -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Khemmanivanh, Somckit Sent: Friday, August 05, 2005 8:26 AM To: Hallas, John, Tech Dev; Lora Martin; oracle-l@freelists.org Subject: RE: RMAN restore times Thanks for your response, I have 2 questions/clarifications: 1) You mention "RMAN backyp from the mirror then re-sync". How is this possible? The mirror copy will be in hot mode, you have to recover the database to open it. Doesn't the database have to be open in order for RMAN to back it up? Did I miss something? If so can you clarify? 2) Regarding restore times, what times have people been seeing with RMAN? If you can post your tape technology that would be much appreciated. If we stick with BCV then it's really hard to beat that technology for restore times but can we get close? Thanks! -----Original Message----- From: Hallas, John, Tech Dev [mailto:John.Hallas@gb.vodafone.co.uk] Sent: Thursday, August 04, 2005 11:53 PM To: Khemmanivanh, Somckit; Lora Martin; oracle-l@freelists.org Subject: RE: RMAN restore times If I had BCVs available I would break the mirror then RMAN backup from the mirror then re-sync. You have a 2TB database. Somckit takes 4 hrs to restore a 4Gb file. There should be / is a fundamental difference in resources or configuration between those 2 setups. If you have BCVs etc I would expect you to have fast tape technology and the whole database should be restorable in maybe 4 hrs not just a 4Gb file. One of the major determining factors in restore times I have seen is the time waited to load the required tape or the contention with other jobs. That is often not taken into account when the overall time is calculated. John -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Khemmanivanh, Somckit Sent: 04 August 2005 18:21 To: Lora Martin; oracle-l@freelists.org Subject: RE: RMAN restore times Thanks for your feedback. Yes, my main hesitation with the RMAN backups for such a large database was the restore times. Why would a 4 GB file take 4 hours to restore? Contention for tape resources? Really slow tape drives, network? Thanks! -----Original Message----- From: Lora Martin [mailto:lmartin@clubmom.com] Sent: Thursday, August 04, 2005 10:01 AM To: Khemmanivanh, Somckit; oracle-l@freelists.org Subject: RE: RMAN restore times If you have BCV - I would use that. I have used EMC BCV... very fast... then go to tape from there. When we restored 4GB file using RMAN from tape on a 2TB system - the restore took 4 hrs -- http://www.freelists.org/webpage/oracle-l Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- http://www.freelists.org/webpage/oracle-l