Re: Reading corrupted Datafiles offline
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: matthewp@xxxxxxxxxx
- Date: Sat, 10 Sep 2005 09:44:33 +0800
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@xxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Lex de Haan
> Sent: Friday, September 09, 2005 8:35 AM
> To: Parker, Matthew; jost@xxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On
> Behalf Of Parker, Matthew
> Sent: Tuesday, September 06, 2005 08:42
> To: jost@xxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On
> Behalf Of jost@xxxxxxxxxxxx
> Sent: Monday, September 05, 2005 9:00 AM
> To: ORACLE-L@xxxxxxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
> --
> //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
Other related posts:
