oracle dataguard主库不能用时，如何自动切换到备库

kuaileshizhe200

huanhuanlove 发表于 2015-8-5 12:57
switchover其实意义并不大，建议应该多关注failover吧。如果实现failover快速切换，数据无丢失，这才是关键 ...

目前也没有找到特别好的方案

Yong Huang

kuaileshizhe200,

If you really want to implement automatic failover, why not install Data Guard Broker? That's it.

If you don't like the Broker, write a simple shell script which checks the status of the primary, and if it's down, logs into standby and activates it. Tell us what difficulty you have and we'll help you. Of course you can make the script more fancy than that. For example, try switchover first. If that doesn't work, do activate. When you add more and more logic to the script, you may prefer Broker again.

kuaileshizhe200

Yong Huang 发表于 2015-8-5 23:17
kuaileshizhe200,

If you really want to implement automatic failover, why not install Data Guard B ...

多谢版主，我基本也是考虑shell脚本这种实现方式

www_xylove

kuaileshizhe200 发表于 2015-8-6 08:56
多谢版主，我基本也是考虑shell脚本这种实现方式

shell脚本有可能存在误判的几率.

kuaileshizhe200

www_xylove 发表于 2015-8-18 16:53
shell脚本有可能存在误判的几率.

目前除了shell还没有找到其他可行的方案。。。。。

www_xylove

kuaileshizhe200 发表于 2015-8-19 09:06
目前除了shell还没有找到其他可行的方案。。。。。

只要符合企业的RTO,RPO，手动切换是最佳可行方案。