Re: Error 1578

On the other hand, if there are 45 empty beer bottles on the front seat, you can sketch out a couple of reasonable guesses.

The purpose of suggesting the events (which are 10210 for tables, 10211 for indexes and 10212 for clusters) is that it stops the ping-ping match where Oracle blames the O/S and IBM (it was an AIX box ?) blames Oracle.

With the event set, Oracle will check that the blocks are logically sound - in which case any errors at read time must be down to an O/S error fouling the block either on writing or on reading. If Oracle starts reporting logical errors at write time then the Oracle code is causing the problem. NB before setting these events, check with your local Oracle support.

Re: your comnet:

>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.

My original question about the database being a restored backup was heading in completely the opposite direction - how confident are you that the backup is a clean backup, or that the backup restored properly ?

You seem to be saying that it is only the recovered database that is throwing out the errors - I would be inclined to suspect the backup/recovery process.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Pradhan wrote in message <_eh93.183$B04.1170_at_newsfeed.slurp.net>...

>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.