linux环境下oracle数据库启动报错：ORA-01157，ORA-01110

su - oracle

sqlplus / as sysdba

SQL>startup

.......

ORA-01157: cannot identify/lock data file 13 - see DBWR trace file

ORA-01110: data file 13: '/data/.....

处理方法：

SQL>shutdown

进入mount状态

SQL> startup mount
 

将异常的数据文件进行offline drop
SQL> alter database datafile 13 offline drop;
SQL> shutdown immediate

然后重新启动即可
SQL> startup