问题分析:根据错误提示内容为打开UNDO表空间是出错(发现UNDO表空间不存在或者类型错误),所以此时数据应该是可以启动到mount状态
SQL> startup mount;
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 415236968 bytes
Database Buffers 113246208 bytes
Redo Buffers 3764224 bytes
Database mounted.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
undo_management string AUTO
undo_retention integer 1
undo_tablespace string UNDOTBS3
SQL> select name from v$tablespace where name like '%UNDO%';
NAME
------------------------------------------------------------------------------------------
UNDOTBS1
UNDOTBS2
由上面的信息可知,参数文件中记录的UNDO表空间和控制文件中记录的UNDO表空间不一致
问题处理:修改参数文件中的*.undo_tablespace='UNDOTBS3'为*.undo_tablespace='UNDOTBS1',然后重新启动数据库,正常。
SQL> startup mount;
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 415236968 bytes
Database Buffers 113246208 bytes
Redo Buffers 3764224 bytes
Database mounted.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
undo_management string AUTO
undo_retention integer 1
undo_tablespace string UNDOTBS3
SQL> select name from v$tablespace where name like '%UNDO%';
NAME
------------------------------------------------------------------------------------------
UNDOTBS1
UNDOTBS2
由上面的信息可知,参数文件中记录的UNDO表空间和控制文件中记录的UNDO表空间不一致
问题处理:修改参数文件中的*.undo_tablespace='UNDOTBS3'为*.undo_tablespace='UNDOTBS1',然后重新启动数据库,正常。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2101079/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30373263/viewspace-2101079/