Home » RDBMS Server » Server Administration » (urgent) How to repair corrupted index / block (oracle 10g RAC/ Centos)
(urgent) How to repair corrupted index / block [message #303639] Sat, 01 March 2008 05:55 Go to next message
ms_mdr
Messages: 8
Registered: January 2008
Junior Member
Dear List,

I have problems and I really needs help here..
First, I try to move all indexes from USERS tablespace to INDEX tablespace in database testing (single instance). And it worked..

Then I implement it to the live database (rac 4 nodes), but there is so much troubles.

This is the first step to implement till error comes:

1. I move all the indexes in tablespace USERS to tablespace INDEX.
ALTER INDEX ORACLE.BOOKEDINDEX1 REBUILD TABLESPACE "INDEX";
ALTER INDEX ORACLE.BOOKEDINDEX2 REBUILD TABLESPACE "INDEX";
etc

index ORACLE.BOOKEDINDEX1 and ORACLE.BOOKEDINDEX2 refers to table ORACLE.BOOKED


2. When users connect to the database, they found error like this in web browser:
-- ORA-08102: index key not found, obj# 54148 , file 10, block 234615 (and there's many error messages)

obj# 54148 belongs to ORACLE.BOOKEDINDEX2;

3. Because of the index corrupted, I move the index to the first tablespace.
ALTER INDEX ORACLE.BOOKEDINDEX1 REBUILD TABLESPACE "USERS";
ALTER INDEX ORACLE.BOOKEDINDEX2 REBUILD TABLESPACE "USERS";


4. I try to rebuild index:
ALTER TABLE oracle.booked ENABLE TABLE LOCK;
Alter index ORACLE.BOOKEDINDEX2 rebuild;
ALTER TABLE oracle.booked DISABLE TABLE LOCK;

5. Then I run this syntax:
ANALYZE TABLE ORACLE.BOOKED VALIDATE STRUCTURE ONLINE;
--no error
ANALYZE INDEX ORACLE.BOOKEDINDEX3 VALIDATE STRUCTURE ONLINE;
--no error

ANALYZE TABLE ORACLE.BOOKED VALIDATE STRUCTURE CASCADE ONLINE;
ORA-01499: TABLE/INDEX CROSS reference failure - see TRACE FILE

Actually I really confused in reading the trace file. I attached the trc file here.

The point is, what should I do with the corrupted index?


Please Help me,

thanks before.
Re: (urgent) How to repair corrupted index / block [message #303647 is a reply to message #303639] Sat, 01 March 2008 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just drop and recreate the indexes.

Regards
Michel
Re: (urgent) How to repair corrupted index / block [message #303790 is a reply to message #303647] Sun, 02 March 2008 20:51 Go to previous message
ms_mdr
Messages: 8
Registered: January 2008
Junior Member
Thank you Sir,

I've drop the indexes dan recreate it.
And it works..

thank you very much Smile
Previous Topic: Creating another database
Next Topic: patch install?
Goto Forum:
  


Current Time: Sun Dec 04 20:54:30 CST 2016

Total time taken to generate the page: 0.09539 seconds