From oracle-l-bounce@freelists.org Mon Oct 11 15:09:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9BK9qX15945 for ; Mon, 11 Oct 2004 15:09:52 -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 i9BK9qI15940 for ; Mon, 11 Oct 2004 15:09:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB44972D1FA; Mon, 11 Oct 2004 15:15:58 -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 26721-01; Mon, 11 Oct 2004 15:15:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE45D72D225; Mon, 11 Oct 2004 15:15:57 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-12.tower-65.messagelabs.com!1097525658!16952466 X-StarScan-Version: 5.2.10; banners=dp7uptx.com,-,- X-Originating-IP: [216.136.17.254] X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: Shadow Image.... Date: Mon, 11 Oct 2004 15:14:10 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Shadow Image.... Thread-Index: AcSuXjwPaqWuqAq+RBmlktwDTiSn0ABb9pIQ From: "Roger Xu" To: Content-Transfer-Encoding: 8bit X-archive-position: 10932 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: roger_xu@dp7uptx.com Precedence: normal Reply-To: roger_xu@dp7uptx.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org We have HDS 9960 and are thinking backup via shadow image. Can someone who is using this provide us the steps to do both backup and recovery? Thanks. (Solaris 9 / Oracle 9.2.0.4.0) -----Original Message----- From: Tim Gorman [ mailto:tim@sagelogix.com] Sent: Saturday, October 09, 2004 7:17 PM To: oracle-l@freelists.org Subject: Re: Shadow Image.... 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... This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support@dp7uptx.com. -- http://www.freelists.org/webpage/oracle-l