Re: When database recovery is not an option

Hi:

If your table has primary key, you can skip corrupted block by select * from tab where (primary key) < '...' or (primary key) > '...' Since Oracle will access index before access real data, the corrupted data block will not be accessed.

Good luck!

Michael.

Robert Chung <robertch_at_mindspring.com> wrote in message news:3790c6d2.141086500_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 Sat Jul 17 1999 - 22:23:51 CDT