MYDUL also support the chained row/IOT, and limited support of LOBs, currently only compressed table and IOT not supported.
On 9/10/05, Parker, Matthew <matthewp@(protected)> wrote: > > 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@(protected) [mailto:oracle-l-bounce@(protected)] > On Behalf Of Lex de Haan > Sent: Friday, September 09, 2005 8:35 AM > To: Parker, Matthew; jost@(protected); ORACLE-L@(protected) > 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@(protected) [mailto:oracle-l-bounce@(protected)] > On > Behalf Of Parker, Matthew > Sent: Tuesday, September 06, 2005 08:42 > To: jost@(protected); ORACLE-L@(protected) > 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.6as > 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@(protected) [mailto:oracle-l-bounce@(protected)] > On > Behalf Of jost@(protected) > Sent: Monday, September 05, 2005 9:00 AM > To: ORACLE-L@(protected) > 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 >
-- Welcome, Fangxin.Lou from China Home: http://www.anysql.net/en/ Mydul: http://www.anysql.net/en/mydul.html
MYDUL also support the chained row/IOT, and limited support of LOBs, currently only compressed table and IOT not supported.<br><br> <div><span class="gmail_quote">On 9/10/05, <b class="gmail_sendername">Parker, Matthew</b> <<a href="mailto:matthewp@(protected)">matthewp@(protected)</a>> ; wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">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. <br><br>-- --Original Message-- --<br>From: <a href="mailto:oracle-l-bounce @(protected)">oracle-l-bounce@(protected)</a> [mailto:<a href="mailto:oracle -l-bounce@(protected)">oracle-l-bounce@(protected)</a>] On Behalf Of Lex de Haan <br>Sent: Friday, September 09, 2005 8:35 AM<br>To: Parker, Matthew; <a href= "mailto:jost@(protected)">jost@(protected)</a>; <a href="mailto:ORACLE-L @(protected)">ORACLE-L@(protected)</a><br>Subject: RE: Reading corrupted Datafiles offline <br><br><br>oh yes, Bernard did upgrade and improve DUL in may was, up to 10g. <br>chained rows are easy to follow, reading row flags, by the way...<br><br >kind regards,<br><br>Lex.<br><br>-- ---- ---- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- -- <br>Steve Adams Seminar <a href="http://www.naturaljoin.nl/events/seminars.html ">http://www.naturaljoin.nl/events/seminars.html</a><br>-- ---- ---- ---- ------ -- ---- ---- ---- ---- ---- ---- ---- ----<br>-- --Original Message-- -- <br>From: <a href="mailto:oracle-l-bounce@(protected)">oracle-l-bounce @(protected)</a> [mailto:<a href="mailto:oracle-l-bounce@(protected)">oracle -l-bounce@(protected)</a>] On<br>Behalf Of Parker, Matthew<br>Sent: Tuesday, September 06, 2005 08:42 <br>To: <a href="mailto:jost@(protected)">jost@(protected)</a>; <a href= "mailto:ORACLE-L@(protected)">ORACLE-L@(protected)</a><br>Subject: RE: Reading corrupted Datafiles offline<br><br>As Jim mentioned there is the DUL (Data Unloader ) tool that Oracle consulting <br>can use for you. The normal stated accuracy is 99% depending on your system . It<br>never understood how to follow chained rows. You are lucky to be on 8.1 .6 as<br>they never updated the tool to 9i/10g according to the developer, ( a project <br>sometime in the future for him).<br><br>Give us so more details about what exactly happened and what you have of your<br>database, then we may be able to help you.<br><br>-- --Original Message-- --<br>From: <a href="mailto:oracle-l -bounce@(protected)"> oracle-l-bounce@(protected)</a> [mailto:<a href="mailto:oracle-l-bounce @(protected)">oracle-l-bounce@(protected)</a>] On<br>Behalf Of <a href= "mailto:jost@(protected)">jost@(protected)</a><br>Sent: Monday, September 05, 2005 9:00 AM <br>To: <a href="mailto:ORACLE-L@(protected)">ORACLE-L@(protected)</a><br >Subject: Reading corrupted Datafiles offline<br><br><br><br><br><br><br>Hi list ,<br><br>assuming the following scenario:<br><br>No working Backup because of several reasons. <br>Not all datafiles of the database<br>Corrupt blocks in the datafiles we have<br><br>So, as far as i know, there no way to restore the Database in any conventional<br>way.<br><br>My question is, is there any oficiall or unoficiall way to read the data from <br>the datafiles direct?<br><br>System ist Linux and Oracle 8.1.6(!)<br><br>We need not the total whole off the data but some important tables from one<br >special tablespace.<br>I am aware of bad luck with the location of the corrupted blocks, but i will <br>give them a try ;-)<br><br>If you need more Information feel free to ask. <br><br>Thx in advance<br><br>J�rg<br><br>--<br><a href="http://www.freelists .org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a> <br>--<br><a href="http://www.freelists.org/webpage/oracle-l">http://www .freelists.org/webpage/oracle-l</a><br>--<br><a href="http://www.freelists.org /webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br></blockquote > </div><br><br clear="all"><br>-- <br>Welcome, Fangxin.Lou from China<br>Home: <a href="http://www.anysql.net/en/">http://www.anysql.net/en/</a><br>Mydul: <a href="http://www.anysql.net/en/mydul.html">http://www.anysql.net/en/mydul.html </a><br>
