适用于：
Oracle Server - Enterprise Edition - Version: 9.0.1.0 to 10.2.0.1
Information in this document applies to any platform.
目标：
该文章的目的是协助遇到ORA-1110的DBA，并为他们指出正确的方向。
根据后续的错误，一些记录已经被参考。
如果DBA在读完专门的记录后不可以解决问题，一个用于收集诊断信息的脚本已经在下面提供了。请将该脚本的输出上传到服务请求。
解决方案
如何诊断和解决ORA-1110
定义
错误：ORA1110
内容：数据文件：
————————
原因：该信息报告文件名包含其他信息
动作：查看描述问题的相关信息
ORA-1110显示ORACLE出现问题的物理数据文件
ORA-1110伴随着一个或者是更多的信息，这些信息可能是ORACLE特定的信息或者是跟操作系统有关的信息。
第一个目标是要找出前解决这一问题中遇到的所有错误消息：
下面是伴随ORA-1110的常见错误：
ORA-1157 "cannot identify datafile - file not found"
ORA-1578 "ORACLE data block corrupted (file # %s, block # %s)"
ORA-376 "file cannot be read at this time"
ORA-1194 "file needs more recovery to be consistent"
ORA-1547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error"
* Addressing an ORA-1157 (cannot identify datafile - file not found)
Note 184327.1 covers the ORA-1157 in greater detail.
* Addressing an ORA-1578 (ORACLE data block corrupted (file # %s, block # %s))
Note 28814.1 covers the ORA-1578 in greater detail.
* Addressing an ORA-376 (file cannot be read at this time)
Note 183327.1 covers the ORA-376 in greater detail.
* Addressing an ORA-1194 (file needs more recovery to be consistent) & ORA-1547 (warning: RECOVER succeeded but OPEN RESETLOGS would get error)
Note 435201.1 covers the ORA-1194 & ORA-1547 in greater detail.
如果按照以上的记录操作后你还是不能还原，恢复和打开数据，请执行以下脚本。
请在提交的服务请求中供输出内容（上传recovery_info.txt）
set pagesize 20000
set linesize 180
set pause off
set serveroutput on
set feedback on
set echo on
set numformat 999999999999999
Spool recovery_info.txt
select substr(name, 1, 50), status from v$datafile;
select substr(name,1,40), recover, fuzzy, checkpoint_change# from v$datafile_header;
select GROUP#,substr(member,1,60) from v$logfile;
select * from v$recover_file;
select distinct status from v$backup;
select hxfil FILENUMBER,fhsta STATUS,fhscn SCN,fhrba_Seq SEQUENCE from x$kcvfh;
select distinct (fuzzy) from v$datafile_header;
spool off
exit
显示相关信息
产品
* Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键词
ORA-1113; ORA-1157; ORA-1194; ORA-1547; ORA-1578; ORA-376
错误号
ORA-1194; ORA-376; ORA-1157; ORA-1110; ORA-1578; ORA-1547
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2011-8-29 10:48:28 |
赞(
操作
