如果直接删除数据库后,再次启动会报错。
处理过程为:
1)sqlplus / as sysdba
2)startup nomount
3)alter database mount
4)alter datafile 1 offline
方法:
alter database datafile '路径和文件' offline;
提示:
system01.dbf不能offline.
5)select * from gv$datafile;
6)alter database open;
7)select instance_name,status from v$instance;