ORA-8102, why?

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Wed, 16 Jan 2008 05:55:31 -0800 (PST)
Message-ID: <26ce818d-7d12-4eb7-b0c1-221cf4aae15d@x69g2000hsx.googlegroups.com>

i've an Oracle database with RAC 2 node version on Linux Suse SLES9 64 bit. Recently i've
got an error ORA-8102 during the execution of a procedure that was deleting some records. So i have found that there are two records (the table has over 90 milions of records) for which there are no corresponding index entry on one of the indexes. I've read metalink notes 395006.1 and 1081343.6 and i can't understand how can it happen. The note 395006.1 say's about "lost write ore some similar OS issue" but how can be that there are no database block corruptions? The notes say also that dropping and recreating the index does not solve the issue. How can it be? is there anyone that can explain me that? Since the problem occurs only when i try to change the value of the indexed column for the two record or to delete the records i've choose to let things as are now, because exporting e reimporting  the entire table woud be to expensive.


Cristian Cudizio
http://cristiancudizio.wordpress.com Received on Wed Jan 16 2008 - 07:55:31 CST

Original text of this message