日期:2014-05-16  浏览次数:20531 次

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

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;