诗檀软件专业数据库修复团队
ORA-01157
oerr ora 1157
01157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
// *Cause: The background process was either unable to find one of the data
// files or failed to lock it because the file was already in use.
// The database will prohibit access to this file but other files will
// be unaffected. However the first instance to open the database will
// need to access all online data files. Accompanying error from the
// operating system describes why the file could not be identified.
// *Action: Have operating system make file available to database. Then either
// open the database or do ALTER SYSTEM CHECK DATAFILES.
适用于：
Oracle Database - Enterprise Edition – 版本11.2.0.4 及以上
本文信息适用于任何平台。
*** 于22-Mar-2016 检查相关性***
症状
# Startup upgrade from 11.2.0.4 home fails
# ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
# ORA-01110: data file 6: '/oraapps/tst7/tst7data1/eul01.dbf'
在跟踪文件中能注意到类似信息：
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 6: '/oraapps/tst7/tst7data1/eul01.dbf'
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/oraapps/tst7/tst7data1/eul01.dbf'
在mount后显示的锁信息：
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2138521600 bytes
Fixed Size 2183272 bytes
Variable Size 1157631896 bytes
Database Buffers 956301312 bytes
Redo Buffers 22405120 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/oraapps/tst7/tst7data1/eul01.dbf'
更改
升级数据库发布版本
原因
在升级进程后在数据文件上有锁
在升级后数据文件头锁可能有一些来自旧发布版本的信息，这可能是导致问题的原因。
DBVERIFY 能被用于受影响的数据文件且有时显示问题
解决方案
尝试以下解决方法：
========================
重启系统
或
drop并重建被锁数据文件（类似于Doc ID 212053.1）
或
重新调整数据文件大小
参考
NOTE:212053.1 - ORA-1157/ORA-1110 Trying To Open The Database