Re: When database recovery is not an option

Firstly try pulling the data out of the table by rowid, that way you can skip the rows that are contained in the corrupt block...

--
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

Daniel
Oracle UK

Robert Chung <robertch_at_mindspring.com> wrote in message news:3792c722.141166968_at_news.mindspring.com...
>
> A DBA that I know has Oracle database with corrupt data blocks.
> Database is in archive log mode and he does have backup, but cannot
> recover database because his machine is under-powered (Last time when
> they experienced database failure and restored database, it took THREE
> DAYS just to restore data files from their cheap slow tape device and
> apply archive logs. The database was down for three days!)
>
> So he is trying to somehow extract data from his corrupt data files.
> Oracle database reports corrupt data blocks and refuses to extract any
> more data from his tables. "export" utility is not working either.
> Is there any way to get some of clean data back? Possibly reading
> data file binary dump? He does not need to recover 100% of database.
> The company is willing to accept 90% of recovery or more. Thank you
> in advance.
>
>
Received on Mon Jul 19 1999 - 07:34:33 CDT