溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
重啟節點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進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
