Re: Error 1578

Thanks you for the reply

My main concern is why it happened and how to prevent from happening. You mention that there is some event which can be set so that while writing oracle/os should not write the corrupt data. Do oracle/os checks whether the data block written got corrupted during the write. Which I think no way. Also I did not claimed that 1578 is caused by hardware/os malfunction. Oracle customer support said that it could be disk media failure or controller failure and so on. A simple example of real life is .. you found a wrecked car on the highway... you do know whose car it belong to, you do know accident happened just by looking at it but you do not know how it happened do you. Just a simple example.

Also my problem or 1578 is during the read only. I do agree that it will not happen with database restored from backup. We have identical sites running in production where all the hardware and software configuration are same. Also new site's system was created with backup from old site.

Thank you once again...
Pradhan

Jonathan Lewis wrote in message
<929300295.9676.1.nnrp-11.9e984b29_at_news.demon.co.uk>...
>There is an event to set in the 10,000 range
>(can't remember which one at present, and
>don't have HP running) which checks for
>logically corrupt blocks BEFORE writing
>them.
>
>Obviously there is a CPU overhead involved, but
>if you set this event and get 1578s without any
>reports of logically bad writes then you can blame
>the hardware/OS.
>
>If you get logical writes, then you absolve the hardware/OS
>
>I don't suppose this happens in a database which you've
>restored from a backup does it ?
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>Pradhan wrote in message <4FS83.3181$m93.15584_at_newsfeed.slurp.net>...
>>Hi all
>>
>> This specific error does not occur so often. But when it occurs there is
>>only way out which is drop the particular segment and recreate the
>segment.
>>I am trying to resolve one problem why it happens?
>>
>>So far, to my understanding it happens only when oracle trying to read a
>>block of data and it find the discrepancies in its block header and
footer.
>
>
>
Received on Mon Jun 14 1999 - 19:38:18 CDT