ORA-00600: internal error code, arguments: [kokiasg1]及ORA-04063错误

原因:通过语句批量动态删除用户对象,估计是删除了sys用户下一些对象,直接导致数据库宕掉

ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validation
ORA-04063: package body "SYS.DBMS_LOGSTDBY" has errors
Thu Mar 03 18:04:53 2016
Errors in file /u01/app/oracle/diag/rdbms/jin/jin/trace/jin_cjq0_3848.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04063: package body "SYS.DBMS_LOGSTDBY" has errors
Errors in file /u01/app/oracle/diag/rdbms/jin/jin/trace/jin_cjq0_3848.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04063: package body "SYS.DBMS_LOGSTDBY" has errors
Thu Mar 03 18:05:03 2016
Errors in file /u01/app/oracle/diag/rdbms/jin/jin/trace/jin_cjq0_3848.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04063: package body "SYS.DBMS_LOGSTDBY" has errors

启动直接报错
sql>startup upgrade
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [],
[], [], [], [], []
Process ID: 19958
Session ID: 232 Serial number: 3

ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/oracle/diag/rdbms/jin/jin/trace/jin_ora_19958.trc:
ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []
上面错误应该是删除了sys用户下很多对象导致的,MOS也是建议重建数据字典

Mos:1085825.1

1. Startup the database in upgrade mode:
       SQL> STARTUP UPGRADE
2. Run catalog.sql or catproc.sql scripts as below (or instead you can run catupgrd.sql)
       SQL> @?/rdbms/admin/catalog.sql
       SQL> @?/rdbms/admin/catproc.sql
3. To re-compile the PL/SQL objects, execute
       SQL> @?/rdbms/admin/utlrp.sql 

但本案例启动到upgrade就报错,后来选择的方案是rman不完全恢复搞定
--重新恢复主库到出现问题的时间点之前一点点
startup mount;
run{
set until time "to_date('2016-03-03 17:20:00','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
}
sql> alter database open resetlogs;
SQL> shutdown immediate;
SQL> startup;

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

转载于:http://blog.itpub.net/61604/viewspace-2039655/