在启动两台虚拟机的RAC环境中,我们一般要进行关闭主机,这个时候一般让两台虚拟机分别休眠,经过几次实践,每次重启起来之后,rac环境中会有各种问题,这个问题也困扰了我好久,最近在休眠之前,我会将RAC数据先关的服务先进行关闭,然后就可以很从容的休眠虚拟机了,操作如下:

 

 

 

[oracle@rac1 ~]$ srvctl stop database -d prod -o immediate
[oracle@rac1 ~]$ srvctl stop asm -n rac1
[oracle@rac1 ~]$ srvctl stop asm -n rac2
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac1
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac2
[root@rac1 ~]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.prod.db application OFFLINE OFFLINE
ora....d1.inst application OFFLINE OFFLINE
ora....d2.inst application ONLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE OFFLINE
ora....C2.lsnr application OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip application OFFLINE OFFLINE

我们关闭其中的一台虚拟机以后,可以在另外的一个节点(虚拟机)上单独将rac启动,操作如下:

首先禁止节点2的ASM实例重启,然后再启动节点1,操作如下

[oracle@rac1 dbs]$ srvctl disable asm -n rac2
[oracle@rac1 ~]$ srvctl start nodeapps -n rac1
[oracle@rac1 ~]$ srvctl start asm -n rac1
[oracle@rac1 ~]$ srvctl start instance -d prod -i prod1 -o open
[oracle@rac1 dbs]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.prod.db    application    ONLINE    ONLINE    rac1
ora....d1.inst application    ONLINE    ONLINE    rac1
ora....d2.inst application    OFFLINE   OFFLINE
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    OFFLINE   OFFLINE
ora....C2.lsnr application    OFFLINE   OFFLINE
ora.rac2.gsd   application    OFFLINE   OFFLINE
ora.rac2.ons   application    OFFLINE   OFFLINE
ora.rac2.vip   application    ONLINE    ONLINE    rac1