[grid@node1 ~]$ crsctl status res -t
[grid@node1 ~]$ srvctl stop scan_listener
[grid@node1 ~]$ srvctl stop listener
grid@node1 ~]$ crsctl status res -t
二. 杀会话(两个节点)
select 'alter system disconnect session ''' ||sid||','||serial#||''' immediate;' from v$session where type='USER';
三. 做检查点操作(两个节点)
alter system switch logfile;
alter system checkpoint;
四. 关闭数据库和CRS
(1)关库(任一节点)
[grid@node1 ~]$ srvctl stop database -d ractest -o immediate
[grid@node1 ~]$ crsctl status res -t
(2)关CRS(两个节点)
root用户:
[root@node1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
[root@node2 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
五. 停ASM(两个节点)
如果要停ASM,root用户下:
[root@node1 ~]# /etc/init.d/oracleasm stop
与停库顺序相反
其他管理维护指南
一.通过srvctl管理
1.关闭RAC数据库服务顺序
[oracle@dbp ~] $ srvctl stop database -d RACwh
[oracle@dbp ~] $ srvctl stop asm -n RAC01
[oracle@dbp ~] $ srvctl stop asm -n RAC02
[oracle@dbp ~] $ srvctl stop nodeapps -n RAC01
[oracle@dbp ~] $ srvctl stop nodeapps -n RAC02
2.启动RAC数据库服务顺序
[oracle@RAC01 ~] $ srvctl start nodeapps -n RAC01
[oracle@RAC01 ~] $ srvctl start nodeapps -n RAC02
[oracle@RAC01 ~] $ srvctl start asm -n RAC01
[oracle@RAC01 ~] $ srvctl start asm -n RAC02
[oracle@RAC01 ~] $ srvctl start database -d RACwh
3.其他命令
实例管理
[oracle@RAC01 ~] $ srvctl status instance -d RACwh -i RACwh1
[oracle@RAC01 ~] $ srvctl stop instance -d RACwh -i RACwh1
[oracle@RAC01 ~] $ srvctl start instance -d RACwh -i RACwh1
监听管理
[oracle@RAC01 ~] $ srvctl status listener -n RAC01
[oracle@RAC01 ~] $ srvctl stop listener -n RAC01
[oracle@RAC01 ~] $ srvctl start listener -n RAC01
二.通过crsctl工具管理
[oracle@RAC01 ~] $ crs_stat -t
[oracle@RAC01 ~] $ crs_stat
[oracle@RAC01 ~] $ crs_start -all
[oracle@RAC01 ~] $ crs_stop -all
[oracle@RAC01 ~] $ crs_stop "ora. RACwh.db"
Crs_stat命令在oracle11g后逐渐趋于废弃,如下即可明白:
[grid@RAC02 ~]$ crs_stat -h
This command is deprecated and has been replaced by 'crsctl status resource'
This command remains for backward compatibility only
Usage: crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member]
crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member]
crs_stat -p [resource_name [...]] [-q]
crs_stat [-a] application -g
crs_stat [-a] application -r [-c cluster_member]
crs_stat -f [resource_name [...]] [-q] [-c cluster_member]
crs_stat -ls [resource_name [...]] [-q]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24162410/viewspace-1809229/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24162410/viewspace-1809229/