From oracle-l-bounce@freelists.org Sat Oct 9 19:10:04 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9A0A4930995 for ; Sat, 9 Oct 2004 19:10:04 -0500 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 i9A0A4I30990 for ; Sat, 9 Oct 2004 19:10:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6270472C379; Sat, 9 Oct 2004 19:16:10 -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 25503-65; Sat, 9 Oct 2004 19:16:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C289872C3A3; Sat, 9 Oct 2004 19:16:09 -0500 (EST) User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Sat, 09 Oct 2004 18:17:26 -0600 Subject: Re: Shadow Image.... From: Tim Gorman To: Message-ID: In-Reply-To: <6.1.2.0.0.20041009183658.024ec978@pop.singnet.com.sg> Mime-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Status: No, hits=0.0 required=3.0 tests=none autolearn=no version=2.63 X-Spam-Level: X-archive-position: 10867 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim@sagelogix.com Precedence: normal Reply-To: tim@sagelogix.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org The rumors of the conventional backup's demise are absolutely true and the corpse should have been buried a long time ago... RMAN works quite well with those techniques (i.e. file-system snapshot, BCVs, shadow image, etc). First CATALOG DATAFILECOPY the snapped images to enter knowledge of their existence into the RMAN catalog, and then use BACKUP DATAFILECOPY to backup those copies onto tape. Admittedly not as straightforward as simply issuing a BACKUP DATABASE command, but that's what Perl and shell scripts are for, but the restore and recovery is no different. You get corruption checking and the ability to validate recoverability -- things that old-style scripted backups don't provide. The DBAs still have to put the database into and out of BACKUP mode during the snapshot, but getting it to tape and -- much more importantly -- having an easy time during restore and recovery -- is best done with RMAN. Yep, deader than roadkill. Better bury it before it stinks up the place... on 10/9/04 4:38 AM, Hemant K Chitale at hkchital@singnet.com.sg wrote: > > > RMAN cannot be used to create backups which rely on > SnapShot/SnapClone/BCV/ShadowImage technologies. > DBAs must still put the databases in Backup mode and create the "copied" > image of the database. > > Hemant > > > At 02:57 AM Saturday, Bobak, Mark wrote: > Carel-Jan, > > It's interesting that Oracle provided this enhancement. > > The message I thought I was hearing (with the introduction of RMAN, > and then with the requirement to use RMAN if you go w/ ASM), was > that conventional backups were *eventually* going away. > > Perhaps the rumors of the conventional backup's demise have been > a bit exaggerated..... > > -Mark > > > > Hemant K Chitale > http://web.singnet.com.sg/~hkchital > > > > > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l