ORA-01092 ORACLE instance terminated. Disconnection forced Cause The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance. ------------- Action Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again ------------- 重启一下.
要是你不是生产系统的话,先shutdown immediate; 再startup;
如果是undotbs01.dbf坏了,那么: 先让该文件下线 alter database datafile 'undotbs01.dbf的全路径及文件名' offline; (如果当前不是归档状态则会报错,则先打这两个命令,进入归档状态,再用上面的命令 alter database archivelog; archive log start) 打开数据库 alter database open; 创建新的undo表空间 create undo tablespace undo1(新的表空间名) datafile '新的数据文件全路径及文件名' size 200M autoextend on; 把系统指定的undo表空间改为新的 alter system set undo_tablespace=undo1; 删除坏了的表空间 drop tablespace undotbs1; 修改init实例名.ora文件 把undo_tablespace=undotbs1 改为undo_tablespace=undo1 注意:如果原来数据库是非归档状态的,那么你还需要恢复为非归档状态 shutdown startup mount alter database noarchivelog; archive log stop alter database open; 终于好了
Action Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again
-------------
重启一下.
再startup;
先让该文件下线
alter database datafile 'undotbs01.dbf的全路径及文件名' offline;
(如果当前不是归档状态则会报错,则先打这两个命令,进入归档状态,再用上面的命令
alter database archivelog;
archive log start)
打开数据库
alter database open;
创建新的undo表空间
create undo tablespace undo1(新的表空间名)
datafile '新的数据文件全路径及文件名' size 200M
autoextend on;
把系统指定的undo表空间改为新的
alter system set undo_tablespace=undo1;
删除坏了的表空间
drop tablespace undotbs1;
修改init实例名.ora文件
把undo_tablespace=undotbs1
改为undo_tablespace=undo1
注意:如果原来数据库是非归档状态的,那么你还需要恢复为非归档状态
shutdown
startup mount
alter database noarchivelog;
archive log stop
alter database open;
终于好了