Bug 12537403 : ORA-00701 ON I_OBJ1 INDEX REBUILD

Bug 12537403 : ORA-00701 ON I_OBJ1 INDEX REBUILD

 

Bug 属性 …

---

类型	B - Defect	已在产品版本中修复
严重性	2 - Severe Loss of Service	产品版本	11.2.0.1
状态	31 - Could Not Reproduce. To Filer	平台	226 - Linux x86-64
创建时间	2011-5-10	平台版本	RED HAT ENTERPRISE LINUX 5
更新时间	2011-5-30	基本 Bug	N/A
数据库版本	11.2.0.1	影响平台	Generic
产品源	Oracle

相关产品 …

---

产品线	Oracle Database Products	系列	Oracle Database
区域	Oracle Database	产品	5 - Oracle Server - Enterprise Edition

Hdr: 12537403 11.2.0.1 RDBMS 11.2.0.1 UPGRADE PRODID-5 PORTID-226

Abstract: ORA-701 ON I_OBJ1 INDEX REBUILD
 
*** 05/09/11 11:50 pm ***
----
3-3547853711
 
PROBLEM:
--------
++ Corrupted index due to ORA-8102. 
 
++ DDLs are failing in this database due to above problem.
 
++ The index associated with OBJ$.
 
++ Customer doesn't have valid backups to recover from.
 
++ Suggested following to fix the corruption in index on OBJ$ :
 
 
1. shutdown immediate
2. startup migrate / upgrade
3. >alter index i_obj1 rebuild online;
   >alter index i_obj2 rebuild online;
   >alter index i_obj3 rebuild online;
   >alter index i_obj4 rebuild online;
4. shutdown immediate
5. startup
 
 
Rebuilding index above is failing as below:
 
SQL>  alter index i_obj1 rebuild online ;
alter index i_obj1 rebuild online
*
ERROR at line 1:
ORA-701: object necessary for warmstarting database cannot be altered
 
DIAGNOSTIC ANALYSIS:
--------------------
 
WORKAROUND:
-----------
 
RELATED BUGS:
-------------
Bug 12387213: ORA-1578 SYS INDEX SYS.I_OBJ1 IN SYSTEM TABLESPACE CORRUPTION
 
REPRODUCIBILITY:
----------------
yes. on any 11.2.0.1 datadbase
 
TEST CASE:
----------
 
STACK TRACE:
------------
 
SUPPORTING INFORMATION:
-----------------------
 
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
 
DIAL-IN INFORMATION:
--------------------
 
IMPACT DATE:
------------
 
*** 05/09/11 11:52 pm ***
*** 05/09/11 11:59 pm ***
*** 05/10/11 01:35 am *** (CHG: Sta->10 Asg->JBARLOW)
*** 05/10/11 01:35 am ***
*** 05/30/11 04:58 am *** (CHG: Sta->31)
*** 05/30/11 04:58 am ***

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17252115/viewspace-753110/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17252115/viewspace-753110/