From oracle-l-bounce@freelists.org Fri Sep 9 20:46:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8A1kutN026091 for ; Fri, 9 Sep 2005 20:46:56 -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 j8A1kpIP026078 for ; Fri, 9 Sep 2005 20:46:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 77BC31EB02D; Fri, 9 Sep 2005 20:46:27 -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 13407-05; Fri, 9 Sep 2005 20:46:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E40CA1E9BAF; Fri, 9 Sep 2005 20:46:26 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=XREJCTCmIF58KsHNS5ymQfsImFVTYmoJd6MP91cbMg1JkOZ53sfN1Fc3uVwZqsBlb3ZvvPs0z6eIzNXE3e8F8DStAB5L8ieGhF4K1YzgSPWXeH60jtR2Ga02LHyaVD/nrFUSpJo6oQjY/E0c5GzoqVlxr17LJDKWB9LqDjYxuI4= Message-ID: Date: Sat, 10 Sep 2005 09:44:33 +0800 From: Lou Fangxin To: matthewp@amazon.com Subject: Re: Reading corrupted Datafiles offline Cc: lex.de.haan@naturaljoin.nl, jost@unitrade.com, ORACLE-L@freelists.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1487_5105864.1126316673004" References: X-archive-position: 25258 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: anysql@gmail.com Precedence: normal Reply-To: anysql@gmail.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=-4.8 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1487_5105864.1126316673004 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline MYDUL also support the chained row/IOT, and limited support of LOBs,=20 currently only compressed table and IOT not supported. On 9/10/05, Parker, Matthew wrote:=20 >=20 > It's great to hear that he finished his upgrades to the tool. I had last= =20 > talked to him in February during one of our major corruption fest's. >=20 > -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org= ]=20 > 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 >=20 >=20 > 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... >=20 > kind regards, >=20 > Lex. >=20 > ------------------------------------------------------------------ > Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html > ------------------------------------------------------------------ > -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org= ]=20 > 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 >=20 > As Jim mentioned there is the DUL (Data Unloader ) tool that Oracle=20 > consulting > can use for you. The normal stated accuracy is 99% depending on your=20 > 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=20 > project > sometime in the future for him). >=20 > Give us so more details about what exactly happened and what you have of= =20 > your > database, then we may be able to help you. >=20 > -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org= ]=20 > On > Behalf Of jost@unitrade.com > Sent: Monday, September 05, 2005 9:00 AM > To: ORACLE-L@freelists.org > Subject: Reading corrupted Datafiles offline >=20 >=20 >=20 >=20 >=20 >=20 > Hi list, >=20 > assuming the following scenario: >=20 > No working Backup because of several reasons. > Not all datafiles of the database > Corrupt blocks in the datafiles we have >=20 > So, as far as i know, there no way to restore the Database in any=20 > conventional > way. >=20 > My question is, is there any oficiall or unoficiall way to read the data= =20 > from > the datafiles direct? >=20 > System ist Linux and Oracle 8.1.6(!) >=20 > We need not the total whole off the data but some important tables from= =20 > one > special tablespace. > I am aware of bad luck with the location of the corrupted blocks, but i= =20 > will > give them a try ;-) >=20 > If you need more Information feel free to ask. >=20 > Thx in advance >=20 > J=F6rg >=20 > -- > http://www.freelists.org/webpage/oracle-l > -- > http://www.freelists.org/webpage/oracle-l > -- > http://www.freelists.org/webpage/oracle-l >=20 --=20 Welcome, Fangxin.Lou from China Home: http://www.anysql.net/en/ Mydul: http://www.anysql.net/en/mydul.html ------=_Part_1487_5105864.1126316673004 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline MYDUL also support the chained row/IOT, and limited support of LOBs, curren= tly only compressed table and IOT not supported.

On 9/10/05, = Parker, Matthew <matthewp@ama= zon.com> wrote:
It's great to hear that he finis= hed his upgrades to the tool. I had last talked to him in February during o= ne of our major corruption fest's.

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Beh= alf 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 cor= rupted Datafiles offline


oh yes, Bernard did upgrade and improve DUL in may was, up to 1= 0g.
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 Mess= age-----
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: R= E: 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 sy= stem. It
never understood how to follow chained rows. You are lucky to b= e on 8.1.6 as
they never updated the tool to 9i/10g according to the dev= eloper, ( a project
sometime in the future for him).

Give us so more details about w= hat 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, Septem= ber 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 un= oficiall 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 o= ne
special tablespace.
I am aware of bad luck with the location of th= e corrupted blocks, but i will
give them a try ;-)

If you need more Information feel free to as= k.

Thx in advance

J=F6rg

--
http://www.freelists.org/webpage/oracle-l
--
http://www.= freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l



--
Welcome, Fangxin.Lou from China
H= ome: http://www.anysql.net/en/Mydul: http://www.anysql.n= et/en/mydul.html
------=_Part_1487_5105864.1126316673004-- -- http://www.freelists.org/webpage/oracle-l