Oracle RAC集群测试-生产环境最佳方法（Oracle 11g/12c RAC安装后期测试）

川长思鸟来 2022-02-26 05:48 311阅读 0赞

**生产环境Oracle RAC集群测试最佳方法（Oracle 11g/12c RAC安装后期测试过程）**

**一、Oracle RAC集群测试背景**

某中大型制造业公司，由于要新上项目，建设了一套业务系统-ERP系统，这套系统的数据库环境是Oracle RAC（RHEL Linux7+Oracle11gR2 RAC）架构 ，根据风哥提供的建设方案（**点击学习>>>Linux[生产环境Oracle 11gR2 RAC集群安装配置与维护][Oracle 11gR2 RAC]**）项目已经建设完成。

这套ERP系统的RAC集群数据库在上线之前，我们需要对RAC集群做一些功能测试，这个测试方法适用于Oracle11g/12c,也适用于oracle18c/19c。

**二、Oracle RAC集群的介绍**

在测试之前，这里风哥给大家介绍一下Oracle RAC是什么：Oracle 真正应用集群技术(Oracle Real Application Cluster )是Oracle 9i及以后版本，Oracle 9i之前叫OPS集群。Oracle RAC主要支持Oracle9i、10g、11g、12c版本（18c，19c）。 在Oracle RAC环境下，Oracle集群提供了集群软件和存储管理软件，集群软件CRS/GRID，存储管理软件ASM(自动存储管理)，多个节点共享一份数据。

ORACLE RAC架构如下：

![ORACLE RAC架构.png][ORACLE RAC_.png]

**其中Oracle RAC在物理架构上，硬件设备主要包括如下部分：**

服务器、共享存储设备（共享存储，光纤交换机，HBA卡，光纤线）、网络设备（网络交换机，光纤交换机，网线）

**1）服务器**

我们称这个服务器为“数据库服务器”，“数据库主机”，在RAC的术语中我们又称其为“节点”，服务器的配置应该相同，cpu，内存等。

**2）网络设备**

每台服务器上至少两块物理网卡，分别用于主机间私有通信和对外公用通信，也可以有多快网卡，进行网卡绑定，实现网卡的冗余。

私有通信的网卡叫private NIC，对应的IP为private IP。

公用通信的网卡叫public NIC，对应的IP为public IP。

**3）共享存储设备**

共享存储是整个RAC架构中的核心

每台服务器至少一块/两块HBA卡，用于共享存储的连接。

可以用光纤线直连存储，也可以通过光纤交换机，我们建议使用光纤交换机。

RAC是一个典型的“多实例，单数据库”架构，被所有节点共享，并行访问。

数据库数据文件，控制文件，参数文件，联机重做日志文件，甚至归档日志文件都放在共享存储

上，并保证可以被所有节点同时访问。IO性能要求比较高，一般用光纤线连接。

**另外Oracle RAC还有两种集群模式：**

Oracle  RAC 同时具备HA(High Availiablity) 、LB(LoadBalance)。

**1）Failover(故障转移)：**

它指集群中任何一个节点的故障都不会影响用户的使用，连接到故障节点的用户会被自动转移到健康节点，从用户感受而言， 是感觉不到这种切换。

**2）LoadBalance（负载均衡）：**

就是把负载平均的分配到集群中的各个节点，从而提高整体的吞吐能力。

**三、Oracle RAC集群功能测试**

