误删表空间解决方法

数据库在运行的时候，用plsql删除了一个表空间，重启后，表空间就打不开了
然后报错

startup后，报无法打开表空间。

Total System Global Area 1603411968 bytes
Fixed Size 2144824 bytes
Variable Size 587204040 bytes
Database Buffers 1006632960 bytes
Redo Buffers 7430144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/opt/oracle/oradata/orcl/BICP_DATA.dbf'

解决方法：

SQL> startup mount
SQL> alter database datafile ‘/opt/oracle/oradata/ora92/plt123.dbf’ offline drop;
SQL> alter database open;
SQL> drop tablespace plt123 including contents and datafiles;