admin管理员组文章数量:1654384
转自 http://mojijs/2014/03/131121/index.html http://mojijs/
ORA-01157: cannot identify/lock data file 6 – see DBWR trace file
标 签: see DBWR trace file file 6 data cannot identify lock ORA-011572个月以前使用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;
FILE# NAME
———- ————————————————–
1 /Data/oradata/ora11g/system01.dbf
2 /Data/oradata/ora11g/sysaux01.dbf
3 /Data/oradata/ora11g/undotbs01.dbf
4 /Data/oradata/ora11g/users01.dbf
5 /Data/oradata/ora11g/example01.dbf
6 /Data/oradata/ora11g/ccdata.dbf
7 /Data/oradata/datafile/dp01.dbf
SQL> alter database datafile 6 offline;
Database altered.
SQL> alter database open;
Database altered.
SQL> DROP TABLESPACE CCDATA INCLUDING CONTENTS AND DATAFILES;
Tablespace dropped.
SQL> col file_name for a35;
SQL> col tablespace_namefor a15;
SQL> select tablespace_name,file_name from dba_data_files
TABLESPACE FILE_NAME
———- ———————————–
USERS /Data/oradata/ora11g/users01.dbf
UNDOTBS1 /Data/oradata/ora11g/undotbs01.dbf
SYSAUX /Data/oradata/ora11g/sysaux01.dbf
SYSTEM /Data/oradata/ora11g/system01.dbf
EXAMPLE /Data/oradata/ora11g/example01.dbf
DP_TABLE /Data/oradata/datafile/dp01.dbf
6 rows selected.
至此问题已经解决
测试库,暂时用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.
Database opened.
警示:正式库DB万万不要手动rm 数据文件
本文标签: identifyLockORAdbwrTrace
版权声明:本文标题:ORA-01157: cannot identifylock data file 6 – see DBWR trace file 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dianzi/1729650525a1208985.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论