From oracle-l-bounce@freelists.org Tue Jun 21 13:22:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LIMp9v023067 for ; Tue, 21 Jun 2005 13:22:51 -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 j5LIMnNi023058 for ; Tue, 21 Jun 2005 13:22:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 729E21C23D8; Tue, 21 Jun 2005 12:17:32 -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 11422-04; Tue, 21 Jun 2005 12:17:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB9DF1C08A4; Tue, 21 Jun 2005 12:17:31 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Priority: normal 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 backups Date: Tue, 21 Jun 2005 10:16:57 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361168@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RMAN backups Thread-Index: AcV2g4t9g6bF9XoHSx2fj3sCybPwygAAGtRw From: "Allen, Brandon" To: , , Cc: X-archive-position: 21430 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-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 We do save a significant amount of time and space by using incremental backups: SQL>select avg(elapsed_seconds)/60/60 from rc_backup_set where db_key=2300 and backup_type='D' and completion_time >= sysdate -45; AVG(ELAPSED_SECONDS)/60/60 -------------------------- 3.8742284 SQL>select avg(elapsed_seconds)/60/60 from rc_backup_set where db_key=2300 and backup_type='I' and completion_time >= sysdate -45; AVG(ELAPSED_SECONDS)/60/60 -------------------------- 1.13801519 Regards, Brandon -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Ruth Gramolini Sent: Tuesday, June 21, 2005 10:05 AM To: jrsmiley@gmail.com; richard.ignizio@paetec.com Cc: oracle-l@freelists.org Subject: RE: RMAN backups John, Unless something has changed with 10g, and incremental backup doesn't actually save much time. Rman still has to read the block headers to see if the block needs to be backed up. It mostly saves space on disc if backing up to disk. Correct me if I am wrong! Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of John Smiley Sent: Saturday, June 18, 2005 11:19 AM To: richard.ignizio@paetec.com Cc: oracle-l@freelists.org Subject: Re: RMAN backups Backup times with RMAN are going to vary greatly depending upon the hardware and how many blocks need to be backed up. Even a very large database can be backed up incrementally if very few blocks have changed since the last backup with RMAN. What might be a better yardstick is backup rate. The fastest RMAN backup rate I've seen was published by Amazon a few years back. They attained 2TB / hour. John Smiley Technical Management Consultant TUSC, Inc. 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