sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle RAC报错ORA-01157的原因和MOS官方解决办法

时间:2016-11-04 09:21   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:运维DBA反映Oracle RAC启动失败并报错ORA-01157,分析原因为遇到数据文件在其它一台实例,因为权限原因导致不能访问时。
在RAC环境中,当数据库OPEN状态时,如果遇到数据文件在其它一台实例,因为权限原因导致不能访问时,如1157报错
ORA-01157: cannot identify/lock data file 19 – see DBWR trace file
ORA-01110: data file 19: ‘/app/Oracle/oradata/users02.dbf’


此时我们需要使用alter system check datafiles来验证数据文件的信息并存放在SGA中,而不需要重启实例。

语法如下:
alter system check datafiles global|local

默认为global,此命令不会验证ONLINE的数据文件
Problem Description:
====================
When running “ALTER SYSTEM CHECK DATAFILES” it delivers a “STATEMENT PROCESSED” but there is no recorded activity. There is no alert file even though the book says there is.

You can do an ALTER SYSTEM CHECK DATAFILES if the database is only mounted. But the command does not return an error if a datafile is missing.

Solution Description:
=====================
The ALTER SYSTEM CHECK DATAFILES command was designed to solve aparticular problem of file accessibility. This most often has to dowith OPS, and disks that are shared among several machines. There arecases where a disk may be accessible on one machine, but not another,because of configuration or OS problems.
.
Imagine that you have a datafile that is marked OFFLINE. If the diskwhere that datafile lives is accessible to a particular machine in anOPS installation, then you can bring it ONLINE. If, however, anothermachine can’t get to that disk at the time you bring it ONLINE, thenthat instance won’t be able to verify the datafile. Hence in thatinstance, the controlfile will have the datafile listed as ONLINE, butthe datafile still will not be properly accessible and entered in theSGA.

Explanation:
============
The ALTER SYSTEM CHECK DATAFILES command was designed to allowyou to correct the problem from the OS perspective and make the diskaccessible. This would then trigger the insthttp://www.oracleplus.netance into recognizing this fact,verifying the datafile, and thereby making it available to Oracle inthat instance.

So the command does not quite do what might be implied by the currentdocumentation. It does not verify access to all online datafiles,rather, it only looks at those that are now online, but which were not previously verified. Once a datafile has been verified, it is considered verified for alltime, until you OFFLINE the file or until the database is dismounted in that instance.
References:
===========
BUG:435848
Search Words:
=============
ALTER SYSTEM CHECK DATAFILES

本文固定链接: http://www.htz.pw/2014/11/09/alter-system-check-datafiles.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle RAC报错ORA-01157的原因和MOS官方解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1161.html

Oracle研究中心

关键词:

ORA-01157

Oracle报错ORA-01157解决笔记

Oracle RAC启动时由于权限不足无法启动