alert日志的报错内容
Mon Oct 20 12:35:05 2014 Errors in file d:oracleproduct10.2.0adminwuqidumpwuqi_dbw0_1664.trc: ORA-01157: ????/?????? 78 - ??? DBWR ???? ORA-01110: ???? 78: 'G:ORACLEWSZBWSXXZB_DATA02.DBF' ORA-27041: ?????? OSD-04002: unable to open file O/S-Error: (OS 3) 系统找不到指定的路径。 Mon Oct 20 12:35:05 2014 Errors in file d:oracleproduct10.2.0adminwuqidumpwuqi_dbw0_1664.trc: ORA-01157: ????/?????? 81 - ??? DBWR ???? ORA-01110: ???? 81: 'G:ORACLEWSZBWSTJFX.DBF' ORA-27041: ?????? OSD-04002: unable to open file O/S-Error: (OS 3) 系统找不到指定的路径。
此时数据库无法打开
数据库启动到mount状态:
alter database datafile 'G:ORACLEWSZBWSXXZB_DATA02.DBF' offline drop;
alter database datafile 'G:ORACLEWSZBWSTJFX.DBF' offline drop;
alter database open;
--查看datafile对应的表空间
select * from dba_data_files t where t.file_name in('G:ORACLEWSZBWSXXZB_DATA02.DBF','G:ORACLEWSZBWSTJFX.DBF');
--查看tablespace对应的数据文件
select * from dba_data_files t where t.TABLESPACE_NAME in('WSTJFX','WSXXZB_DATA');
--表空间WSTJFX只对应一个数据文件
drop tablespace WSTJFX including contents ;