1.问题描述:
在Oradata/Oracle实例下删除了某个表空间.dbf文件,重新启动Oracle服务时候,报错:
SVRMGR> startup ORACLE instance started.
Total System Global Area 84721824 bytes Fixed Size 73888 bytes Variable Size 76087296 bytes Database Buffers 8388608 bytes Redo Buffers 172032 bytes Database mounted.
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file ORA-01110: data file 8: '/export/home1/ora8/m02/oradata/ora8/acs01.dbf'
2.处理步骤
1) Connect to SQL*DBA or Server Manager and issue 'shutdown abort'
2) Issue 'startup mount' command
3) Issue the following command, substituting the correct datafile (such as /u01/oradata/temp01.dbf):
alter database datafile '/u01/oradata/temp01.dbf' offline drop;
4) alter database open; (Your database is now up!!!)
5) drop tablespace TEMP including contents;
6)再次重新启动既可.