From oracle-l-bounce@freelists.org Tue Jun 21 13:10:11 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5LIAB5C021195 for ; Tue, 21 Jun 2005 13:10:11 -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 j5LIABNi021190 for ; Tue, 21 Jun 2005 13:10:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 967731C30D9; Tue, 21 Jun 2005 12:06:46 -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 10040-10; Tue, 21 Jun 2005 12:06:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E59B61C30EE; Tue, 21 Jun 2005 12:06:45 -0500 (EST) From: "Ruth Gramolini" To: , Cc: Subject: RE: RMAN backups Date: Tue, 21 Jun 2005 13:05:00 -0400 Message-ID: <01d901c57683$5bedc670$8459000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01DA_01C57661.D4DC2670" In-Reply-To: <4ca3406a05061808193dd7321b@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-archive-position: 21427 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: rgramolini@tax.state.vt.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.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_01DA_01C57661.D4DC2670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_01DA_01C57661.D4DC2670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
John,
 
Unless = something has=20 changed with 10g, and incremental backup doesn't actually save much = time. =20 Rman still has to read the block headers to see if the block needs to be = backed=20 up.  It mostly saves space on disc if backing up to=20 disk.
 
Correct me if I am=20 wrong!
Ruth
-----Original Message-----
From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org]On Behalf Of John=20 Smiley
Sent: Saturday, June 18, 2005 11:19 AM
To:=20 richard.ignizio@paetec.com
Cc:=20 oracle-l@freelists.org
Subject: Re: RMAN=20 backups

Backup times with RMAN are going to vary = greatly=20 depending upon the hardware and how many blocks need to be backed = up.  Even=20 a very large database can be backed up incrementally if very few blocks = have=20 changed since the last backup with RMAN.

What might be a better = yardstick=20 is backup rate.  The fastest RMAN backup rate I've seen was = published by=20 Amazon a few years back.  They attained 2TB / hour.

John=20 Smiley
Technical Management Consultant
TUSC, = Inc.
------=_NextPart_000_01DA_01C57661.D4DC2670-- -- http://www.freelists.org/webpage/oracle-l