用于 Oracle Real Application Clusters 的 Sun Cluster 数据服务指南(适用于 Solaris OS)

检验 Sun Cluster Support for Oracle Real Application Clusters 的状态

SUNW.rac_framework 资源的状态表明了 Sun Cluster Support for Oracle Real Application Clusters 的状态。Sun Cluster 系统管理工具 scstat(1M) 使您可以获得此资源的状态。

如何检验 Sun Cluster Support for Oracle Real Application Clusters 的状态

  1. 成为超级用户。

  2. 键入以下命令:


    # scstat -g
    

以下示例说明了 Sun Cluster Support for Oracle Real Application Clusters 的双节点配置的资源的状态。此配置使用 Solaris Volume Manager for Sun Cluster 来存储 Oracle Real Application Clusters 数据库。

每个节点均包含一个名为 rac-framework-rg 的 RAC 框架资源组。下表显示了这些资源组中的每个资源的资源类型和资源名称。

资源类型 

资源实例名称 

SUNW.rac_framework

rac_framework

SUNW.rac_udlm

rac_udlm

SUNW.rac_svm

rac_svm

每个节点包含一个 Oracle RAC 服务器资源的资源组(如下表所示)。表中还显示了每个资源组中的资源的资源类型和名称。

节点 

资源组 

资源类型 

资源名称 

node1

RAC1-rg

SUNW.oracle_rac_server

RAC1

node2

RAC2-rg

SUNW.oracle_rac_server

RAC2


实例 3–1 出错的 RAC 框架资源组的状态


-- Resource Groups and Resources --

           Group Name        Resources
           ----------        ---------
Resources: rac-framework-rg  rac_framework rac_udlm rac_svm
Resources: RAC1-rg             RAC1
Resources: RAC2-rg             RAC2


-- Resource Groups --

            Group Name        Node Name  State
            ----------        ---------  -----
     Group: rac-framework-rg  node1      Online faulted
     Group: rac-framework-rg  node2      Online

     Group: RAC1-rg           node1       Online

     Group: RAC2-rg           node2     Online


-- Resources --

            Resource Name    Node Name  State     Status Message
            -------------    ---------  -----     --------------
  Resource: rac_framework    node1      Start failed Degraded - reconfiguration in progress
  Resource: rac_framework    node2      Online    Online

  Resource: rac_udlm         node1      Offline   Unknown - RAC framework is running
  Resource: rac_udlm         node2      Online    Online

  Resource: rac_svm          node1      Offline   Unknown - RAC framework is running
  Resource: rac_svm          node2      Online    Online

  Resource: RAC1             node1      Online    Online

  Resource: RAC2             node2      Online    Faulted

本例提供了有关出现故障的 RAC 框架资源组的以下状态信息。



实例 3–2 出现故障的 RAC 服务器资源组的状态


-- Resource Groups and Resources --

             Group Name          Resources
             ----------          ---------
  Resources: rac-framework-rg    rac_framework rac_udlm rac_svm
  Resources: RAC1-rg             RAC1    
  Resources: RAC2-rg             RAC2    


-- Resource Groups --

             Group Name          Node Name      State
             ----------          ---------      -----
      Group: rac-framework-rg    node1          Online
      Group: rac-framework-rg    node2          Online

      Group: RAC1-rg             node1          Online

      Group: RAC2-rg             node2          Online faulted


-- Resources --

             Resource Name      Node Name      State     Status Message
             -------------      ---------      -----     --------------
   Resource: rac_framework      node1          Online    Online
   Resource: rac_framework      node2          Online    Online

   Resource: rac_udlm           node1          Online    Online
   Resource: rac_udlm           node2          Online    Online

   Resource: rac_svm            node1          Online    Online
   Resource: rac_svm            node2          Online    Online

   Resource: RAC1               node1          Online    Online

   Resource: RAC2               node2          Online    Faulted - RAC instance not running

本例提供了有关出现故障的 RAC 服务器资源组的以下状态信息:



实例 3–3 运行正常的 Oracle Real Application Clusters 配置的状态


-- Resource Groups and Resources --

             Group Name          Resources
             ----------          ---------
  Resources: rac-framework-rg    rac_framework rac_udlm rac_svm
  Resources: RAC1-rg             RAC1    
  Resources: RAC2-rg             RAC2    


-- Resource Groups --

             Group Name          Node Name           State
             ----------          ---------           -----
      Group: rac-framework-rg    node1               Online
      Group: rac-framework-rg    node2               Online

      Group: RAC1-rg             node1               Online

      Group: RAC2-rg             node2               Online


-- Resources --

             Resource Name       Node Name           State     Status Message
             -------------       ---------           -----     --------------
   Resource: rac_framework       node1               Online    Online
   Resource: rac_framework       node2               Online    Online

   Resource: rac_udlm            node1               Online    Online
   Resource: rac_udlm            node2               Online    Online

   Resource: rac_svm             node1               Online    Online
   Resource: rac_svm             node2               Online    Online

   Resource: RAC1                node1               Online    Online

   Resource: RAC2                node2               Online    Online

本例显示了运行正常的 Oracle Real Application Clusters 配置的状态。示例表明该配置中的所有资源和资源组均已联机。