原因:通过语句批量动态删除用户对象,估计是删除了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
--重新恢复主库到出现问题的时间点之前一点点
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;
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
- Startup the database in upgrade mode:
SQL> STARTUP UPGRADE - 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 - To re-compile the PL/SQL objects, execute
SQL> @?/rdbms/admin/utlrp.sql
--重新恢复主库到出现问题的时间点之前一点点
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/