花费一天一夜解决RAC故障(三)

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重新建数据库。最后数据库正常启动了。。。。。。。

请使用浏览器的分享功能分享到微信等