Oracle链接到只读Standby 显示 “ORA-01089: Immediate Shutdown In Progress “

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

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

服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com

 

适用于:

Oracle Database – Enterprise Edition – 版本11.2.0.3 到11.2.0.3 [Release 11.2]
本文信息适用于任何平台。
***13-Jul-2015检测相关性***

目标

这是11.2.0.3 Active Data Guard Physical Standby

简单的SQL*PLUS 连接到该物理备用数据库能运作。

通过dblink简单查询该只读备用数据库失败,显示以下错误,

SQL> select count(*) from SCOTT.EMP@TEST
*
Error at line 1
ORA-01089: immediate shutdown in progress – no operations are permitted
ORA-02063: preceding line from TEST
Process ID: 32552
Session ID: 1489 Serial number: 961

 

解决方案

这是由于以下bug:

Bug 16171011: ORA-1089 SELECTING OVER DB LINK TO ACTIVE DG
它类似于复制的

Bug 17162712. ORA-1089 FROM A DATABASE LINK AFTER A RAC INSTANCE IS OPENED READ ONLY

REDISCOVERy

——————

从ADG备用实例报告意外的ORA-1089。

This fix of this base bug is available on several 11.2.0.3.x Versions but issue fixed in 12.1.0.2.0这个基本bug的修正可在多个11.2.0.3.x版本提供,但问题在12.1.0.2.0中修正
参考

BUG:17162712 – ORA-1089 FROM A DATABASE LINK AFTER A RAC INSTANCE IS OPENED READ ONLY
BUG:16171011 – ORA-1089 SELECTING OVER DB LINK TO ACTIVE DG

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号