From oracle-l-bounce@freelists.org Wed Nov 10 14:22:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAAKMXi14994 for ; Wed, 10 Nov 2004 14:22:38 -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 iAAKMWa14989 for ; Wed, 10 Nov 2004 14:22:32 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16F8F72EC3E; Wed, 10 Nov 2004 15:28:48 -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 07945-52; Wed, 10 Nov 2004 15:28:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2468672ECAA; Wed, 10 Nov 2004 15:28:46 -0500 (EST) Date: Wed, 10 Nov 2004 12:26:56 -0800 (PST) From: Jeremiah Wilton To: Ryan Cc: Oracle Discussion List Subject: Re: rman incremental backups vs. full backups In-Reply-To: <006a01c4c761$2dafaf20$350a5444@ryannew> Message-ID: References: <006a01c4c761$2dafaf20$350a5444@ryannew> MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 12108 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jwilton@speakeasy.net Precedence: normal Reply-To: jwilton@speakeasy.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org On Wed, 10 Nov 2004, Ryan wrote: > I believe I read somewhere that you should only take 1 full backup > ever. I can't remember where. This doesn't make any sense to me. If you only ever took one full backup, you would have to apply all the incrementals thereafter in the event of a restore. Until at least 10g (?), incrementals don't save you anything but backup media. They take just as long and read just as much as fulls. -- Jeremiah Wilton Independent Oracle Professional Oracle Certified Master Disaster Recovery - Seminars - Technical Interviews http://www.speakeasy.net/~jwilton -- http://www.freelists.org/webpage/oracle-l