ERROR:         ORA-01548
date:          2010-3-16
platform.:      9.2.0.1 + NT
related views:  V$ROLLSTAT,V$ROLLNAME,dba_rollback_segs;

case: 客户从OEM中加大回滚表空间,导致DB当机,进而引起主机死机.
----以下内容摘自:alert.log
Thu Mar 04 15:49:48 2010
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\TAIKANG\UNDOTBS01.ORA' RESIZE  20480M
Thu Mar 04 15:50:32 2010
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Thu Mar 04 15:50:34 2010
KCF: write/open error block=0x54d49 nline=1
     file=24 D:\ORACLE\ORADATA\TAIKANG\UNDOTBS01.ORA
     error=27069 txt: 'OSD-04026: 传递的参数无效。 (OS 347465)'
Thu Mar 04 15:50:34 2010
Errors in file d:\oracle\admin\taikang\bdump\taikang_dbw0_3436.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 24 (block # 347465)
ORA-01110: data file 24: 'D:\ORACLE\ORADATA\TAIKANG\UNDOTBS01.ORA'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: 传递的参数无效。 (OS 347465)

DBW0: terminating instance due to error 1242
Thu Mar 04 15:50:36 2010
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Sat Mar 06 18:51:24 2010
Errors in file d:\oracle\admin\taikang\udump\taikang_ora_244.trc:
ORA-00600: 内部错误代码，参数: [2006], [], [], [], [], [], [], []

而后大量出现:
SMON: about to recover undo segment 1
SMON: mark undo segment 1 as available
SMON: about to recover undo segment 1
SMON: mark undo segment 1 as available
SMON: about to recover undo segment 1
SMON: mark undo segment 1 as available
SMON: about to recover undo segment 1
SMON: mark undo segment 1 as available

analyze:

action:
shutdown immediate;
startup nomount;
create pfile from spfile;

设置和启用隐藏参数:
UNDO_MANAGEMENT=MANUAL
_OFFLINE_ROLLBACK_SEGMENTS=(_SYSSMU1$,....) --此为出错的回滚段名,以逗号分隔.

startup pfile=D:\init.ora;
drop rollback segment "_SYSSMU1$"; --删除所有出错的回滚段.
drop tablespace undotbs01 including contents and datafiles;
shutdown immediate;
startup; --使用spfile重启.

错误解决!
--End--