<table style="width:695px;"> 
 <tbody> 
  <tr> 
   <td>序号</td> 
   <td>OracleRAC测试项目</td> 
   <td>OracleRAC测试方法</td> 
   <td>OracleRAC正确结果</td> 
   <td>OracleRAC测试结果</td> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td>检查数据库的版本和补丁</td> 
   <td>select&nbsp;*&nbsp;from&nbsp;v$version;</td> 
   <td>Oracle&nbsp;11/12c相应版本</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>数据库启动和关闭</td> 
   <td>startup</td> 
   <td>能正常启动和关闭</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>Shutdown&nbsp;immediate</td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>逻辑备份</td> 
   <td>exp,expdp</td> 
   <td>导出成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>字符集</td> 
   <td>select&nbsp;name,value$&nbsp;from</td> 
   <td>ZHS16GBK&nbsp;&nbsp;、&nbsp;UTF8</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>props$</td> 
  </tr> 
  <tr> 
   <td>where&nbsp;name&nbsp;like</td> 
  </tr> 
  <tr> 
   <td>'%CHARACTERSET%';</td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>创建/删除</td> 
   <td>create&nbsp;tablespace&nbsp;fgedudata01</td> 
   <td>创建成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>表空间</td> 
   <td>datafile&nbsp;'+fgedudata1’&nbsp;</td> 
   <td>删除成功</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>size&nbsp;10m&nbsp;autoextend&nbsp;off;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>drop&nbsp;tablespace&nbsp;fgedudata01</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
   <td>including&nbsp;contents&nbsp;and&nbsp;files;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>创建/删除用户</td> 
   <td>create&nbsp;user&nbsp;fgedu&nbsp;identified</td> 
   <td>创建成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>&nbsp;by&nbsp;test&nbsp;default&nbsp;tablespace</td> 
   <td>删除成功</td> 
  </tr> 
  <tr> 
   <td>fgedudata01&nbsp;temporary&nbsp;tablespace&nbsp;temp;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>drop&nbsp;user&nbsp;fgedu&nbsp;cascade;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>创建/删除表</td> 
   <td>create&nbsp;table&nbsp;fgedu.itpux</td> 
   <td>创建成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>(name&nbsp;varchar2(10),id&nbsp;number);</td> 
   <td>删除成功</td> 
  </tr> 
  <tr> 
   <td>drop&nbsp;table&nbsp;fgedu.itpux;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>插入/删除数据</td> 
   <td>Insert&nbsp;into&nbsp;fgedu.itpux&nbsp;values('itpux01',’1);</td> 
   <td>插入成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>Commit;</td> 
   <td>删除成功</td> 
  </tr> 
  <tr> 
   <td>Delete&nbsp;from&nbsp;fgedu.itpux</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>Commit;</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>9</td> 
   <td>客户端连接到</td> 
   <td>sqlplus&nbsp;“sys/oracle@itpuxdb&nbsp;as&nbsp;sysdba”;</td> 
   <td>连接成功</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>数据库</td> 
  </tr> 
  <tr> 
   <td>10</td> 
   <td>修改数据库为归档模式</td> 
   <td>Alter&nbsp;system&nbsp;set&nbsp;db_recovery_file_dest='+dgrecover'&nbsp;scope=spfile;</td> 
   <td>归档模式</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>alter&nbsp;system&nbsp;set&nbsp;db_recovery_file_dest_size=200G&nbsp;scope=spfile;</td> 
  </tr> 
  <tr> 
   <td>Srvctl&nbsp;stop&nbsp;database&nbsp;-d&nbsp;fgerpdb</td> 
  </tr> 
  <tr> 
   <td>Sqlplus&nbsp;“/as&nbsp;sysdba”</td> 
  </tr> 
  <tr> 
   <td>Startup&nbsp;mount;</td> 
  </tr> 
  <tr> 
   <td>Alter&nbsp;database&nbsp;archivelog;</td> 
  </tr> 
  <tr> 
   <td>Shutdown&nbsp;immediate</td> 
  </tr> 
  <tr> 
   <td>Srvctl&nbsp;start&nbsp;database&nbsp;-d&nbsp;fgerpdb</td> 
  </tr> 
 </tbody> 
</table>

**四、Oracle RAC集群负载测试**

<table style="width:680px;"> 
 <tbody> 
  <tr> 
   <td>序号</td> 
   <td>OracleRAC测试内容</td> 
   <td>OracleRAC测试方法</td> 
   <td>OracleRAC正确结果</td> 
   <td>OracleRAC测试结果</td> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td>客户端连接数据库（RAC方式）</td> 
   <td>sqlplus&nbsp;“sys/itpux123@itpuxdb&nbsp;as&nbsp;sysdba”;</td> 
   <td>连接成功,并且每次连接有可能分布到不同的实例上</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>select&nbsp;instance_name&nbsp;from&nbsp;v$instance;</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td>CRS正常启动关闭</td> 
   <td>crsctl&nbsp;start&nbsp;crs</td> 
   <td>能正常启动和关闭</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>crsctl&nbsp;stop&nbsp;crs</td> 
  </tr> 
  <tr> 
   <td>3</td> 
   <td>网络连接中断（public网络）</td> 
   <td>拔掉节点一public网卡的网线</td> 
   <td>本节点实例正常，vip漂移到节点二，listener,ons,network服务offline,原先连接到节点一的连接自动连接至节点二</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>4</td> 
   <td>网络连接恢复（public网络）</td> 
   <td>插回节点一public网卡的网线</td> 
   <td>vip漂移回节点一，listener,ons,network服务自动onlien，crs资源恢复正常</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>5</td> 
   <td>网络连接中断（private网络）</td> 
   <td>拔掉节点一private网卡的网线</td> 
   <td>节点二重启，crs资源offline，vip漂移到节点一，原先连接到节点二的连接自动连接至节点1</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>6</td> 
   <td>网络连接恢复（private网络）</td> 
   <td>插回节点一private网卡的网线，使用crsctl&nbsp;start&nbsp;crs启动crs</td> 
   <td>节点二的vip漂移回节点二，节点二crs资源恢复正常</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>7</td> 
   <td>网络连接中断（public网络）</td> 
   <td>拔掉节点二public网卡的网线</td> 
   <td>本节点实例正常，vip漂移到节点一，listener,ons,network服务offline,原先连接到节点二的连接自动连接至节点一</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>8</td> 
   <td>网络连接恢复（public网络）</td> 
   <td>插回节点二public网卡的网线</td> 
   <td>vip漂移回节点二，listener,ons,network服务自动onlien，crs资源恢复正常</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>9</td> 
   <td>网络连接中断（private网络）</td> 
   <td>拔掉节点二private网卡的网线</td> 
   <td>节点二重启，crs资源offline，vip漂移到节点一，原先连接到节点二的连接自动连接至节点1</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>10</td> 
   <td>网络连接恢复（private网络）</td> 
   <td>插回节点二private网卡的网线，使用crsctl&nbsp;start&nbsp;crs启动crs</td> 
   <td>节点二的vip漂移回节点二，节点二crs资源恢复正常</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>11</td> 
   <td>负载均衡</td> 
   <td>开启多个数据库连接</td> 
   <td>多次连接应分布在两个节点</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>12</td> 
   <td>透明故障切换</td> 
   <td>使用RAC的方式连接数据库</td> 
   <td>连接不中断,查询继续并自动切换至另一实例</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>select&nbsp;instance_name&nbsp;from&nbsp;v$instance;</td> 
  </tr> 
  <tr> 
   <td>关闭当前实例后</td> 
  </tr> 
  <tr> 
   <td>select&nbsp;instance_name&nbsp;from&nbsp;v$instance;</td> 
  </tr> 
  <tr> 
   <td>13</td> 
   <td>正常维护，正常关闭节点1</td> 
   <td>Crsctl&nbsp;stop&nbsp;crs</td> 
   <td>Scan&nbsp;vip,vip漂移到节点二，原先连接到节点一的连接自动连接至节点二</td> 
   <td>是否正常：</td> 
  </tr> 
  <tr> 
   <td>14</td> 
   <td>正常维护，正常关闭节点2</td> 
   <td>Crsctl&nbsp;stop&nbsp;crs</td> 
   <td>vip漂移到节点一，原先连接到节点二的连接自动连接至节点一</td> 
   <td>是否正常：</td> 
  </tr> 
 </tbody> 
