ASM single point of failureUsers are often asked about best practices for avoiding ASM spof. As with other file systems or volume managers, failure of the ASM instance will cause the RDBMS instance running on to become unavailable. However, failure of the OS file system or volume manager usually results in a crash of the operating system, while the asm does not need to restart the server. The best solution to ASM spof is to run ASM in the RAC environment to achieve high availability through clusters. ASM can continue to run on another node if one node is restarted or rdbms is restarted. ASM failure means that the soft crash recovery speed is faster than the traditional file system or volume manager.
Install ASMIf an ASM instance on a server or node manages only one RDBMS, it is recommended that ASM and RDBMS share an ORACLE_HOME. However, we recommend that you install ASM in an independent ORACLE_HOME (ASM_HOME) when managing the storage of several RDBMS instances.
| Note: from the perspective of the development of ORACLE, even if ASM only corresponds to a set of RDBMS, it is recommended that ORACLE_HOME be separated, and 11g separate ASM into gi. Therefore, it is recommended that the data be separated for easy maintenance, in our production environment, I run 10205 RDBMS ON THE 10204 ASM that is independently stored. In this way, the repair function of kfed can be used. |
Note: In the RAC environment, if an independent ASM_HOME is implemented while adding nodes, the addnode operation also needs to run on ASM_HOME. Since Oracle Database 10 gRelease 2, Oracle Universal Installer (OUI-DBCA) and DBCA have been enhanced to create an ASM instance OUI-DBCA in a standalone ORACLE_HOME. you can install the following features: 1. you can configure the database to use ASM to manage storage 2. you can create an ASM instance without creating a database. the database is already running on the host where ASM is located. DBA can use the EM migration tool to move the database to ASM.
Initialize the ORACLE 10 Gb for the ASM instanceStart $ ORACLE_HOME/bin/dbca to configure the ASM instance. Note: The process of configuring the ASM instance is not described in detail here. See original book P50
Upgrade ASM SoftwareYou can upgrade the ASM instance from. x to. x by using either manual or DBUA. No matter which method is used to upgrade ORACLE_HOME of 11g, you must create it. Note that the upgrade is only a simple software upgrade. the upgrade of the disk group requires all 11 GB features. The upgrade of the disk group can be processed later.
Manual upgrade1. Use the ASM ORACLE_HOME directory to update oratab2. copy init. ora and make appropriate modifications, such as diag and dump. In the RAC environment, you need to modify the asm home configuration in the cluster. You can use the srvctl command to complete the Configuration: srvctl modify asm-n racnode1-I + ASM1-o \/opt/oracle/app/product/11.1/asm-p init + ASM1.ora must be executed on all cluster nodes involved in asm this command. 3. Grant SYSASM permissions to SYSUSER after the instance is started. 4. Use ORADIM to recreate WINDOWS Services for Windows. Note: The above steps are the steps for upgrading ASM to 11g. The 10g upgrade is actually very simple. You can upgrade the software.
DBUA upgradeYou can use DBUA to upgrade ASM to 11 GB. DBUA performs the following steps: 1. copy the password file in the new ASM_HOME and recreate init. on ora/spfile2.Unix/Linux, modify oratab or use ORADIM on windows to recreate the service. 3. grant SYSASM permission to SYSUSER to start DBUA from 11gORACLE_HOME. Note: If the installation of ASM separates ORACLE_HOME (ASM_HOME), you need to start DBUA under ASM_HOME/bin/instead of the database ORACLE_HOME. Note: For the steps to upgrade the image of dbua, refer to P56.
Patching ASMThe 10g asm does not support 'rolling Update'. The 'rolling upgrade patchs feature only supports ORACLE cluster parts and replica uard segments. In oracle database 10 Gb, if you want to install a patch set or "nonrolling upgrade safe" patches, the ASM instances in all clusters must be stopped. In addition, if you use the isolated ASM_HOME, ASM should be patched in the same way as RDBMSHOME. This also includes CPUs (critical patch updates ). This section describes how to perform an asm rolling upgrade from 11 GB.
