首页 > 数据库 > Oracle > Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)

Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)

Oracle 作者:东北胖子 时间:2018-09-17 23:52:26 0 删除 编辑

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 25-JUNE-2013***


Before we initiate the switchover, we check the synchronization status between primary and physical standby. They are in perfect sync. Physical standby has applied the lastly generated archived redo log sequence. But in physical standby v$database.switchover_status shows "not allowed"


It is expected to see this status in physical standby.
When we are certain that Primary and target standby are in sync,
We can then proceed with switchover exercise regardless of "not allowed" status in Physical standby


Switchover always originates from Primary database. 
On the request of switchover sql statement 
"alter database commit to switchover to physical standby with session shutdown", 
Primary will generate special marker called EOR (end-of-redo) that is placed in the
header of online redo log sequence. So this online redo log sequence will be archived locally
and sent to all standby databases.

Only upon receiving and applying EOR (end-of-redo), v$database.switchover_status will change
from "not allowed" to "to primary" or "sessions active".
At this stage Physical standby is ready to assume Primary database role

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量