oracle 11g集群启停,ORACLE 11g RAC日常运行中一些基本启停等命令总结

RAC日常运行中一些基本启停命令总结

设置cluster不随着操作系统自动启动[root@rac01 u01]# crsctl disable crsCRS-4621: Oracle High Availability Services autostart is disabled.

设置cluster随着操作系统自动启动，默认是启动的[root@rac01 u01]# crsctl enable crsCRS-4622: Oracle High Availability Services autostart is enabled.

启动cluster，两个节点分别执行[root@rac01 u01]# crsctl start crsCRS-4123: Oracle High Availability Services has been started.[root@rac02 u01]# crsctl start crsCRS-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.dgOFFLINE OFFLINE rac01OFFLINE OFFLINE rac02ora.LISTENER.lsnrONLINE ONLINE rac01ONLINE ONLINE rac02ora.OCR.dgONLINE ONLINE rac01ONLINE ONLINE rac02ora.asmONLINE ONLINE rac01 StartedONLINE ONLINE rac02 Startedora.eonsONLINE ONLINE rac01ONLINE ONLINE rac02ora.gsdOFFLINE OFFLINE rac01OFFLINE OFFLINE rac02ora.net1.networkONLINE ONLINE rac01ONLINE ONLINE rac02ora.onsONLINE ONLINE rac01ONLINE ONLINE rac02ora.registry.acfsONLINE ONLINE rac01ONLINE ONLINE rac02--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac01ora.oc4j1 ONLINE ONLINE rac01ora.rac01.vip1 ONLINE ONLINE rac01ora.rac02.vip1 ONLINE ONLINE rac02ora.sap.db1 OFFLINE OFFLINE2 OFFLINE OFFLINEora.scan1.vip1 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.dgONLINE ONLINE rac01ONLINE ONLINE rac02ora.LISTENER.lsnrONLINE ONLINE rac01ONLINE ONLINE rac02ora.OCR.dgONLINE ONLINE rac01ONLINE ONLINE rac02ora.asmONLINE ONLINE rac01 StartedONLINE ONLINE rac02 Startedora.eonsONLINE ONLINE rac01ONLINE ONLINE rac02ora.gsdOFFLINE OFFLINE rac01OFFLINE OFFLINE rac02ora.net1.networkONLINE ONLINE rac01ONLINE ONLINE rac02ora.onsONLINE ONLINE rac01ONLINE ONLINE rac02ora.registry.acfsONLINE ONLINE rac01ONLINE ONLINE rac02--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac01ora.oc4j1 ONLINE ONLINE rac01ora.rac01.vip1 ONLINE ONLINE rac01ora.rac02.vip1 ONLINE ONLINE rac02ora.sap.db1 ONLINE ONLINE rac01 Open2 ONLINE ONLINE rac02 Openora.scan1.vip1 ONLINE ONLINE rac01

查看数据库实例状态[root@rac02 u01]# srvctl status database -d sapInstance sap1 is running on node rac01Instance sap2 is running on node rac02

查看nodeapps资源状态[root@rac01 rac01]# srvctl status nodeappsVIP rac01-vip is enabledVIP rac01-vip is running on node: rac01VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02Network is enabledNetwork is running on node: rac01Network is running on node: rac02GSD is disabledGSD is not running on node: rac01GSD is not running on node: rac02ONS is enabledONS daemon is running on node: rac01ONS daemon is running on node: rac02eONS is enabledeONS daemon is running on node: rac01eONS daemon is running on node: rac02

查看listener状态[root@rac01 rac01]# srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac01,rac02

查看ASM状态[root@rac01 rac01]# srvctl status asmASM is running on rac01,rac02

查看scan状态[root@rac01 rac01]# srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac01

查看ASM diskgroup状态[root@rac01 rac01]# srvctl status diskgroupPRKO-2082 : Missing mandatory option -g[root@rac01 rac01]# srvctl status diskgroup -g dataDisk 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]# ocrcheckStatus of Oracle Cluster Registry is as follows :Version : 3Total space (kbytes) : 262120Used space (kbytes) : 2700Available space (kbytes) : 259420ID : 1248966756Device/File Name : +OCRDevice/File integrity check succeededDevice/File not configuredDevice/File not configuredDevice/File not configuredDevice/File not configuredCluster registry integrity check succeededLogical corruption check succeeded

本文转自ICT时空 dbasdk博客，原文链接：ORACLE 11g RAC日常运行中一些基本启停等命令总结 ，如需转载请自行联系原博主。