RE: ORA - 1578 - ORACLE data block corrupted - URGENT!!!

Oracle has a good white paper on Metalink. If you call Oracle Support they'll email it to you... Or at least they did that for me. It talks about recreating the object, in this case

CREATE TABLE bleah
SELECT *
FROM corrupted_table
WHERE rowid < rowid of corrupted block
AND rowid > rowid of corrupted block.

I don't recall how you get the rowid, but the note from Metalink will have it. BTW, the data in the corrupted block is lost. Even if you were in archive log mode, you can only roll forward until just before the corruption happened. The corruption is in the archive logs..... I think, not sure about that part.

HTH
Lyall Barbour

At 08:55 AM 8/22/00 -0800, you wrote:
>You can replace the datafile(s) but if you are not in archivelog mode then
>it will not be able to do media recovery and data will be lost.
>
>-----Original Message-----
>Sent: Tuesday, August 22, 2000 11:02 AM
>To: Multiple recipients of list ORACLE-L
>
>
>hi gurus,
>
>OS - NT 4
>ORACLE - 7.3.4.4
>Mode - No Archive log
>
>When accessing db, i am getting the ora 1578.... (file id 8 and block id
>889).. I have found the datafile and the segment also. In that particular
>segment one big table is there. i couldn't able to access the table. Is it
>logical corruption or Physical? retrieving from the cold backup is the only
>way ?
>
>
>Thnx & Regds,
>
>Svenki
>
>
>"This communication is for the exclusive use of the intended recipient/s
>and shall not attach any liability on the originator. It may contain
>information which is confidential and legally privileged and the same
>shall not be used or dealt with by any third party in whatsoever manner."
>
>
>
>
>
>--
>Author: Miller, Bryan
> INET: MillerB_at_telergy.net
>
>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).
Received on Tue Aug 22 2000 - 13:07:45 CDT