注册 登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

常在心

淡泊明志,人生自在

 
 
 

日志

 
 

switchover_status的状态  

2011-03-28 12:47:25|  分类: Data Guard |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

关于DG中的swithcover_status的状态说明:
NOT ALLOWED - Either this is a standby database and the primary database has not been switched first or this is a primary database and there are no standby databases.
翻译:NOT ALLOWED--当前有主从库,但是状态还没有标记,或者是只有一个主库没有从库

SESSIONS ACTIVE - Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted. Query the V$SESSION view to identify the specific processes that need to be terminated.
翻译:SESSION ACTIVE-表明主库人有正在进行的操作的session或者备库需要在切换之前要断开才能够允许。通过查询视图v$SESSION可以看到哪些进程需要被强制断开

SWITCHOVER PENDING - This is a standby database and the primary database switchover request has been received but not processed.


 SWITCHOVER LATENT - The switchover was in pending mode, but did not complete and went back to the primary database.


TO PRIMARY - This is a standby database and is allowed to switch over to a primary database.


TO STANDBY - This is a primary database and is allowed to switch over to a standby database.


RECOVERY NEEDED - This is a standby database that has not received the switchover request.


PREPARING SWITCHOVER - Either this is a primary database that is accepting redo data from a logical standby database in preparation for switch over to the logical standby database role, or it is a logical standby database sending redo data to a primary database and other standby databases in preparation for switch over to the primary database role. In the latter case, a completed dictionary has already been sent to the primary database and other standby databases.

PREPARING DICTIONARY - This is a logical standby database that is sending redo data to a primary database and other standby databases in the configuration in preparation for switch over to the primary database role.


TO LOGICAL STANDBY - This is a primary database that has received a complete dictionary from a logical standby database.

  评论这张
 
阅读(760)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018