oracle 11gR2 RAC 撥公網物理測試

paulyibinyi發表於2010-03-01

       安裝完oracle 11gR2 rac for aix 後,今天做了下撥公網的物理測試,

撥掉節點p520的公網網線後,vip服務會發生漂移到節點2上,p520 listener,network,ons服務offline,vip會發生切換

[root@p650:/grid/app/11.2.0/grid/bin]#./crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGDATA1.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGRECOVER.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGSYSTEM.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.LISTENER.lsnr
               ONLINE  OFFLINE      p520                                        
               ONLINE  ONLINE       p650                                        
ora.asm
               ONLINE  ONLINE       p520                     Started            
               ONLINE  ONLINE       p650                     Started            
ora.eons
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.gsd
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.net1.network
               ONLINE  OFFLINE      p520                                        
               ONLINE  ONLINE       p650                                        
ora.ons
               ONLINE  OFFLINE      p520                                        
               ONLINE  ONLINE       p650                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       p650                                        
ora.oc4j
      1        ONLINE  ONLINE       p520                                        
ora.orcl.db
      1        ONLINE  ONLINE       p520                     Open               
      2        ONLINE  ONLINE       p650                     Open               
ora.p520.vip
      1        ONLINE  INTERMEDIATE p650                     FAILED OVER        
ora.p650.vip
      1        ONLINE  ONLINE       p650                                        
ora.scan1.vip
      1        ONLINE  ONLINE       p650           

 

[root@p650:/grid/app/11.2.0/grid/bin]#./crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.CRS.dg     ora....up.type ONLINE    ONLINE    p520       
ora.DGDATA1.dg ora....up.type ONLINE    ONLINE    p520       
ora....OVER.dg ora....up.type ONLINE    ONLINE    p520       
ora....STEM.dg ora....up.type ONLINE    ONLINE    p520       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    p650       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    p650       
ora.asm        ora.asm.type   ONLINE    ONLINE    p520       
ora.eons       ora.eons.type  ONLINE    ONLINE    p520       
ora.gsd        ora.gsd.type   ONLINE    ONLINE    p520       
ora....network ora....rk.type ONLINE    ONLINE    p650       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    p520       
ora.ons        ora.ons.type   ONLINE    ONLINE    p650       
ora.orcl.db    ora....se.type ONLINE    ONLINE    p520       
ora....SM1.asm application    ONLINE    ONLINE    p520       
ora....20.lsnr application    ONLINE    OFFLINE              
ora.p520.gsd   application    ONLINE    ONLINE    p520       
ora.p520.ons   application    ONLINE    OFFLINE              
ora.p520.vip   ora....t1.type ONLINE    ONLINE    p650       
ora....SM2.asm application    ONLINE    ONLINE    p650       
ora....50.lsnr application    ONLINE    ONLINE    p650       
ora.p650.gsd   application    ONLINE    ONLINE    p650       
ora.p650.ons   application    ONLINE    ONLINE    p650       
ora.p650.vip   ora....t1.type ONLINE    ONLINE    p650       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    p650   
 

恢復公網後

[root@p650:/grid/app/11.2.0/grid/bin]#./crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGDATA1.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGRECOVER.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.DGSYSTEM.dg
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.LISTENER.lsnr
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.asm
               ONLINE  ONLINE       p520                     Started            
               ONLINE  ONLINE       p650                     Started            
ora.eons
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.gsd
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
ora.net1.network
               ONLINE  ONLINE       p520
                                        
               ONLINE  ONLINE       p650                                        
ora.ons
               ONLINE  ONLINE       p520                                        
               ONLINE  ONLINE       p650                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       p650                                        
ora.oc4j
      1        ONLINE  ONLINE       p520                                        
ora.orcl.db
      1        ONLINE  ONLINE       p520                     Open               
      2        ONLINE  ONLINE       p650                     Open               
ora.p520.vip
      1        ONLINE  ONLINE       p520
                                        
ora.p650.vip
      1        ONLINE  ONLINE       p650                                        
ora.scan1.vip
      1        ONLINE  ONLINE       p650                     

[root@p650:/grid/app/11.2.0/grid/bin]#./crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.CRS.dg     ora....up.type ONLINE    ONLINE    p520       
ora.DGDATA1.dg ora....up.type ONLINE    ONLINE    p520       
ora....OVER.dg ora....up.type ONLINE    ONLINE    p520       
ora....STEM.dg ora....up.type ONLINE    ONLINE    p520       
ora....ER.lsnr ora....er.type ONLINE    ONLINE    p520       
ora....N1.lsnr ora....er.type ONLINE    ONLINE    p650       
ora.asm        ora.asm.type   ONLINE    ONLINE    p520       
ora.eons       ora.eons.type  ONLINE    ONLINE    p520       
ora.gsd        ora.gsd.type   ONLINE    ONLINE    p520       
ora....network ora....rk.type ONLINE    ONLINE    p520       
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    p520       
ora.ons        ora.ons.type   ONLINE    ONLINE    p520       
ora.orcl.db    ora....se.type ONLINE    ONLINE    p520       
ora....SM1.asm application    ONLINE    ONLINE    p520       
ora....20.lsnr application    ONLINE    ONLINE    p520       
ora.p520.gsd   application    ONLINE    ONLINE    p520       
ora.p520.ons   application    ONLINE    ONLINE    p520       
ora.p520.vip   ora....t1.type ONLINE    ONLINE    p520       
ora....SM2.asm application    ONLINE    ONLINE    p650       
ora....50.lsnr application    ONLINE    ONLINE    p650       
ora.p650.gsd   application    ONLINE    ONLINE    p650       
ora.p650.ons   application    ONLINE    ONLINE    p650       
ora.p650.vip   ora....t1.type ONLINE    ONLINE    p650       
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    p650   

 可以看到p520節點上的network,ons,vip服務自動切換回來,並且正常,不再需要手工干預,

這點比10g 版本中做了改進,而10g恢復公網後,需要手工干預,可以參考我blog

oracle 10g rac 撥公網網線和私網網線物理測試這篇文章

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-628263/,如需轉載,請註明出處,否則將追究法律責任。

相關文章