Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> When database recovery is not an option
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
![]() |
![]() |