（连载）（完结篇）一个关于ORACLE数据库的虚拟工程（九）--模拟故障

最新推荐文章于 2021-06-20 13:04:48 发布

蔡菜子

最新推荐文章于 2021-06-20 13:04:48 发布

阅读量392

点赞数

分类专栏： oracle linux

本文链接：https://blog.csdn.net/cd4836/article/details/99621132

版权

本文通过模拟ORACLE RAC集群中rac2故障及修复过程，探讨了非正常关闭数据库后的自动启动情况。还涉及到了机房停电时的正常关机测试，以及后续的开机启动顺序。最后总结了常用的相关操作命令。

摘要由CSDN通过智能技术生成

模拟rac2故障

把rac2关机，模拟一台主机坏了，然后在rac1上，可以看到rac2没有了，但是rac1还是继续在工作；

[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac1                                         
ora.FRA.dg
               ONLINE  ONLINE       rac1                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1                                         
ora.OCR.dg
               ONLINE  ONLINE       rac1                                         
ora.asm
               ONLINE  ONLINE       rac1                     Started             
ora.gsd
               OFFLINE OFFLINE      rac1                                         
ora.net1.network
               ONLINE  ONLINE       rac1                                         
ora.ons
               ONLINE  ONLINE       rac1                                         
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1                                         
ora.cvu
      1        ONLINE  ONLINE       rac1                                         
ora.oc4j
      1        ONLINE  ONLINE       rac1                                         
ora.orcl.db
      1        ONLINE  ONLINE       rac1                     Open                
      2        ONLINE  OFFLINE                               Instance Shutdown   
ora.rac1.vip
      1        ONLINE  ONLINE       rac1                                         
ora.rac2.vip
      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER         
ora.scan1.vip
      1        ONLINE  ONLINE       rac1                                    


[root@rac1 ~]# crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1        
ora.FRA.dg     ora....up.type ONLINE    ONLINE    rac1        
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora.OCR.dg     ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac1        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora.orcl.db    ora....se.type ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    OFFLINE   OFFLINE               
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac1        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1        

[root@rac1 ~]#  ps -ef | grep ora_
oracle     5331      1  0 09:07 ?        00:00:00 ora_pmon_orcl1
oracle     5333      1  0 09:07 ?        00:00:00 ora_psp0_orcl1
oracle     5335      1  1 09:07 ?        00:00:16 ora_vktm_orcl1
oracle     5339      1  0 09:07 ?        00:00:00 ora_gen0_orcl1
oracle     5341      1  0 09:07 ?        00:00:00 ora_diag_orcl1
oracle     5343      1  0 09:07 ?        00:00:00 ora_dbrm_orcl1
oracle     5345      1  0 09:07 ?        00:00:00 ora_ping_orcl1
oracle     5347      1  0 09:07 ?        00:00:00 ora_acms_orcl1
oracle     5349      1  0 09:07 ?        00:00:02 ora_dia0_orcl1
oracle     5351      1  0 09:07 ?        00:00:02 ora_lmon_orcl1
oracle     5353      1  0 09:07 ?        00:00:01 ora_lmd0_orcl1
oracle     5355      1  0 09:07 ?        00:00:04 ora_lms0_orcl1
oracle     5359      1  0 09:07 ?        00:00:00 ora_rms0_orcl1
oracle     5361      1  0 09:07 ?        00:00:00 ora_lmhb_orcl1
oracle     5363      1  0 09:07 ?        00:00:00 ora_mman_orcl1
oracle     5365      1  0 09:07 ?        00:00:00 ora_dbw0_orcl1
oracle     5367      1  0 09:07 ?        00:00:00 ora_lgwr_orcl1
oracle     5369      1  0 09:07 ?        00:00:00 ora_ckpt_orcl1
oracle     5371      1  0 09:07 ?        00:00:00 ora_smon_orcl1
oracle     5373      1  0 09:07 ?        00:00:00 ora_reco_orcl1
oracle     5375      1  0 09:07 ?        00:00:00 ora_rbal_orcl1
oracle     5377      1  0 09:07 ?        00:00:00 ora_asmb_orcl1
oracle     5379      1  0 09:07 ?        00:00:00 ora_mmon_orcl1
oracle     5381      1  0 09:07 ?        00:00:00 ora_mmnl_orcl1
oracle     5383      1  0 09:07 ?        00:00:00 ora_d000_orcl1
oracle     5387      1  0 09:07 ?        00:00:00 ora_s000_orcl1
oracle     5389      1  0 09:07 ?        00:00:00 ora_mark_orcl1
oracle     5489      1  0 09:07 ?        00:00:01 ora_lck0_orcl1
oracle     5494      1  0 09:07 ?        00:00:00 ora_rsmn_orcl1
oracle     6280      1  0 09:08 ?        00:00:00 ora_gtx0_orcl1
oracle     6295      1  0 09:08 ?        00:00:00 ora_rcbg_orcl1
oracle     6532      1  0 09:08 ?