环境介绍:os:redhat linux;oracle:9.2.0.4;存储:emc raw
故障描述:
Fri Feb 23 02:24:59 2007
Errors in file /oracle/admin/ops1/udump/ops1_ora_5038.trc:
ORA-08103: object no longer exists
Error 8103 happened during db open, shutting down database
USER: terminating instance due to error 8103
Instance terminated by USER, pid = 5038
ORA-1092 signalled during: ALTER DATABASE OPEN...
故障处理:
1、增加event,定位是8103的具体错误:
event = '8103 trace name errorstack level 3'
trace中显示:
sid_smon_pid.trc显示:UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIME_DP=:4 WHERE TIME_MP = :5 AND THREAD = :6 AND ROWNUM <= 1
udump_trace显示:update lob$ set retention = :1 where retention >= 0
2、增加event看能否跳过8103错误
event='10231 trace name context forever, level 10'
event='10232 trace name context forever, level 10'
event='10233 trace name context forever, level 10'
3、不能跳过8103,强制打开数据库
修改:undo_management from auto to manual;
注释undo_tablespace=undo1
增加:_ALLOW_RESETLOGS_CORRUPTION=TRUE
_CORRUPTED_ROLLBACK_SEGMENTS = (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$,_SYSSMU11$,_SYSSMU12$,_SYSSMU13$,_SYSSMU14$,_SYSSMU15$,_SYSSMU16$,_SYSSMU17$,_SYSSMU18$,_SYSSMU19$,_SYSSMU20$,_SYSSMU21$,_SYSSMU22$,_SYSSMU23$,_SYSSMU24$,_SYSSMU25$,_SYSSMU26$,_SYSSMU27$,_SYSSMU28$,_SYSSMU29$,_SYSSMU30$)
_OFFLINE_ROLLBACK_SEGMENTS = (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$,_SYSSMU7$,_SYSSMU8$,_SYSSMU9$,_SYSSMU10$,_SYSSMU11$,_SYSSMU12$,_SYSSMU13$,_SYSSMU14$,_SYSSMU15$,_SYSSMU16$,_SYSSMU17$,_SYSSMU18$,_SYSSMU19$,_SYSSMU20$,_SYSSMU21$,_SYSSMU22$,_SYSSMU23$,_SYSSMU24$,_SYSSMU25$,_SYSSMU26$,_SYSSMU27$,_SYSSMU28$,_SYSSMU29$,_SYSSMU30$)
STARTUP MOUNT;
select member from v$logfile where group#=(select distinct group# from v$log where status='CURRENT' and thread#=1);
recover database unti cancel;(recover database using backup control unitl cancel;)
录入刚才取出的当前logfile's name;
alter database open resetlogs;
处理结果:数据库成功强制启动。
后续工作:导出数据重新建库。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/561839/viewspace-900418/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/561839/viewspace-900418/