6.3、重启测试重启节点2之后，在节点1查看状态，此时实例为ORACLE_2，运行于节点2上。grid@node1:~> crsctl stat res -t---------------------
重启节点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。
--结束END--
本文标题: Installation Oracle11gR2 RAC One Node ---测试二
本文链接: https://lsjlt.com/news/40177.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0