|
RAC日常运行中一些基本启停命令总结 [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.
[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
[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 (责任编辑：IT) |