oracle ORA-01157: 无法标识/锁定数据文件 - 请参阅 DBWR 跟踪文件 ORA-01157: Cannot Identify/lock Data File

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-01157: 无法标识/锁定数据文件  - 请参阅 DBWR 跟踪文件

ORA-01157: Cannot Identify/lock Data File

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