Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> When database recovery is not an option

When database recovery is not an option

From: Robert Chung <robertch_at_mindspring.com>
Date: Sat, 17 Jul 1999 18:11:03 GMT
Message-ID: <3792c722.141166968@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 - 13:11:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US