InstallationOracle11gR2RACOneNode---测试二

6.3、重启测试

重启节点2之后,在节点1查看状态,此时实例为ORACLE_2,运行于节点2上。

创新互联-专业网站定制、快速模板网站建设、高性价比阿拉尔网站开发、企业建站全套包干低至880元,成熟完善的模板库,直接使用。一站式阿拉尔网站制作公司更省心,省钱,快速模板网站建设找我们,业务覆盖阿拉尔地区。费用合理售后完善,10余年实体公司更值得信赖。

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


新闻名称:InstallationOracle11gR2RACOneNode---测试二
当前路径:http://scyanting.com/article/ipjpji.html