花費一天一夜解決RAC故障(三)

anycall2010發表於2008-07-06

ASM節點重新載入:節點1:

[root@rac1 ~]# /etc/init.d/oracleasm enable

Writing Oracle ASM library driver configuration:           [  OK  ]

Scanning system for ASM disks:                             [  OK  ]

 

[root@rac1 ~]# /etc/init.d/oracleasm scandisks

Scanning system for ASM disks:                             [  OK  ]

 

[root@rac2 clusterware]# /etc/init.d/oracleasm  enable

Writing Oracle ASM library driver configuration:           [  OK  ]

Scanning system for ASM disks:                             [  OK  ]

[root@rac2 clusterware]# /etc/init.d/oracleasm scandisks

Scanning system for ASM disks:                             [  OK  ]

[root@rac2 clusterware]#

重新啟動叢集服務:

 

rac1-> crs_stop -all

Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`

Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`

Stop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.

Target set to OFFLINE for `ora.dbvdb.dbvdb1.inst`

Attempting to stop `ora.rac1.ASM1.asm` on member `rac1`

Stop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.

Target set to OFFLINE for `ora.dbvdb.dbvdb2.inst`

Attempting to stop `ora.rac2.ASM2.asm` on member `rac2`

Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.

Attempting to stop `ora.rac1.vip` on member `rac1`

Stop of `ora.rac1.vip` on member `rac1` succeeded.

Stop of `ora.rac2.ASM2.asm` on member `rac2` succeeded.

Attempting to stop `ora.rac2.vip` on member `rac2`

Stop of `ora.rac2.vip` on member `rac2` succeeded.

rac1->  srvctl status nodeapps -n rac1

VIP is not running on node: rac1

GSD is not running on node: rac1

Listener is not running on node: rac1

ONS daemon is not running on node: rac1

rac1-> crs_start -all

Attempting to start `ora.rac1.vip` on member `rac1`

Attempting to start `ora.rac2.vip` on member `rac2`

Start of `ora.rac2.vip` on member `rac2` succeeded.

Start of `ora.rac1.vip` on member `rac1` succeeded.

Attempting to start `ora.rac1.ASM1.asm` on member `rac1`

Attempting to start `ora.rac2.ASM2.asm` on member `rac2`

Start of `ora.rac1.ASM1.asm` on member `rac1` succeeded.

Attempting to start `ora.dbvdb.dbvdb1.inst` on member `rac1`

Start of `ora.rac2.ASM2.asm` on member `rac2` succeeded.

Attempting to start `ora.dbvdb.dbvdb2.inst` on member `rac2`

 

Start of `ora.dbvdb.dbvdb1.inst` on member `rac1` succeeded.

Attempting to start `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`

Start of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.

Start of `ora.dbvdb.dbvdb2.inst` on member `rac2` failed.

rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2

 

 

rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2

 

 

CRS-0215: Could not start resource 'ora.dbvdb.dbvdb2.inst'.

 

CRS-0223: Resource 'ora.rac2.LISTENER_RAC2.lsnr' has placement error.

仍有報錯,不過不去管他,

 

繼續檢視CRS的狀態:

rac1-> crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.dbvdb.db   application    ONLINE    ONLINE    rac1

ora....b1.inst application    ONLINE    ONLINE    rac1

ora....b2.inst application    ONLINE    ONLINE    rac2

ora....SM1.asm application    ONLINE    ONLINE    rac1

ora....C1.lsnr application    ONLINE    ONLINE    rac1

ora.rac1.gsd   application    ONLINE    ONLINE    rac1

ora.rac1.ons   application    ONLINE    ONLINE    rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    ONLINE    rac2

ora....C2.lsnr application    ONLINE    ONLINE    rac2

ora.rac2.gsd   application    ONLINE    ONLINE    rac2

ora.rac2.ons   application    ONLINE    ONLINE    rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

rac1-> srvctl status nodeapps -n rac1

VIP is running on node: rac1

GSD is running on node: rac1

Listener is running on node: rac1

ONS daemon is running on node: rac1

rac1-> srvctl status nodeapps -n rac2

 

 

rac1->  srvctl status nodeapps -n rac2

VIP is running on node: rac2

GSD is running on node: rac2

Listener is running on node: rac2

ONS daemon is running on node: rac2

好象有希望了。。。

趕緊啟動啟動資料庫。。。。

rac1-> srvctl status database -d devdb

PRKR-1001 : cluster database devdb does not exist

PRKO-2005 : Application error: Failure in getting Cluster Database Configuration for: devdb

 

 資料庫依然不能啟動。走到這個地步,也只能重新建庫了,實用DBCA重新建資料庫。最後資料庫正常啟動了。。。。。。。

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

相關文章