From oracle-l-bounce@freelists.org Fri Sep 9 11:13:15 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89GDFRP003807 for ; Fri, 9 Sep 2005 11:13:15 -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 j89GD8IP003791 for ; Fri, 9 Sep 2005 11:13:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E580B1EB402; Fri, 9 Sep 2005 11:12:45 -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 30192-01; Fri, 9 Sep 2005 11:12:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 673601EB332; Fri, 9 Sep 2005 11:12:45 -0500 (EST) X-Amazon-Corporate-Relay: smtp-out-2001.iad2.amazon.com X-AMAZON-TRACK: ORACLE-L@freelists.org X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Reading corrupted Datafiles offline Date: Fri, 9 Sep 2005 09:07:32 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Reading corrupted Datafiles offline thread-index: AcWyMx2X5SBHDVUUTf6OLXLfvrRVKQAen2AgAKaIgsAABC7WUA== From: "Parker, Matthew" To: , , X-archive-position: 25222 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: matthewp@amazon.com Precedence: normal Reply-To: matthewp@amazon.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 It's great to hear that he finished his upgrades to the tool. I had last talked to him in February during one of our major corruption fest's. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Lex de Haan Sent: Friday, September 09, 2005 8:35 AM To: Parker, Matthew; jost@unitrade.com; ORACLE-L@freelists.org Subject: RE: Reading corrupted Datafiles offline oh yes, Bernard did upgrade and improve DUL in may was, up to 10g. chained rows are easy to follow, reading row flags, by the way... kind regards, Lex. ------------------------------------------------------------------ Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html ------------------------------------------------------------------ -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Parker, Matthew Sent: Tuesday, September 06, 2005 08:42 To: jost@unitrade.com; ORACLE-L@freelists.org Subject: RE: Reading corrupted Datafiles offline As Jim mentioned there is the DUL (Data Unloader ) tool that Oracle consulting can use for you. The normal stated accuracy is 99% depending on your system. It never understood how to follow chained rows. You are lucky to be on 8.1.6 as they never updated the tool to 9i/10g according to the developer, ( a project sometime in the future for him). Give us so more details about what exactly happened and what you have of your database, then we may be able to help you. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of jost@unitrade.com Sent: Monday, September 05, 2005 9:00 AM To: ORACLE-L@freelists.org Subject: Reading corrupted Datafiles offline Hi list, assuming the following scenario: No working Backup because of several reasons. Not all datafiles of the database Corrupt blocks in the datafiles we have So, as far as i know, there no way to restore the Database in any conventional way. My question is, is there any oficiall or unoficiall way to read the data from the datafiles direct? System ist Linux and Oracle 8.1.6(!) We need not the total whole off the data but some important tables from one special tablespace. I am aware of bad luck with the location of the corrupted blocks, but i will give them a try ;-) If you need more Information feel free to ask. Thx in advance Jörg -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l