重启节点2之后,在节点1查看状态,此时实例为ORACLE_2,运行于节点2上。
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE OFFLINE node2
ora.FRA.dg
ONLINE ONLINE node1
ONLINE OFFLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE OFFLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE OFFLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE OFFLINE STARTING
ora.cvu
1 ONLINE ONLINE node1
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE OFFLINE STARTING
ora.oracle.db
2 ONLINE OFFLINE Instance Shutdown,S
TARTING
ora.oracle.oracleser.svc
1 ONLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE node1
grid@node1:~> srvctl status database -d ORACLE
再次查看
grid@node1:~> srvctl status database -d ORACLE
Instance ORACLE_2 is running on node node1
Online relocation: INACTIVE
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ora.FRA.dg
ONLINE ONLINE node1
ora.LISTENER.lsnr
ONLINE ONLINE node1
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ora.asm
ONLINE ONLINE node1 Started
ora.gsd
OFFLINEOFFLINE node1
ora.net1.network
ONLINE ONLINE node1
ora.ons
ONLINE ONLINE node1
ora.registry.acfs
ONLINE ONLINE node1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1
ora.cvu
1 ONLINE ONLINE node1
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE INTERMEDIATE node1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE node1
ora.oracle.db
2 ONLINE ONLINE node1 Open
ora.oracle.oracleser.svc
1 ONLINE ONLINE node1
ora.scan1.vip
1 ONLINE ONLINE node1
grid@node1:~>
再次查看
grid@node1:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.FRA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1
ora.cvu
1 ONLINE ONLINE node1
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node1
ora.oracle.db
2 ONLINE ONLINE node1 Open
ora.oracle.oracleser.svc
1 ONLINE ONLINE node1
ora.scan1.vip
1 ONLINE ONLINE node1
grid@node1:~>
重启节点2后,ORACLE_2实例切换至节点1运行,实例仍为ORACLE_2。
此时实例为ORACLE_2,运行为节点1上。关闭节点1,在节点2上查看。
grid@node2:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.FRA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE OFFLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE OFFLINE STARTING
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE INTERMEDIATE node2 FAILED OVER
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node1 STOPPING
ora.oracle.db
2 ONLINE OFFLINE Instance Shutdown,S
TARTING
ora.oracle.oracleser.svc
1 ONLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE node2
grid@node2:~> srvctl status database -d ORACLE
Database is not running.
Online relocation: INACTIVE
grid@node2:~>
再次查看
grid@node2:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node2
ora.FRA.dg
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node2 Started
ora.gsd
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE INTERMEDIATE node2 FAILED OVER
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.oracle.db
2 ONLINE ONLINE node2 Open
ora.oracle.oracleser.svc
1 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
grid@node2:~> srvctl status database -d ORACLE
Instance ORACLE_2is running on node node2
Online relocation:INACTIVE
grid@node2:~>
启动节点1,等待几分后,再次查看
grid@node2:~> crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.FRA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINEOFFLINE node1
OFFLINEOFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.oracle.db
2 ONLINE ONLINE node2 Open
ora.oracle.oracleser.svc
1 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2
grid@node2:~>
当关闭节点1服务器后,ORACLE_2切换至节点2上运行。当重新启动节点1之后,ORACLE_2不会发生切回操作。
总结:
(1)、Failover是不会用到第二个实例的,手工relocate才会用到这个实例。
(2)、从节点1 Relocate至节点2过程中,会在目标主机节点2上启动一个ORACLE_2,再关闭原主机节点1的ORACLE_1,最终在节点2上运行的也是ORACLE_2。
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。