</table>

**针对测试列表中的第1点：客户端连接到数据库(RAC负载均衡测试)**

Oracle 客户端的tnsnames.ora模式如下:只需要配置scan对应的name或ip地址即可，如下所示：

fgerpdb =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = www.fgedu.net.cn)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = fgerpdb)
        )
      )

**最终Oracle RAC的测试效果如下：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21ma3F3eWM4Ng_size_16_color_FFFFFF_t_70][]

**针对测试列表中的第12点:客户端连接到数据库(RAC透明切换测试)，**

客户端tnsnames.ora配置

fgerpdbtaf= 
     (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = www.fgedu.net.cn)(PORT = 1521))
      (LOAD_BALANCE = YES)
      (CONNECT_DATA = 
       (SERVER = DEDICATED)
       (SERVICE_NAME = fgerpdb)
       (FAILOVER_MODE = 
       (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
       )
      )
     )

tnsping fgerpdbtaf  测试连通性

连通ok后，再用第12点的方式测试透明故障切换

**五、Oracle RAC集群维护命令**

**5.1.Oracle RAC常用命令工具**

以下内容是风哥推荐大家需要熟悉的常用命令，日常工作中需要经常参考来使用。

$ srvctl -h
    Usage: srvctl [-V]
    Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL}] [-g "<serverpool_list>"] [-x <node_name>] [-a "<diskgroup_list>"]
    Usage: srvctl config database [-d <db_unique_name> [-a] ]
    Usage: srvctl start database -d <db_unique_name> [-o <start_options>]
    Usage: srvctl stop database -d <db_unique_name> [-o <stop_options>] [-f]
    Usage: srvctl status database -d <db_unique_name> [-f] [-v]
    Usage: srvctl enable database -d <db_unique_name> [-n <node_name>]
    Usage: srvctl disable database -d <db_unique_name> [-n <node_name>]
    Usage: srvctl modify database -d <db_unique_name> [-n <db_name>] [-o <oracle_home>] [-u <oracle_user>] [-m <domain>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-y {AUTOMATIC | MANUAL}] [-g "<serverpool_list>" [-x <node_name>]] [-a "<diskgroup_list>"|-z]
    Usage: srvctl remove database -d <db_unique_name> [-f] [-y]
    Usage: srvctl getenv database -d <db_unique_name> [-t "<name_list>"]
    Usage: srvctl setenv database -d <db_unique_name> {-t <name>=<val>[,<name>=<val>,...] | -T <name>=<val>}
    Usage: srvctl unsetenv database -d <db_unique_name> -t "<name_list>"
    
    Usage: srvctl add instance -d <db_unique_name> -i <inst_name> -n <node_name> [-f]
    Usage: srvctl start instance -d <db_unique_name> {-n <node_name> [-i <inst_name>] | -i <inst_name_list>} [-o <start_options>]
    Usage: srvctl stop instance -d <db_unique_name> {-n <node_name> | -i <inst_name_list>}  [-o <stop_options>] [-f]
    Usage: srvctl status instance -d <db_unique_name> {-n <node_name> | -i <inst_name_list>} [-f] [-v]
    Usage: srvctl enable instance -d <db_unique_name> -i "<inst_name_list>"
    Usage: srvctl disable instance -d <db_unique_name> -i "<inst_name_list>"
    Usage: srvctl modify instance -d <db_unique_name> -i <inst_name> { -n <node_name> | -z }
    Usage: srvctl remove instance -d <db_unique_name> [-i <inst_name>] [-f] [-y]
    
    Usage: srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <server_pool> [-c {UNIFORM | SINGLETON}] } [-k   <net_num>] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <failover_retries>] [-w <failover_delay>]
    Usage: srvctl add service -d <db_unique_name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"}
    Usage: srvctl config service -d <db_unique_name> [-s <service_name>] [-a]
    Usage: srvctl enable service -d <db_unique_name> -s "<service_name_list>" [-i <inst_name> | -n <node_name>]
    Usage: srvctl disable service -d <db_unique_name> -s "<service_name_list>" [-i <inst_name> | -n <node_name>]
    Usage: srvctl status service -d <db_unique_name> [-s "<service_name_list>"] [-f] [-v]
    Usage: srvctl modify service -d <db_unique_name> -s <service_name> -i <old_inst_name> -t <new_inst_name> [-f]
    Usage: srvctl modify service -d <db_unique_name> -s <service_name> -i <avail_inst_name> -r [-f]
    Usage: srvctl modify service -d <db_unique_name> -s <service_name> -n -i "<preferred_list>" [-a "<available_list>"] [-f]
    Usage: srvctl modify service -d <db_unique_name> -s <service_name> [-c {UNIFORM | SINGLETON}] [-P {BASIC|PRECONNECT|NONE}] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-x {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <integer>] [-w <integer>]
    Usage: srvctl relocate service -d <db_unique_name> -s <service_name> {-i <old_inst_name> -t <new_inst_name> | -c <current_node> -n <target_node>} [-f]
           Specify instances for an administrator-managed database, or nodes for a policy managed database
    Usage: srvctl remove service -d <db_unique_name> -s <service_name> [-i <inst_name>] [-f]
    Usage: srvctl start service -d <db_unique_name> [-s "<service_name_list>" [-n <node_name> | -i <inst_name>] ] [-o <start_options>]
    Usage: srvctl stop service -d <db_unique_name> [-s "<service_name_list>" [-n <node_name> | -i <inst_name>] ] [-f]
    
    Usage: srvctl add nodeapps { { -n <node_name> -A <name|ip>/<netmask>/[if1[|if2...]] } | { -S <subnet>/<netmask>/[if1[|if2...]] } } [-p <portnum>] [-m <multicast-ip-address>] [-e <eons-listen-port>] [-l <ons-local-port>]  [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
    Usage: srvctl config nodeapps [-a] [-g] [-s] [-e]
    Usage: srvctl modify nodeapps {[-n <node_name> -A <new_vip_address>/<netmask>[/if1[|if2|...]]] | [-S <subnet>/<netmask>[/if1[|if2|...]]]} [-m <multicast-ip-address>] [-p <multicast-portnum>] [-e <eons-listen-port>] [ -l <ons-local-port> ] [-r <ons-remote-port> ] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
    Usage: srvctl start nodeapps [-n <node_name>] [-v]
    Usage: srvctl stop nodeapps [-n <node_name>] [-f] [-r] [-v]
    Usage: srvctl status nodeapps
    Usage: srvctl enable nodeapps [-v]
    Usage: srvctl disable nodeapps [-v]
    Usage: srvctl remove nodeapps [-f] [-y] [-v]
    Usage: srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "<name_list>"]
    Usage: srvctl setenv nodeapps {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
    Usage: srvctl unsetenv nodeapps -t "<name_list>" [-v]
    
    Usage: srvctl add vip -n <node_name> -k <network_number> -A <name|ip>/<netmask>/[if1[|if2...]] [-v]
    Usage: srvctl config vip { -n <node_name> | -i <vip_name> }
    Usage: srvctl disable vip -i <vip_name> [-v]
    Usage: srvctl enable vip -i <vip_name> [-v]
    Usage: srvctl remove vip -i "<vip_name_list>" [-f] [-y] [-v]
    Usage: srvctl getenv vip -i <vip_name> [-t "<name_list>"]
    Usage: srvctl start vip { -n <node_name> | -i <vip_name> } [-v]
    Usage: srvctl stop vip { -n <node_name>  | -i <vip_name> } [-f] [-r] [-v]
    Usage: srvctl status vip { -n <node_name> | -i <vip_name> }
    Usage: srvctl setenv vip -i <vip_name> {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
    Usage: srvctl unsetenv vip -i <vip_name> -t "<name_list>" [-v]
    
    Usage: srvctl add asm [-l <lsnr_name>]
    Usage: srvctl start asm [-n <node_name>] [-o <start_options>]
    Usage: srvctl stop asm [-n <node_name>] [-o <stop_options>] [-f]
    Usage: srvctl config asm [-a]
    Usage: srvctl status asm [-n <node_name>] [-a]
    Usage: srvctl enable asm [-n <node_name>]
    Usage: srvctl disable asm [-n <node_name>]
    Usage: srvctl modify asm [-l <lsnr_name>]
    Usage: srvctl remove asm [-f]
    Usage: srvctl getenv asm [-t <name>[, ...]]
    Usage: srvctl setenv asm -t "<name>=<val> [,...]" | -T "<name>=<value>"
    Usage: srvctl unsetenv asm -t "<name>[, ...]"
    
    Usage: srvctl start diskgroup -g <dg_name> [-n "<node_list>"]
    Usage: srvctl stop diskgroup -g <dg_name> [-n "<node_list>"] [-f]
    Usage: srvctl status diskgroup -g <dg_name> [-n "<node_list>"] [-a]
    Usage: srvctl enable diskgroup -g <dg_name> [-n "<node_list>"]
    Usage: srvctl disable diskgroup -g <dg_name> [-n "<node_list>"]
    Usage: srvctl remove diskgroup -g <dg_name> [-f]
    
    Usage: srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-o <oracle_home>] [-k <net_num>]
    Usage: srvctl config listener [-l <lsnr_name>] [-a]
    Usage: srvctl start listener [-l <lsnr_name>] [-n <node_name>]
    Usage: srvctl stop listener [-l <lsnr_name>] [-n <node_name>] [-f]
    Usage: srvctl status listener [-l <lsnr_name>] [-n <node_name>]
    Usage: srvctl enable listener [-l <lsnr_name>] [-n <node_name>]
    Usage: srvctl disable listener [-l <lsnr_name>] [-n <node_name>]
    Usage: srvctl modify listener [-l <lsnr_name>] [-o <oracle_home>] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-u <oracle_user>] [-k <net_num>]
    Usage: srvctl remove listener [-l <lsnr_name> | -a] [-f]
    Usage: srvctl getenv listener [-l <lsnr_name>] [-t <name>[, ...]]
    Usage: srvctl setenv listener [-l <lsnr_name>] -t "<name>=<val> [,...]" | -T "<name>=<value>"
    Usage: srvctl unsetenv listener [-l <lsnr_name>] -t "<name>[, ...]"
    
    Usage: srvctl add scan -n <scan_name> [-k <network_number> [-S <subnet>/<netmask>[/if1[|if2|...]]]]
    Usage: srvctl config scan [-i <ordinal_number>]
    Usage: srvctl start scan [-i <ordinal_number>] [-n <node_name>]
    Usage: srvctl stop scan [-i <ordinal_number>] [-f]
    Usage: srvctl relocate scan -i <ordinal_number> [-n <node_name>]
    Usage: srvctl status scan [-i <ordinal_number>]
    Usage: srvctl enable scan [-i <ordinal_number>]
    Usage: srvctl disable scan [-i <ordinal_number>]
    Usage: srvctl modify scan -n <scan_name>
    Usage: srvctl remove scan [-f] [-y]
    Usage: srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]]
    Usage: srvctl config scan_listener [-i <ordinal_number>]
    Usage: srvctl start scan_listener [-n <node_name>] [-i <ordinal_number>]
    Usage: srvctl stop scan_listener [-i <ordinal_number>] [-f]
    Usage: srvctl relocate scan_listener -i <ordinal_number> [-n <node_name>]
    Usage: srvctl status scan_listener [-i <ordinal_number>]
    Usage: srvctl enable scan_listener [-i <ordinal_number>]
    Usage: srvctl disable scan_listener [-i <ordinal_number>]
    Usage: srvctl modify scan_listener {-u|-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]}
    Usage: srvctl remove scan_listener [-f] [-y]
    
    Usage: srvctl add srvpool -g <pool_name> [-l <min>] [-u <max>] [-i <importance>] [-n "<server_list>"]
    Usage: srvctl config srvpool [-g <pool_name>]
    Usage: srvctl status srvpool [-g <pool_name>] [-a]
    Usage: srvctl status server -n "<server_list>" [-a]
    Usage: srvctl relocate server -n "<server_list>" -g <pool_name> [-f]
    Usage: srvctl modify srvpool -g <pool_name> [-l <min>] [-u <max>] [-i <importance>] [-n "<server_list>"]
    Usage: srvctl remove srvpool -g <pool_name>
    
    Usage: srvctl add oc4j [-v]
    Usage: srvctl config oc4j
    Usage: srvctl start oc4j [-v]
    Usage: srvctl stop oc4j [-f] [-v]
    Usage: srvctl relocate oc4j [-n <node_name>] [-v]
    Usage: srvctl status oc4j [-n <node_name>]
    Usage: srvctl enable oc4j [-n <node_name>] [-v]
    Usage: srvctl disable oc4j [-n <node_name>] [-v]
    Usage: srvctl modify oc4j -p <oc4j_rmi_port> [-v]
    Usage: srvctl remove oc4j [-f] [-v]
    
    Usage: srvctl start home -o <oracle_home> -s <state_file> -n <node_name>
    Usage: srvctl stop home -o <oracle_home> -s <state_file> -n <node_name> [-t <stop_options>] [-f]
    Usage: srvctl status home -o <oracle_home> -s <state_file> -n <node_name>
    
    Usage: srvctl add filesystem -d <volume_device> -v <volume_name> -g <dg_name> [-m <mountpoint_path>] [-u <user>]
    Usage: srvctl config filesystem -d <volume_device>
    Usage: srvctl start filesystem -d <volume_device> [-n <node_name>]
    Usage: srvctl stop filesystem -d <volume_device> [-n <node_name>] [-f]
    Usage: srvctl status filesystem -d <volume_device>
    Usage: srvctl enable filesystem -d <volume_device>
    Usage: srvctl disable filesystem -d <volume_device>
    Usage: srvctl modify filesystem -d <volume_device> -u <user>
    Usage: srvctl remove filesystem -d <volume_device> [-f]
    
    Usage: srvctl start gns [-v] [-l <log_level>] [-n <node_name>]
    Usage: srvctl stop gns [-v] [-n <node_name>] [-f]
    Usage: srvctl config gns [-v] [-a] [-d] [-k] [-m] [-n <node_name>] [-p] [-s] [-V]
    Usage: srvctl status gns -n <node_name>
    Usage: srvctl enable gns [-v] [-n <node_name>]
    Usage: srvctl disable gns [-v] [-n <node_name>]
    Usage: srvctl relocate gns [-v] [-n <node_name>] [-f]
    Usage: srvctl add gns [-v] -d <domain> -i <vip_name|ip> [-k <network_number> [-S <subnet>/<netmask>[/<interface>]]]
    srvctl modify gns [-v] [-f] [-l <log_level>] [-d <domain>] [-i <ip_address>] [-N <name> -A <address>] [-D <name> -A <address>] [-c <name> -a <alias>] [-u <alias>] [-r <address>] [-V <name>] [-F <forwarded_domains>] [-R <refused_domains>] [-X <excluded_interfaces>]
    Usage: srvctl remove gns [-f] [-d <domain_name>]
    
    $ ./crsctl -h
    Usage: crsctl add       - add a resource, type or other entity
           crsctl check     - check a service, resource or other entity
           crsctl config    - output autostart configuration
           crsctl debug     - obtain or modify debug state
           crsctl delete    - delete a resource, type or other entity
           crsctl disable   - disable autostart
           crsctl enable    - enable autostart
           crsctl get       - get an entity value
           crsctl getperm   - get entity permissions
           crsctl lsmodules - list debug modules
           crsctl modify    - modify a resource, type or other entity
           crsctl query - query service state
           crsctl pin - Pin the nodes in the nodelist
           crsctl relocate - relocate a resource, server or other entity
           crsctl replace  - replaces the location of voting files
           crsctl setperm   - set entity permissions
           crsctl set       - set an entity value
           crsctl start     - start a resource, server or other entity
           crsctl status    - get status of a resource or other entity
           crsctl stop      - stop a resource, server or other entity
           crsctl unpin     - unpin the nodes in the nodelist
           crsctl unset     - unset a entity value, restoring its default

