| (urgent) How to repair corrupted index / block [message #303639] |
Sat, 01 March 2008 05:55  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
