sysaux损坏

数据库自动关闭

1.日志

ORA-00600: internal error code, arguments: [6001], [0], [], [], [], [] 
, [], [] 
ORACLE Instance prod (pid = 7) - Error 600 encountered while recovering 
transaction (4, 43) on object 8799.

2.  select object_name,object_type from dba_objects where data_object_id=8799;

SYS_IOT_TOP_8798

怀疑是索引坏了，于是重建索引

3. 发现重现索引失败

SQL> ALTER INDEX SYS_IOT_TOP_8798 REBUILD ONLINE;
ALTER INDEX SYS_IOT_TOP_8798 REBUILD ONLINE
*
ERROR at line 1:
ORA-28650: Primary index on an IOT cannot be rebuilt

怀疑是表坏了

4.看看这个索引是建立在哪个表上

SQL> select table_name from dba_indexes where index_name='SYS_IOT_TOP_8798';

5.查这个表试试

select count(*) from AQ$_ALERT_QT_H
                     *
ERROR at line 1:
ORA-00600: internal error code, arguments: [6101], [6], [31], [25], [], [], [],
[]

6.果然是他的问题

删除数据，

重启数据库

7.

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_529.trc:
ORA-01578: ORACLE data block corrupted (file # 3, block # 45818)
ORA-01110: data file 3: '/u01/app/oracle/oradata/orcl/sysaux01.dbf'
Sun Sep 27 10:19:23 2009
Corrupt Block Found
         TSN = 2, TSNAME = SYSAUX
         RFN = 3, BLK = 45818, RDBA = 12628730
         BJN = 8787, BJD = 8787, BJECT = ALERT_QT, SUBOBJECT = 
         SEGMENT WNER = SYS, SEGMENT TYPE = Table Segment

8.

alter system enable restricted session;
@$ORACLE_HOME/rdbms/admin/catnoalr.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
alter system disable restricted session;

总算OK了

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

转载于:http://blog.itpub.net/563971/viewspace-615865/