温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Installation Oracle11gR2 RAC One Node ---测试二

发布时间:2020-07-06 16:59:03 来源:网络 阅读:419 作者:jason_125 栏目:关系型数据库

6.3、重启测试

重启节点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

6.4、关机测试

此时实例为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。


向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI