Oracle 数据文件脱机,显示ORA-376 ORA-1110

 

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

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

服务热线 : 13764045638 QQ号:47079569 邮箱:[email protected]

 

ORA-00376
oerr ora 376
00376, 00000, "file %s cannot be read at this time"
// *Cause:  attempting to read from a file that is not readable. Most likely
//          the file is offline.
// *Action: Check the state of the file. Bring it online


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

 

适用于:

Oracle Database – Enterprise Edition – 版本9.2.0.1 及以上
本文信息适用于任何平台。
*** 30-Apr-2012检查相关性***
症状

数据文件自动脱机,显示以下错误信息

ORA-00603: ORACLE server session terminated by fatal error
ORA-00376: file 2002 cannot be read at this time
ORA-01110: data file xxxxxxxxxxxxxxxxxxxxxxxxxxxx

原因

该错误在 BUG : 5299700 中讨论且结论为” NOT A BUG ”

开发团队的更新:
=========================
Oracle 使文件脱机,因为它从OS收到”device busy”信息。
Oracle 表现如预期,给出该信息。
因此我们可以说,数据文件脱机是由于在该时间点的基本OS /硬件问题。

解决方案

联系硬件供应商来找出该行为的原因。

参考

BUG:5299700 – ORA-00376 ORA-01110


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *