RAC日常运行中基本启停命令有哪些
这篇文章主要为大家展示了“RAC日常运行中基本启停命令有哪些”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“RAC日常运行中基本启停命令有哪些”这篇文章吧。
平泉网站建设公司创新互联,平泉网站设计制作,有大型网站制作公司丰富经验。已为平泉上千家提供企业网站建设服务。企业网站搭建\外贸营销网站建设要多少钱,请找那个售后服务好的平泉做网站的公司定做!
RAC日常运行中一些基本启停命令总结
设置cluster不随着操作系统自动启动
[root@rac01 u01]# crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
设置cluster随着操作系统自动启动,默认是启动的
[root@rac01 u01]# crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.
启动cluster,两个节点分别执行
[root@rac01 u01]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac02 u01]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
查看cluster资源状态,在两个节点都可以查看。
[root@rac01 u01]# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
OFFLINE OFFLINE rac01
OFFLINE OFFLINE rac02
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.OCR.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.asm
ONLINE ONLINE rac01 Started
ONLINE ONLINE rac02 Started
ora.eons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.gsd
OFFLINE OFFLINE rac01
OFFLINE OFFLINE rac02
ora.net1.network
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.ons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.registry.acfs
ONLINE ONLINE rac01
ONLINE ONLINE rac02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac01
ora.oc4j
1 ONLINE ONLINE rac01
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.rac02.vip
1 ONLINE ONLINE rac02
ora.sap.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE rac01
启动数据库实例,数据库实例名字为sap,在一个实例上执行即可
[root@rac01 u01]# srvctl start database -d sap
查看cluster资源状态ora.sap.db状态为open
[root@rac01 u01]# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.OCR.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.asm
ONLINE ONLINE rac01 Started
ONLINE ONLINE rac02 Started
ora.eons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.gsd
OFFLINE OFFLINE rac01
OFFLINE OFFLINE rac02
ora.net1.network
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.ons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.registry.acfs
ONLINE ONLINE rac01
ONLINE ONLINE rac02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac01
ora.oc4j
1 ONLINE ONLINE rac01
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.rac02.vip
1 ONLINE ONLINE rac02
ora.sap.db
1 ONLINE ONLINE rac01 Open
2 ONLINE ONLINE rac02 Open
ora.scan1.vip
1 ONLINE ONLINE rac01
查看数据库实例状态
[root@rac02 u01]# srvctl status database -d sap
Instance sap1 is running on node rac01
Instance sap2 is running on node rac02
查看nodeapps资源状态
[root@rac01 rac01]# srvctl status nodeapps
VIP rac01-vip is enabled
VIP rac01-vip is running on node: rac01
VIP rac02-vip is enabled
VIP rac02-vip is running on node: rac02
Network is enabled
Network is running on node: rac01
Network is running on node: rac02
GSD is disabled
GSD is not running on node: rac01
GSD is not running on node: rac02
ONS is enabled
ONS daemon is running on node: rac01
ONS daemon is running on node: rac02
eONS is enabled
eONS daemon is running on node: rac01
eONS daemon is running on node: rac02
查看listener状态
[root@rac01 rac01]# srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac01,rac02
查看ASM状态
[root@rac01 rac01]# srvctl status asm
ASM is running on rac01,rac02
查看scan状态
[root@rac01 rac01]# srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac01
查看ASM diskgroup状态
[root@rac01 rac01]# srvctl status diskgroup
PRKO-2082 : Missing mandatory option -g
[root@rac01 rac01]# srvctl status diskgroup -g data
Disk Group data is running on rac01,rac02
停掉rac一个节点,例如停掉rac02
1、先停掉数据库实例,使用以下命令
[root@rac01 rac01]# srvctl stop instance -d sap -n rac02 -o immediate
也可以使用以下命令,
[root@rac01 rac01]# srvctl stop instance -d sap -i sap2 -o immediate
查看voting disk
[root@rac01 rac01]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE aeeaa395bb2b4fe0bff37dd0eaafe2c1 (/dev/disk/by-id/scsi-14f504e46494c4552667a507877412d6d616f452d63583051-part1) [OCR]
Located 1 voting disk(s).
查看OCR
[root@rac01 rac01]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2700
Available space (kbytes) : 259420
ID : 1248966756
Device/File Name : +OCR
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
以上是“RAC日常运行中基本启停命令有哪些”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注创新互联行业资讯频道!
新闻名称:RAC日常运行中基本启停命令有哪些
浏览地址:http://pwwzsj.com/article/gjjjdo.html