情况1:保养数据库及操作系统,服务器,需要关闭DB(所有实例),OS及SERVER
a.首先停止oracle10g环境$ lsnrctl sop (每个节点上停止监听,也可以用srvctl来操作)
$ emctl stop dbconsole(每个节点停止dbconsole)
$ srvctl stop database -d db_name(停止数据库所有实例)
$ srvctl stop nodeapps -n rac01(停止节点1服务)
$ srvctl stop nodeapps -n rac02(停止节点2服务)
# /etc/init.d/init.crs stop(root听cluster软件)或者用$crs_stop -all
b.#init 0关闭服务器,或者如果重新启动#iit 6
c.关闭电源
d.开启server,开始启动oraqcle10g数据库及服务器等(如果OS重新启动,那么下面的所有服务是自动打开的[除了
DBCONSOLE],不用手工执行了).
#/etc/init.d/init.crs start(root启cluster软件)或者用$crs_start -all
$srvctl start nodeapps -n rac01(启动节点1服务)
$srvctl start nodeapps -n rac02(启动节点2服务)
$srvctl start database -d db_name(启动所有数据库实例)
$lsnrctl start(每个节点上启动监听,也可以用srvctl操作)
$emctl start dbconsole (每个节点启动dbconsole)
注:srvctl也可以用来关闭某个实例
srvctl stop instance -d orcl -i orcl1
srvctl关闭监听器
srvctl stop listener -n orcl1
srvctl启动监听器
srvctl start listener -n orcl1
情况2:调整数据库参数的时候,只关闭所有节点实例,不重新启动OS和SERVER
a.首先停止oracle 10g 环境
$lsnrctl stop listener -n orcl1(关闭监听)
$lsnrctl stop listener -n orcl2
$srvctl stop database -d orcl(关闭所有实例)
b.然后启动所有实例和监听
$srvctl start database -d orcl
$srvctl start listener -n orcl1
$srvctl start listener -n orcl2
情况3:不关闭操作系统的情况下,由于问题点或调整某些服务而需要关闭然后开启某些服务程序等
开关某些服务的时候,由于涉及到RAC运行,所有也需要先关闭RAC实例,类似于第一种情况.
附:Oracle 10g RAC检查命令
----------------------------------------------------------------------------------------
1.Oracle10g RAC数据库的nodeapps有:VIP,GSD,Listener,ONS
$srvctl status nodeapps -n dbrac1(检查vip,gsd,listener,ONS等)
[oracle@rac2 ~]$ srvctl status nodeapps -n rac2
VIP 正在运行的节点: rac2
GSD 正在运行的节点: rac2
监听程序正在节点上运行: rac2
ONS 守护程序正在节点上运行:rac2
2.$crsctl check crs(检查 oracle cluster的状态:CSS,CRS,EVM)
[oracle@rac2 ~]$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
3.$crs_stat -t(全面检查状态)
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.iptv.db application ONLINE ONLINE rac2
ora....v1.inst application ONLINE OFFLINE
ora....v2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE OFFLINE
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE OFFLINE
ora.rac1.ons application ONLINE OFFLINE
ora.rac1.vip application ONLINE ONLINE rac2
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