虛擬機器RAC的ASM磁碟組壞塊導致重建DB

來源:互聯網
上載者:User

2011.11.23虛擬機器RAC的ASM磁碟組壞塊導致重建DB
剛剛在公司的一台PC機器上用vmware workstation8搭建了一套10gr2的rac環境,用的是裸裝置+ASM搭建,在安裝成功後,不小心被直接重啟了下主機,結果再次啟動虛擬機器的時候提示到有磁碟損壞,也沒有在意。但是在啟動RAC的時候出現了問題,一開始的現象是如下幾個個資源沒辦法隨著其他資源一起啟動:
ora.node1.LISTENER_NODE1.lsnr
ora.node2.LISTENER_NODE2.lsnr
ora.RAC.RAC1.inst
ora.RAC.RAC2.inst
ora.RAC.db
看具體的啟動過程:
[Oracle@node1 bin]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....C1.inst application    OFFLINE   OFFLINE              
ora....C2.inst application    OFFLINE   OFFLINE              
ora.RAC.db     application    OFFLINE   OFFLINE              
ora....SM1.asm application    OFFLINE   OFFLINE              
ora....E1.lsnr application    OFFLINE   OFFLINE              
ora.node1.gsd  application    OFFLINE   OFFLINE              
ora.node1.ons  application    OFFLINE   OFFLINE              
ora.node1.vip  application    OFFLINE   OFFLINE              
ora....SM2.asm application    OFFLINE   OFFLINE              
ora....E2.lsnr application    OFFLINE   OFFLINE              
ora.node2.gsd  application    OFFLINE   OFFLINE              
ora.node2.ons  application    OFFLINE   OFFLINE              
ora.node2.vip  application    OFFLINE   OFFLINE              
[oracle@node1 bin]$ crs_start -all
Attempting to start `ora.node1.vip` on member `node1`
Attempting to start `ora.node2.vip` on member `node2`
Start of `ora.node1.vip` on member `node1` succeeded.
Start of `ora.node2.vip` on member `node2` succeeded.
Attempting to start `ora.node1.ASM1.asm` on member `node1`
Attempting to start `ora.node2.ASM2.asm` on member `node2`
Start of `ora.node2.ASM2.asm` on member `node2` succeeded.
Attempting to start `ora.RAC.RAC2.inst` on member `node2`
Start of `ora.RAC.RAC2.inst` on member `node2` failed.
node1 : CRS-1018: Resource ora.node2.vip (application) is already running on node2

 


node1 : CRS-1018: Resource ora.node2.vip (application) is already running on node2

 


Start of `ora.node1.ASM1.asm` on member `node1` succeeded.
Attempting to start `ora.RAC.RAC1.inst` on member `node1`
Start of `ora.RAC.RAC1.inst` on member `node1` failed.
node2 : CRS-1018: Resource ora.node1.vip (application) is already running on node1

 


node2 : CRS-1018: Resource ora.node1.vip (application) is already running on node1

 


CRS-1002: Resource 'ora.node1.ons' is already running on member 'node1'


CRS-1002: Resource 'ora.node2.ons' is already running on member 'node2'


Attempting to start `ora.node1.gsd` on member `node1`
Attempting to start `ora.RAC.db` on member `node1`
Attempting to start `ora.node2.gsd` on member `node2`
Start of `ora.node1.gsd` on member `node1` succeeded.
Start of `ora.node2.gsd` on member `node2` succeeded.
Start of `ora.RAC.db` on member `node1` failed.
Attempting to start `ora.RAC.db` on member `node2`
Start of `ora.RAC.db` on member `node2` failed.
CRS-1006: No more members to consider


CRS-0215: Could not start resource 'ora.RAC.RAC1.inst'.


CRS-0215: Could not start resource 'ora.RAC.RAC2.inst'.


CRS-0215: Could not start resource 'ora.RAC.db'.


CRS-0223: Resource 'ora.node1.LISTENER_NODE1.lsnr' has placement error.


CRS-0223: Resource 'ora.node1.ons' has placement error.


CRS-0223: Resource 'ora.node2.LISTENER_NODE2.lsnr' has placement error.


CRS-0223: Resource 'ora.node2.ons' has placement error.


[oracle@node1 bin]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora....C1.inst application    ONLINE    OFFLINE              
ora....C2.inst application    ONLINE    OFFLINE              
ora.RAC.db     application    ONLINE    OFFLINE              
ora....SM1.asm application    ONLINE    ONLINE    node1      
ora....E1.lsnr application    OFFLINE   OFFLINE              
ora.node1.gsd  application    ONLINE    ONLINE    node1      
ora.node1.ons  application    ONLINE    ONLINE    node1      
ora.node1.vip  application    ONLINE    ONLINE    node1      
ora....SM2.asm application    ONLINE    ONLINE    node2      
ora....E2.lsnr application    OFFLINE   OFFLINE              
ora.node2.gsd  application    ONLINE    ONLINE    node2      
ora.node2.ons  application    ONLINE    ONLINE    node2      
ora.node2.vip  application    ONLINE    ONLINE    node2      
嘗試先把lsnr起來:
[oracle@node1 bin]$ crs_start ora.node1.LISTENER_NODE1.lsnr
Attempting to start `ora.node1.LISTENER_NODE1.lsnr` on member `node1`
Start of `ora.node1.LISTENER_NODE1.lsnr` on member `node1` succeeded.
[oracle@node1 bin]$ crs_start ora.node2.LISTENER_NODE2.lsnr
Attempting to start `ora.node2.LISTENER_NODE2.lsnr` on member `node2`
Start of `ora.node2.LISTENER_NODE2.lsnr` on member `node2` succeeded.
接著啟動兩個inst,接著出現問題了,inst無法拉起來:
[oracle@node1 bin]$ crs_start ora.RAC.RAC1.inst
Attempting to start `ora.RAC.RAC1.inst` on member `node1`
Start of `ora.RAC.RAC1.inst` on member `node1` failed.
node2 : CRS-1018: Resource ora.node1.vip (application) is already running on node1

  • 1
  • 2
  • 下一頁

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.