Re: When database recovery is not an option

From: Van Messner <vmessner_at_netaxis.com>
Date: Sat, 17 Jul 1999 22:11:12 -0400
Message-ID: <JPak3.967$t04.21349@typ31b.nn.bcandid.com>

If he's running Oracle 8.1 there's a built in package - something like DBMS_Repair - that may fix his corrupt blocks. It can be run while the database is still in operation.

Van

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 - 21:11:12 CDT