sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

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

案例:Oracle报错ORA-38856: cannot mark instance UNNAMED_INSTANCE_2

时间:2016-06-11 23:04   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净 ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

产品DBA反映,在将Oracle RAC的ASM数据文件,恢复到单节点后,在打开数据库时报错ORA-38856,分析原因为控制文件中redo导致

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

ORA-38856 is the expected error during open database resetlogs when the set of enabled instances (redo threads) in the controlfile does not match the set of enabled instances (redo threads) in datafile checkpoint. This is expected behavior in a normal RAC restore/recover/open resetlogs situation.
这句话的意思是:
a.数据库在resetlogs的时候发现控制文件中的redo threads和数据文件汇总的redo threads不一致,从而出现该问题.
b.在本次恢复中禁用了所有和thread 2相关参数,数据库依然报告错误,是因为数据库在异常恢复过程中需要读取节点2的redo信息;
c.现在无法读取从而出现该错误.但是使用了_allow_resetlogs_corruption 之后还是报该错误,实在诡异.
d.通过查询mos发现有类似Unpublished Bug 4355382 ORA-38856: FAILED TO OPEN DATABASE WITH RESETLOGS WHEN USING RAC BACKUP,虽然说该bug在10.2.0.3中修复,但是在异常恢复过程中.
e.本着在风险可控的情况下,大胆尝试,继续使用_no_recovery_through_resetlogs,数据库正常resetlogs成功.
可以参考:RMAN Duplicate from RAC backup fails ORA-38856 (Doc ID 334899.1)


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

最权威、专业的Oracle案例资源汇总之案例:Oracle报错ORA-38856: cannot mark instance UNNAMED_INSTANCE_2

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

Oracle研究中心

关键词:

Oracle报错ORA-38856

ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled