欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

虚拟机上使用rac环境注意事项

程序员文章站 2022-06-11 10:23:50
...

在启动两台虚拟机的RAC环境中,我们一般要进行关闭主机,这个时候一般让两台虚拟机分别休眠,经过几次实践,每次重启起来之后,r

在启动两台虚拟机的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

推荐阅读:

RedHat Linux 5 & CentOS 5下Oracle 10g安装详解

CentOS 6.3(x32)下安装Oracle 10g R2

Linux-6-64下安装Oracle 12C笔记

虚拟机上使用rac环境注意事项