**5.2.Oracle RAC集群日常维护命令**

以下内容是风哥推荐大家必须要记住的常用操作，日常工作中必须经常使用。

1．停止数据库上的所有节点和启动数据库上的所有节点
    Srvctl stop database -d fgedu –o immediate
    Srvctl start database -d fgedu
    
    2．停止数据库上的所有asm磁盘组和启动数据库上的所有磁盘组
    Srvctl stop asm –g crs
    Srvctl stop asm –g dgsystem
    Srvctl stop asm –g fgedudata1
    Srvctl stop asm –g dgrecover
    Srvctl start asm –g crs
    Srvctl start asm –g dgsystem
    Srvctl start asm –g fgedudata1
    Srvctl start asm –g dgrecover
    
    3．停止对应节点上的listener和启动对应节点上的listener
    Srvctl stop listener -n fgerp61
    Srvctl stop listener -n fgerp62
    Srvctl start listener -n fgerp61
    Srvctl start listener -n fgerp62
    
    4．停止scan_listener和启动scan_listener
    Srvctl stop scan_listener 
    Srvctl start scan_listener
    
    5．停止scan和启动scan
    Srvctl stop scan
    Srvctl start scan
    
    6．停止对应节点上的资源和启动对应节点上的资源
    Srvctl stop nodeapps -n fgerp62
    Srvctl stop nodeapps -n fgerp61
    Srvctl start nodeapps -n fgerp62
    Srvctl start nodeapps -n fgerp61
    
    7．停止crs和启动crs
    停止crs
    crsctl stop crs
    Crsctl stop crs的方式能把所有grid进程都关闭掉
    
    启动crs
    crsctl start crs
    
    8．检查crs资源状态
    crsctl status resource -t
    crs_stat –t
    
    9、用asmcmd工具管理asm磁盘组
    查看磁盘组容量
    asmcmd lsdg

如果大家已经有一套Oracle RAC集群环境了，即可按照上面的过程来测试，如果还没有这套环境，可以参照风哥的Oracle RAC教程：**[点击学习>>> :生产环境Linux+Oracle 11gR2 RAC集群安装配置与维护][Oracle 11gR2 RAC]，**来搭建Oracle RAC集群环境用于学习和测试，更多Oracle/MySQL/NoSQL数据库高端项目课程：[http://www.fgedu.net.cn/oracle.html][http_www.fgedu.net.cn_oracle.html]，或者加数据库交流QQ群：189070296、150201289。

[Oracle 11gR2 RAC]: http://edu.51cto.com/sd/fdb35
[ORACLE RAC_.png]: /images/20220226/7c96c71a0d624a41b3c300fc2583a8ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21ma3F3eWM4Ng_size_16_color_FFFFFF_t_70]: /images/20220226/47c9824d9a254064b84e73edeef90219.png
[http_www.fgedu.net.cn_oracle.html]: http://www.fgedu.net.cn/oracle.html