Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
来源:互联网 发布:连锁店软件 编辑:程序博客网 时间:2024/06/06 03:52
Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
In this Document
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2.0 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 25-JUNE-2013***
Symptoms
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"
Cause
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
Solution
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
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- Creating a Physical Standby Database (Doc ID 1475344.1)
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID
- How To Trace The Remote File Server (RFS) Process In Physical Standby Database (Doc ID 1481125.1)
- Data Guard Physical Standby 11.2 RAC Primary to RAC Standby using a second network (Doc ID 1349977.1
- Data Guard Physical Standby 11.2 RAC Primary to RAC Standby using a second network (Doc ID 1349977.1
- Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.
- Creating a physical standby from ASM primary (文档 ID 787793.1)
- Gathering Statistics on a Logical Standby (Doc ID 376406.1)
- Oracle Physical Standby
- physical standby archivelog 丢失
- DG physical standby 搭建
- build physical standby steps
- Physical standby failover steps
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply [ID 343424.1]
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- 自定义ProgressBar样式
- 功能代码实现集锦(一)
- 209. Minimum Size Subarray Sum
- HTML5 实现橡皮擦的擦除效果
- CDN内容分发网路技术原理
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- 16/4/17NEFU训练 I 这题没名字 模拟题
- URI和URL对比
- 第七届科技节编程大赛须知
- thrift C++做server, C++,python, java做Client例子
- 心情 2016年4月17号 星期日
- 回溯法八皇后
- sublime 使用的快捷键以及小技巧
- spark streaming kafka OffsetOutOfRangeException 异常分析与解决