ORA-01157与ORA-01110错误解决

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

ORA-01110: data file 7: '/testC/DBFdata/jinlian_index.dbf'

解决方法；

shutdown immediate

startup mount

alter database datafile '/testC/DBFdata/jinlian_index.dbf' offline drop;

alter database open;

alter tablespace jinlian_index rename datafile 

'/testC/DBFdata/jinlian_index.dbf' to '/testA/data/jinlian_index.dbf'