ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01110: data file 19: '/home/oracle/data/istonebak_tb.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /oracledata/u01/app/oracle/diag/rdbms/acic/acic/trace/acic_ora_22
250.trc:
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/home/oracle/data/istonenak_tb'
ORA-1157 signalled during: ALTER DATABASE OPEN...
Wed Mar 27 16:24:00 2013
文件根本就不存在,不知道是谁删除了,鉴于不重要,所以删除即可,如果重要没办法只有恢复了,但是MOUNT状态是不能删除表空间的
如下:
alter database mount;
alter database datafile 'file_name' offline drop; --把数据文件设置为离线REOVER状态。
alter database open;
drop tablespace **;
当然如果是一个数据文件就删除这个文件就好了
alter tablespace users drop datafile '/opt/oracle/oradata/eygle/users02.dbf';
参考:
http://blog.csdn.net/tianlesoftware/article/details/6305600
在线移动数据文件
1.alter tablespace tbs read only;
2.alter tablespace tbs offline;
3.在offline后拷贝一份原文件,并命名为新文件名
4.alter tablespace tbs rename datafile 'tbs_file_old.dbf' to 'tbs_file_new.dbf';
5.alter tablespace tbs online;
6.alter tablespace tbs read write;