alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated.Disconnection forced
ORA-30012: undo tablespace'db_file_name_convert' does not exist or of wrong
type
Process ID: 40271
Session ID: 1 Serial number: 3
出现这个情况可以检查下spfile文件是否有问题
MAPP1.undo_tablespace='UNDOTBS1','log_file_name_convert','db_file_name_convert'
将'log_file_name_convert','db_file_name_convert'删掉,重新导入spfile即可
导出spfile
SQL>create pfile='/tmp/pfile.1021' from spfile='+DATA/MAPPJL/spfilemapp.ora';
File created.
将MAPP1.undo_tablespace='UNDOTBS1','log_file_name_convert','db_file_name_convert'
替换为MAPP1.undo_tablespace='UNDOTBS1'
将pfile导入成spfile
SQL>create spfile='+DATA/MAPPJL/spfilemapp.ora' from pfile='/tmp/pfile.1021' ;
启动数据库
SQL>startup mount;
ORACLE instance started.
Total System Global Area 1336176640 bytes
Fixed Size 2228144 bytes
Variable Size 671088720 bytes
Database Buffers 654311424 bytes
Redo Buffers 8548352 bytes
Database mounted.
SQL>alter database open;
Database altered