ORA-30012错误

今早朋友告诉我ta数据库启动不了，

登陆数据库

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 27 13:56:31 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 1262176 bytes
Variable Size 427822496 bytes
Database Buffers 159383552 bytes
Redo Buffers 11317248 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

alert中错误信息如下：

ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type

查看unotabs数据文件也存在，表空间状态也是online的.

create pfile='/opt/oracle/t.ora' from spfile

shudown immdiate

vi /opt/oracle/t.ora

修改undo_management='manual',undo_tablespace='system'

sqlplus /nolog

SQL>startup pfile='/opt/oracle/t.ora'

SQL> startup
ORACLE instance started.

Total System Global Area 1026234384 bytes
Fixed Size                   452624 bytes
Variable Size             385875968 bytes
Database Buffers          637534208 bytes
Redo Buffers                2371584 bytes
Database mounted.
Database opened.

SQL>create tablespace undo_tbs datafile '/xxx/xxx/undo_tbs.dbf' size 500M

vi  /opt/oracle/t.ora

修改undo_management='auto',undo_tablespace='undo_tbs'

SQL>create spfile from pfile='/opt/oracle/t.ora'

然后重新启动就好了