sys@ORCL>shutdown immediate; ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/

误删了数据文件，关闭实例时报错

sys@ORCL>shutdown immediate;
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/opt/oracle/oradata/orcl/users01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
sys@ORCL>
sys@ORCL>
sys@ORCL>alter database datafile '/opt/oracle/oradata/orcl/users01.dbf'
  2  offline drop;

Database altered.

解决办法：

>alter database datafile '/opt/oracle/oradata/orcl/users01.dbf' offline drop;

drop tablespace users01 including contents;