6. Support for Oracle RAC 故障排除
节点在 Support for Oracle RAC 初始化期间出现紧急情况
SUNW.rac_framework 或 SUNW.vucmm_framework 资源启动失败
SUNW.vucmm_framework 启动失败的状态消息
7. 修改 Support for Oracle RAC 的现有配置
Support for Oracle RAC 的资源组及资源的状态可指示群集中 Oracle RAC 的状态。使用 Oracle Solaris Cluster 维护命令可获取此状态信息。
要获取资源组的状态信息,请使用 clresourcegroup(1CL) 命令。
要获取资源的状态信息,请使用 clresource(1CL) 命令。
例如:
# clresourcegroup status +
# clresource status -g resource-group +
指定要显示其所含资源的状态信息的资源组。
有关可以指定用于筛选所显示状态信息的选项的信息,请参见以下手册页:
以下示例显示了四节点群集中某个 Support for Oracle RAC 配置的资源组及资源的状态。每个节点都是一台使用 SPARC 处理器的计算机。
此示例中的群集所运行的 Oracle RAC 版本是 10g 发行版 2 或 11g。此示例中的配置使用 Solaris Volume Manager for Sun Cluster 上的 Sun QFS 共享文件系统来存储 Oracle 文件。该配置包括一个多属主卷管理器框架资源组,用于包含卷管理器资源。
下表中显示了用于此配置的资源组及资源。
|
示例 6-1 发生故障的 RAC 框架资源组的状态
此示例提供了发生故障的 RAC 框架资源组的以下状态信息。
出现重新配置错误,此错误已阻止 rac_framework 资源在群集节点 pclus1 上启动。
该重新配置错误对资源组及其他资源的影响如下:
rac-framework-rg 资源组在群集节点 pclus1 上脱机且处于启动失败状态。
rac_udlm 资源、rac_svm 资源以及 crs_framework 资源均在群集节点 pclus1 上处于脱机状态。
所有其他多主资源组以及这些资源组所包含的资源在群集节点 pclus1 上均处于脱机状态。
所有故障转移资源组已从群集节点 pclus1 故障转移到辅助节点。
所有多主资源组及其所包含的资源在其余节点上均处于联机状态。
# clresourcegroup status + === Cluster Resource Groups === Group Name Node Name Suspended Status ---------- --------- --------- ------ rac-framework-rg pclus1 No Online faulted pclus2 No Online pclus3 No Online pclus4 No Online vucmm-framework-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online scaldg-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online qfsmds-rg pclus1 No Offline pclus2 No Online pclus3 No Offline pclus4 No Offline scalmnt-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online rac_server_proxy-rg pclus1 No Pending online blocked pclus2 No Online pclus3 No Online pclus4 No Online # clresource status -g rac-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac-framework-rs pclus1 Start failed Faulted - Error in previous reconfiguration. pclus2 Online Online pclus3 Online Online pclus4 Online Online rac-udlm-rs pclus1 Offline Offline pclus2 Online Online pclus3 Online Online pclus4 Online Online crs_framework-rs pclus1 Offline Offline pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-rs pclus1 Offline Offline pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g scaldg-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scaloradg-rs pclus1 Online Online - Diskgroup online pclus2 Online Online - Diskgroup online pclus3 Online Online - Diskgroup online pclus4 Online Online - Diskgroup online # clresource status -g qfsmds-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- qfs-db_qfs-OraHome-rs pclus1 Offline Offline pclus2 Online Online - Service is online. pclus3 Offline Offline pclus4 Offline Offline qfs-db_qfs-OraData-rs pclus1 Offline Offline pclus2 Online Online - Service is online. pclus3 Offline Offline pclus4 Offline Offline # clresource status -g scalmnt-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scal-db_qfs-OraHome-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online scal-db_qfs-OraData-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g rac_server_proxy-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac_server_proxy-rs pclus1 Offline Offline pclus2 Online Online - Oracle instance UP pclus3 Online Online - Oracle instance UP pclus4 Online Online - Oracle instance UP
示例 6-2 发生故障的 RAC 数据库资源组的状态
此示例提供了发生故障的 RAC 数据库资源组的以下状态信息:
pclus1 上的 Oracle RAC 数据库启动失败。启动失败产生的影响如下:
rac_server_proxy-rg 资源组在节点 pclus1 上处于联机状态但出现故障。
rac_server_proxy-rs 资源在节点 pclus1 上处于脱机状态。
所有其他多主资源组以及这些资源组所包含的资源在所有节点上均处于联机状态。
所有故障转移资源组及其所包含的资源在其主节点上处于联机状态,而在其余节点上处于脱机状态。
# clresourcegroup status + === Cluster Resource Groups === Group Name Node Name Suspended Status ---------- --------- --------- ------ rac-framework-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online vucmm-framework-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online scaldg-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online qfsmds-rg pclus1 No Online pclus2 No Offline pclus3 No Offline pclus4 No Offline scalmnt-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online rac_server_proxy-rg pclus1 No Online faulted pclus2 No Online pclus3 No Online pclus4 No Online # clresource status -g rac_server_proxy-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac_server_proxy-rs pclus1 Offline Offline - Oracle instance DOWN pclus2 Online Online - Oracle instance UP pclus3 Online Online - Oracle instance UP pclus4 Online Online - Oracle instance UP # clresource status -g rac-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online rac-udlm-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online crs_framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g scaldg-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scaloradg-rs pclus1 Online Online - Diskgroup online pclus2 Online Online - Diskgroup online pclus3 Online Online - Diskgroup online pclus4 Online Online - Diskgroup online # clresource status -g qfsmds-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- qfs-db_qfs-OraHome-rs pclus1 Online Online - Service is online. pclus2 Offline Offline pclus3 Offline Offline pclus4 Offline Offline qfs-db_qfs-OraData-rs pclus1 Online Online - Service is online. pclus2 Offline Offline pclus3 Offline Offline pclus4 Offline Offline # clresource status -g scalmnt-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scal-db_qfs-OraHome-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online scal-db_qfs-OraData-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online
示例 6-3 正常运行的 Oracle RAC 配置的状态
此示例显示了正常运行的 Oracle RAC 配置的状态。该示例指示此配置中资源组和资源的状态,如下所示:
所有多主资源组及其所包含的资源在所有节点上处于联机状态。
所有故障转移资源组及其所包含的资源在其主节点上处于联机状态,而在其余节点上处于脱机状态。
# clresourcegroup status + === Cluster Resource Groups === Group Name Node Name Suspended Status ---------- --------- --------- ------ rac-framework-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online vucmm-framework-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online scaldg-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online qfsmds-rg pclus1 No Online pclus2 No Offline pclus3 No Offline pclus4 No Offline scalmnt-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online rac_server_proxy-rg pclus1 No Online pclus2 No Online pclus3 No Online pclus4 No Online # clresource status -g rac-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online rac-udlm-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online crs_framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g scaldg-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scaloradg-rs pclus1 Online Online - Diskgroup online pclus2 Online Online - Diskgroup online pclus3 Online Online - Diskgroup online pclus4 Online Online - Diskgroup online # clresource status -g qfsmds-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- qfs-db_qfs-OraHome-rs pclus1 Online Online - Service is online. pclus2 Offline Offline pclus3 Offline Offline pclus4 Offline Offline qfs-db_qfs-OraData-rs pclus1 Online Online - Service is online. pclus2 Offline Offline pclus3 Offline Offline pclus4 Offline Offline # clresource status -g scalmnt-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- scal-db_qfs-OraHome-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online scal-db_qfs-OraData-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g rac_server_proxy-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- rac_server_proxy-rs pclus1 Online Online - Oracle instance UP pclus2 Online Online - Oracle instance UP pclus3 Online Online - Oracle instance UP pclus4 Online Online - Oracle instance UP