ora-01157怎么解决

在数据库startup时,出现以下两个错误:
ora-01157:cannot identify/lock data file 8 -see DBWR trace file
ora-01110:data file 8 : '/data/app/oradata/zcmp/users01.dbf'

 

shutdown immediate;
startup mount;
alter database datafile '/data/app/oradata/zcmp/users01.dbf' offline;
alter database open;

转载于:https://www.cnblogs.com/zwl715/p/3724936.html