From oracle-l-bounce@freelists.org Wed Dec 1 17:24:21 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB1NOLN26094 for ; Wed, 1 Dec 2004 17:24:21 -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 iB1NOLx26089 for ; Wed, 1 Dec 2004 17:24:21 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C7E5C72C3DB; Wed, 1 Dec 2004 18:30:43 -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 14358-90; Wed, 1 Dec 2004 18:30:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4609772C3DA; Wed, 1 Dec 2004 18:30:43 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: roger_xu@dp7uptx.com X-Msg-Ref: server-4.tower-65.messagelabs.com!1101943741!22216094!3 X-StarScan-Version: 5.4.2; 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: database restore question (Urgent!) Date: Wed, 1 Dec 2004 17:28:54 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: database restore question (Urgent!) Thread-Index: AcTX6wGlV6Rn8KOtTqOVuToRA9h00AADNjgAAAFbO2A= From: "Roger Xu" To: "Oracle-L@Freelists. Org (E-mail)" Content-Transfer-Encoding: 8bit X-archive-position: 12980 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 It worked and the database is up and running. Thank y'all. -----Original Message----- From: Jeremiah Wilton [ mailto:jwilton@speakeasy.net] Sent: Wednesday, December 01, 2004 3:16 PM To: Roger Xu Cc: Oracle-L@Freelists. Org (E-mail) Subject: Re: database restore question (Urgent!) On Wed, 1 Dec 2004, Roger Xu wrote: > We need to do a point-in-time restore of one of our 9.2i databases > to Monday 3 p.m. > > The last two backups was performed Sunday night and Friday night and > all the archived logs are in the original place. > > After 13 hours of tape restore, we found out one of the DLT tapes is > bad. We are able to find out which files are in this > > tape and there are 36 datafiles on it. > > My question: Can we restore those 36 files from Friday night's > backup? Yes. You will have to apply all redologs from Friday forward. Apply time of logs generated prior to the Sunday backup will be faster than if you restored all files from Friday's backup. Good luck, and let us know how it goes. -- Jeremiah Wilton Independent Oracle Professional Oracle Certified Master Disaster Recovery - Seminars - Technical Interviews http://www.speakeasy.net/~jwilton 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