Oracle 在添加数据文件时生成ORA-1157 和ORA-1110

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

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

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

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

ORA-01110: 数据文件 : ''

ORA-01110
 oerr ora 1110
01110, 00000, "data file %s: '%s'"
// *Cause:  Reporting file name for details of another error
// *Action: See associated error message
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 及以上
本文信息适用于任何平台。

症状

-> 尝试添加数据文件

-> 收到错误 ORA-01157 ORA-01110 ORA-27048

-> 重启数据库没有帮助

-> Drop 并重建原始文件并调整文件文件也没有帮助

更改

升级到11.2.0.4

原因

Bug 17970036 – ORA-1157 AND ORA-1110 WHEN ADDING DATAFILE (RAW DEVICE) WITHOUT SPECIFYING SIZE 

REDISCOVERY INFORMATION:
~~~~~~~~~~~~~~~~~~~
在原始设备添加数据文件失败并生成错误：

alter tablespace TBS_CRM_ACCEPT_IDX add datafile ‘/dev/rlv_data724’;
ORA-01157: cannot identify/lock data file 750 – see DBWR trace file
ORA-01110: data file 750: ‘/dev/rlv_data724’
ORA-27048: skgfifi: file header information is invalid

解决方案

修复:
~~~~~~~~~
该bug 在12 release中修复。

解决方案：
~~~~~~~~~~~~
> Mention size along with add datafile query.提及大小以及添加数据文件查询。

或

> 应用补丁 17970036

参考

BUG:17970036 – ORA-1157 AND ORA-1110 WHEN ADDING DATAFILE (RAW DEVICE) WITHOUT SPECIFYING SIZE