Subject: HOW TO REMOVE CRS AUTO START AND RESTART FOR A RAC INSTANCE
Doc ID: Note:298073.1 Type: BULLETIN
Last Revision Date: 13-MAY-2005 Status: PUBLISHED
***
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
***
PURPOSE
-------
HOW TO REMOVE CRS AUTO START AND RESTART FOR A RAC INSTANCE
with Oracle Database 10g (10.1.0.4)
SCOPE & APPLICATION
-------------------
Anyone with an RAC Database using Oracle Clusterware (CRS) and
Oracle Database 10g. You must be at 10.1.0.4.
HOW TO REMOVE CRS AUTO START AND RESTART FOR A RAC INSTANCE
-----------------------------------------------------------
OVERVIEW
Oracle Clusterware (CRS) is a new feature of Oracle Database 10g Real
Application Clusters that further differentiates RAC for high availability and
scalability. CRS provides automated management and sophisticated monitoring of
RAC instances and is designed to enhance the overall user experience of cluster
database management.
By default, CRS is configured to auto-start database instances as a part of node
boot and provide lights-out instance failure detection followed by an
auto-restart of the failed instance. However, on some special occasions,
it might be highly desirable to limit the level of protection CRS provides
for a RAC database. Namely, this implies preventing instances from auto-starting
on boot and not auto-restarting failed instances. The latter, however, may be
relaxed to allow a single attempt to restart a failed instance. This way, CRS
will attempt to restore availability of the instance, but avoid thrashing if a
problem that caused the instance to fail also keeps preventing it from
successfully recovering on restart. Either way, the choice to customize this is
left to the DBA.
Oracle Database 10g Real Application Clusters release 10.1.0.4 and above make
it possible to accomplish the above stated change in CRS behavior. This document
lists the steps necessary to limit the level of CRS protection over a RAC
database.
HIGH LEVEL APPROACH
In a nutshell, the procedure amounts to the following two parts
1. Identifying a set of CRS resources that affect the behavior
2. Modifying a few profile attributes to contain special values for the
resources identified in the first step
The following sections will cover both phases in detail.
IDENTIFYING RELEVANT RESOURCES
The automated management of a RAC database is accomplished by modeling various
RAC applications/features as CRS resources. A CRS resource is defined by a
profile, which contains a list of attributes that tell CRS how manage the
resource. CRS resources created to manage a RAC database can be identified as
belonging to a well-known type. There is a finite and relatively small number
of types. The type may be easily identified given the name of a resource: each
name ends with a <resource_type>. For instance, ora.linux.db is of type db,
which happens to mean database. To display the names of the resources managed
by the CRS, use the crs_stat command from a clustered node. The output of the
command is a set of names and states of resources registered on the cluster to
which the node belongs.
Figure 1. Example Listing resource names using crs_stat
$ crs_stat
NAME=ora.linux.ar.us.oracle.com.cs
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.linux.ar.us.oracle.com.linux.srv
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
Additional output is available but has been truncated for clarity's sake
The relevant resources are the resources that belong to the following 4 types:
db - Denotes resources that represent a database
srv -Denotes resources that represent a service member.
cs - Denotes resources that represent a service.
inst - Denotes resources that represent a database instance
The CRS profiles for these resources must be modified for the new CRS behavior
to take effect for all RAC databases installed on the cluster. If, however,
the affect of the change is to be limited to a subset of installed databases,
the list of resources needs to be filtered further. (The rest of this section
should be skipped if the new CRS behavior is to be in effect for all databases
installed on the cluster.)
Please note that since more than one database may be installed on a cluster,
to modify the level of protection for a particular database, one must identify
the resources that represent entities of this database. This may be easily
accomplished since the names of the resources belonging to the above- stated
types always start with ora.<database name>. For instance, ora.linux.db
means that the resource belongs to the database named linux. Only resources of
the above-enumerated types that belong to the selected databases will need to
have their profiles modified.
MODIFYING RESOURCE PROFILES
Please note that Oracle strongly discourages any modifications made to CRS
profiles for any resources starting with <ora>. Never make any modifications to
CRS profiles for <ora> resources but the ones explicitly described below in
this document.
To modify a profile attribute for a resource, the following steps must be
followed:
1.Generate the resource profile file by issuing the following command:
crs_stat -p resource_name > $CRS_HOME/crs/public/resource_name.cap
2.Update desired attributes by editing the file created in step 1.
3.Commit the updates made as a part of the previous step by issuing the
following command
crs_register -u resource_name
4. Verify the updates have been committed by issuing the following command
crs_stat -p resource_name
For each of the resources identified as a part of the preceding section, the
following modifications must be made:
1.Resources of type inst must have the following attributes modified
AUTO_START must be set to 2
RESTART_ATTEMPTS must be set to 0 or 1. The former value will prevent
CRS from attempting to restart a failed instance at all while the latter
will grant it a single attempt; if this only attempt is unsuccessful,
CRS will leave the instance as is.
2.Resources of type db, srv, cs must have the following attributes modified
AUTO_START must be set to 2
参考至:http://jingh3209.blog.163.com/blog/static/15696672008101612013898/
如有错误,欢迎指正
邮箱:czmcj@163.com
相关推荐
[oracle@node-rac1 admin]$ crs_start ora.node-rac1.LISTENER_NODE-RAC1.lsnr ``` 3. 查看资源属性 `crs_stat -p <resource_name>` 命令用于查看资源的详细属性,包括其依赖关系和其他配置信息。这有助于理解资源...
CRS (Cluster Ready Services) 是Oracle RAC的核心组件,负责集群资源的管理和监控。以下是一些关于Oracle RAC CRS的常用命令及其详解: 1. **crs_stat -t**: 这个命令用于查看集群中所有资源的状态。输出包括资源...
### ORACLE RAC重建CRS知识点详解 #### 一、背景与概述 Oracle Real Application Clusters (RAC) 是一种数据库集群技术,旨在提供高可用性和可扩展性。CRS (Cluster Ready Services) 是Oracle RAC的核心组件之一,...
### Oracle RAC CRS 常用管理命令详解 Oracle RAC (Real Application Clusters) 是 Oracle 数据库的一个组件,它提供了高可用性和可扩展性的解决方案。CRS (Cluster Ready Services) 是 Oracle RAC 的核心服务之一...
### CRS-2672: Attempting to start 'ora.ctssd' on 'rac2' - **ora.ctssd**:CTSSD(Cluster Time Synchronization Service Daemon)用于确保集群中所有节点的时间同步。 - **尝试启动**:此消息显示正在尝试在`...
Oracle RAC CRS、OCR、Voting 破坏重建 Oracle RAC 集群中,CRS(Clusterware)、OCR(Oracle Cluster Registry)和 Voting Disk 是三个关键组件。CRS 负责集群的管理和监控,OCR 负责存储集群的配置信息,而 ...
### Oracle RAC 中 CRS 清理指南 #### 概述 在进行 Oracle Real Application Clusters (RAC) 的部署过程中,有时会遇到安装失败的情况。这种情况可能会导致一系列问题,例如节点重启等。为了确保系统的稳定性和可...
Oracle RAC 集群下的 CRS 管理 Oracle RAC(Real Application Clusters)是一种高可用性、高性能的数据库解决方案,它可以将多个服务器聚合成一个集群,以提高数据库的可用性和性能。在 Oracle RAC 集群中,CRS...
### Oracle RAC 常用管理命令详解 Oracle Real Application Clusters (RAC) 是一个在多台服务器之间实现数据库高可用性和负载均衡的技术。为了有效地管理和监控Oracle RAC环境,掌握一系列常用的管理命令是非常重要...
为了保证RAC的高效运行,还需要配置3个1GB的共享磁盘asm-crs1/2/3以及3个10GB的共享磁盘asm-data1-3。另外,/etc/hosts文件配置了不同类型的IP地址,如public IP、private IP、VIP和scan IP。 在Oracle数据库中,...
### RAC 实例启动与关闭命令详解 #### 一、概述 在Oracle Real Application Clusters (RAC)环境中,为了确保高可用性和可扩展性,需要掌握一系列的启动与关闭命令来管理数据库集群中的各个组件。本文将详细介绍RAC...
### Oracle 11g RAC 关闭与启动顺序详解 #### 一、关闭顺序 在 Oracle 11g RAC 环境中,为了确保数据的安全性和系统的稳定性,在进行关闭操作时需遵循一定的顺序: 1. **关闭数据库** - 对于 Oracle 用户,可以...
RAC的核心组件之一是CRS(Cluster Ready Services),它负责管理和监控集群的各个组件。CRSCTL是用于控制CRS的主要命令行工具,而SRVCTL则用于管理RAC数据库的实例、监听器和服务。 **CRSCTL命令详解:** - **停止...
在Oracle Real Application Clusters (RAC)环境中,管理和维护数据库集群是一项复杂的工作。RAC设计为高可用性解决方案,允许数据库实例在多个节点之间共享数据,确保即使在单个节点故障时也能保持服务连续性。然而...
### RAC关闭与启动详解 #### 一、RAC简介 在深入了解RAC(Real Application Clusters)的关闭与启动之前,我们先简要介绍一下RAC的基本概念。Oracle Real Application Clusters (RAC) 是Oracle数据库的一个核心...
3. **创建安装目录**:在RAC的每台节点上,需要为Oracle软件、Grid Infrastructure和CRS (Cluster Resource Software) 创建目录,并分配合适的权限。例如,`/u01/app/11.2.0/grid` 和 `/u01/app/oracle` 分别用于...
根据提供的文件内容,以下是对RAC环境中常用的命令及其所检查状态的详细解释: ### 1. 检查集群状态 #### 命令:`crsctl check cluster` 此命令用于检查整个集群的状态,包括集群同步服务(Cluster ...
解决在WINDOWS 2003 R2上不能安装RAC的方法CRS 10.2.0.2 error on windows 2003
**知识点:Goldengate for CRS 注册服务** **1. Goldengate与Oracle RAC的高可用性结合** Goldengate是一种数据复制解决方案,能够实现实时的数据捕捉、转换和交付,广泛应用于异构环境下的数据同步场景。而Oracle...