这个时候关闭该节点，且在客户端执行select * from dba_objects;语句，
查看节点二 用户会话状态。
SQL> r
1* select inst_id,username,failover_type,failover_method,failed_over from gv$session where username='SYSTEM'
INST_ID USERNAME FAILOVER_TYPE FAILOVER_M FAI
---------- -------------------- ------------- ---------- ---
1 SYSTEM SELECT BASIC YES
SQL>
可以看到用户只在几秒中停顿后继续完成了select操作，且failed_over状态为yes，证明failover已经生效。
查看状态信息如下：
c[grid@rac-two ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE rac-two
ora.GIDG.dg
ONLINE ONLINE rac-two
ora.LISTENER.lsnr
ONLINE ONLINE rac-two
ora.asm
ONLINE ONLINE rac-two Started
ora.gsd
OFFLINE OFFLINE rac-two
ora.net1.network
ONLINE ONLINE rac-two
ora.ons
ONLINE ONLINE rac-two
ora.registry.acfs
ONLINE ONLINE rac-two
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-two
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac-two
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac-two
ora.cvu
1 ONLINE ONLINE rac-two
ora.oc4j
1 ONLINE ONLINE rac-two
ora.rac-one.vip
1 ONLINE INTERMEDIATE rac-two FAILED OVER
ora.rac-two.vip
1 ONLINE ONLINE rac-two
ora.rac.db
1 ONLINE ONLINE rac-two Open
2 ONLINE OFFLINE Instance Shutdown
ora.rac.rac1.svc
1 ONLINE ONLINE rac-two
ora.rac.rac2.svc
1 ONLINE ONLINE rac-two
ora.scan1.vip
1 ONLINE ONLINE rac-two
ora.scan2.vip
1 ONLINE ONLINE rac-two
ora.scan3.vip
1 ONLINE ONLINE rac-two
[grid@rac-two ~]$
可知目前ora.ora-one.vip已经failed over，且ora.rac.rac1.svc运行到了rac-two中。
重启节点后查看资源如下：
[grid@rac-one ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE rac-one
ONLINE ONLINE rac-two
ora.GIDG.dg
ONLINE ONLINE rac-one
ONLINE ONLINE rac-two
ora.LISTENER.lsnr
ONLINE OFFLINE rac-one
ONLINE ONLINE rac-two
ora.asm
ONLINE ONLINE rac-one Started
ONLINE ONLINE rac-two Started
ora.gsd
OFFLINE OFFLINE rac-one
OFFLINE OFFLINE rac-two
ora.net1.network
ONLINE ONLINE rac-one
ONLINE ONLINE rac-two
ora.ons
ONLINE OFFLINE rac-one STARTING
ONLINE ONLINE rac-two
ora.registry.acfs
ONLINE ONLINE rac-one
ONLINE ONLINE rac-two
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac-two STOPPING
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac-two
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac-two
ora.cvu
1 ONLINE ONLINE rac-two
ora.oc4j
1 ONLINE ONLINE rac-two
ora.rac-one.vip
1 ONLINE INTERMEDIATE rac-two FAILED OVER,STOPPING
ora.