今天在做undo切换的时候,遇到如下错误:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type
原因是表空间类型创建的有问题
首先
startup mount;
create pfile='/u01/init.ora' from spfile;
shutdown immediate;
修改pfile文件
然后startup pfile='/u01/init.ora' ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8183550/viewspace-667834/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8183550/viewspace-667834/