暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

启停RAC

原创 逆风飞翔 2021-08-30
1453

–asm 自动挂载
alter system asm_diskgroups=‘ORADATA,ORAFLASH,ORAIMAGE1,ORAIMAGE2,ORAIMAGE,VOT01’ scope=spfile;
alter system set asm_diskstring=’/dev/oracleasm/disks/*’ scope=spfile;

  1. 检查节点集群资源状态(grid用户):crs_stat -t

或者crsctl stat res -t
停止顺序:数据库–》ASM–》节点服务–》集群软件==================
1.停止监听(oracle执行):
srvctl stop listener -n node1
srvctl stop listener -n node2

srvctl status listener -n node1

srvctl start listener -n node1
srvctl start listener -n node2

-------不执行
srvctl stop vip -n node1
srvctl stop vip -n node2
-------不执行
srvctl stop scan_listener -n node1
srvctl stop scan_listener -n node2

grid 用户
srvctl stop listener

  1. 停止em(oracle执行):
    emctl stop dbconsole

3.停止实例(oracle执行):
srvctl stop instance -d orcl -i orcl1
srvctl stop instance -d orcl -i orcl2
or
srvctl stop instance -d orcl -n node1
srvctl stop instance -d orcl -n node2
or
srvctl stop database -d orcl

  1. 停止asm(grid执行):
    srvctl stop asm -n node1
    srvctl stop asm -n node2

  2. 停止nodeapp(oracle执行):
    srvctl stop nodeapps -n node1
    srvctl stop nodeapps -n node2

6.root用户停止集群软件
/etc/init.d/init.crs stop
OR
[root@node1 ~]# cd /home/g01/app/11.2.0.4/grid/bin/
[root@node1 bin]# ./crsctl stop crs
(crsctl stop has -f )
==========================启动顺序:节点服务–》ASM–> 数据库实例—》集群软件--------------------------------------------------
1.
启动nodeapps:
srvctl start nodeapps -n node1
srvctl start nodeapps -n node2

启动asm:
srvctl start asm -n node1
srvctl start asm -n node2

  1. 启动数据库实例
    srvctl start database -d orcl
    or
    srvctl start instance -d orcl -i orcl1
    srvctl start instance -d orcl -i orcl2
    or
    srvctl start instance -d orcl -n node1
    srvctl start instance -d orcl -n node2

6.root用户启动集群软件
/etc/init.d/init.crs start
or
cd /home/g01/app/11.2.0.4/grid/bin/
crsctl start crs
(crsctl start has )
4.
启动监听:
srvctl start listener -n node1
srvctl start listener -n node2

启动vip
srvctl start vip -n node1
srvctl start vip -n node2

启动scan_listener:
srvctl start scan_listener -n node1
srvctl start scan_listener -n node2

----监听intermediate状态,处理
srvctl stop listener -n node2
srvctl stop scan_listene
ps -eaf|grep tns ##kill -9 掉进程
然后
srvctl start listener -n node2
srvctl start scan_listener -n node2

–检查
a) 检查crs资源状态:crsctl check crs
b) 检查集群资源情况:crsctl stat res -t

------单实例

lsnrctl stop ;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
1.1
SQL> shutdown immediate

startup mount
create pfile=’/home/oracle/initorcl0326.ora’ from spfile;
alter database open;

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论