日期:2014-05-16 浏览次数:20554 次
2个月以前使用swingbench的时候,cc这个user创建了17GB的测试数据(ccdata.dbf),后面测试完成后,
因为是测试机,空间不足,直接手动rm –rf /Data/oradata/ora11g/ccdata.dbf这个文件
之后因其他测试时重启DB时碰到了ORA-01157错误,
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/Data/oradata/ora11g/ccdata.dbf'
root case:手动ccdata.dbf文件,既然问题已经知道,那就下手处理吧:
ora11g</Data/oradata/ora11g>$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 27 08:28:41 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup force;
SQL> startup force;
ORACLE instance started.
Total System Global Area 7816675328 bytes
Fixed Size 2243712 bytes
Variable Size 4529849216 bytes
Database Buffers 3271557120 bytes
Redo Buffers 13025280 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/Data/oradata/ora11g/ccdata.dbf'
SQL> col file# for a10;
SQL> col name for a50;
SQL> select file#,name from v$datafile;