如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
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
Comment