Re: ORA-01578: ORACLE data block corrupted (file # 1, block # 13559)

"Grabowy, Chris" wrote:
>
> This morning I got a CD full of data files from a remote client database
> server that went belly up. This production database (8.1.5 on NT) was put
> together by a group of developers with no backups setup. They sent the CD
> to me in hopes that I could recover the database. I laid the files down on
> my NT laptop and got the database up. I went to execute an export and got
> ORA-01578.
>
> I executed DBV against a few of the data files. The SYSTEM tablespace has
> 18 corrupt blocks and USERS has over 80 corrupt blocks. Just about every
> query against the dictionary is returning ORA-01578. For example, I get
> ORA-01578 when I try to figure out the object name for a corrupt block.
>
> So now I'm trying to figure out what my options are. I'm scanning books and
> Metalink, but I'm not finding much. Am I missing something? Help?
>
> Many TIA.
>
> Chris
> "Oracle is not with me...today"

If your database is worth it (i.e. if rebuilding it from scratch would be extremely costly) the only option you have is to ask for somebody form the Oracle Support to come with DUL, a tool written by one of their Dutch consultants which tries (no guarantee, even if in practice it's an effective tool) to make sense out of corrupted files and generate a .dmp or flat file for reloading what can be saved. But you will have to fork out $$$.
Otherwise, but the sad state of your dictionary will probably make this very difficult, you can try so SELECT round the corrupted blocks, and try to patch the missing pieces with whatever you can retrieve from indexes. This would mean that you have a list of tables and know where indexes are. Likely to be very time consuming, with a rather dim hope to get a usable result in the end.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).