oracle ORA-01157: Cannot Identify/lock Data File

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

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

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

 

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

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号