Alejandro Vargas' Blog

  • July 22, 2007

ORA-1410 invalid row id

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

Problem solving strategies sometimes find clear causes and answers and sometimes not, in this case analyzing the facts did show the way to find a workaround.

It happened on a multi TB RAC Database.

Symptoms observed were that queries on a partitioned table started to fail with ORA-1410 on some partitions.

The initial diagnostic was of a logical corruption affecting one specific datafile, in this case a shared raw device. Some of these partitions were dropped and recreated using create as select from a backup.

Once the create as select finished, checkup on the new partitions again returned ORA-1410, all traces pointing to the same raw device.

The common factor was always the same device. Building a new raw device and moving all partitions siting on the affected one solved the problem.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.