问题:操作系统命令不小把数据库的数据文件删除了,数据库启动报错 ORA-01157 ORA-01110
1.把数据库启动到mount
SQL> Startup mount
2.把数据文件离线并删除
SQL> Alter database datafile <datafile> offline drop;
3.打开数据库
SQL> Alter database open ;
4.删除表空间
SQL> Drop tablespace <tablespace> including contents;
( tablespace to which the datafile belonged, first check if any other datafiles
belong to the same tablespace )
5.重新建立表空间
Recreate the tablespace afterwards.
6.导入业务数据