Oracle ASM and Multi-Pathing Technologies
Doc ID: Note:294869.1
This document will briefly discuss Multipath I/O and how Oracle Automatic Storage Management leverages multi-pathing.
An I/O path generally consists of an initiator port, fabric port, target port, and LUN. Each permutation of this I/O path is considered an independent path. Dynamic Multi-pathing/failover tools aggregate these independent paths into a single logical path. This path virtualization provides I/O load-balancing across the HBAs, as well as non-disruptive failover on HBA failures. Multi-pathing software requires all the required disks to be visible on each available and eligible HBA. These multi-paths will be detected by probing the World Wide Device Identifiers (WWD ID).
Multi-pathing software also provides multi-path software drivers. Most multi-pathing drivers are SCSA compliant pseudo nexus drivers, that support multipath services for fibre channel attached SCSI-3 devices. These drivers receive naming and transport services from one or more physical HBA devices. To support multi-pathing, a physical HBA driver must comply with the multi-pathing services provided by this driver.
Multipaths provides the following benefits:
-
Provide a single block device interface for a multi-pathed LUN
-
Detect any component failures in the I/O path; e.g., fabric port, channel adapter, or HBA.
-
When a loss of path occurs, ensure that I/Os are re-routed to the available paths, with no process disruption.
-
Reconfigure the multipaths automatically when events occur.
-
Ensure that failed paths get revalidated as soon as possible.
-
Provide auto-failback capabilities.
-
Configure the multipaths to maximize performance using various load balancing methods; e.g., round-robin, least I/Os queued, or least service time.
Examples of multi-pathing software include EMC PowerPath, Sun Traffic Manager and IBM MPIO.
Although most of these tools are storage array agnostic, some require additional software components and drivers specific for the storage
Note, Oracle Corporation does not certify or qualify these tools. Oracle10g includes a new feature called Automatic Storage Management (ASM). ASM provides filesystem and volume manager capabilities built into the Oracle database kernel. With this capability, ASM simplifies storage management tasks, such as creating/laying out databases and disk management. Although ASM does not provide multi-pathing capabilities, ASM does leverage multi-pathing tools, as long the path or device produces a successful return code from an fstat system call.
The table below describes the attributes of the utilities and how it can be used by ASM.
Multi-pathing tool
ASM Device Usage
Notes
1)AIX 系统
多路径软件EMC PowerPath
Use raw partitions thru
As of this writing, SDD-AIX is known to cause discovery and device handling problems for ASM, and thus is not viable solution.
See SDDPCM section below for an alternative solution to SDD for AIX
Use /dev/rhdiskx device
You m ust install SDDPCM filesets and enable SDDPCM.. SDDPCM cannot co-exist w/ SDD.
Use /dev/rdsk/cxtydz that’s generated by HDLM
HDLM generates a scsi (cxtydzx) address where the controller is highest unused controller number.
Use /dev/rhdisk device
2)HP 系统
多路径软件EMC PowerPath
ASM can use the raw partitions. Must use native device path:
ASM can use the raw partitions.
Use /dev/rdsk/cHtydz that’s generated by HDLM
HDLM generates a scsi address like cHtydz.
ASM can use the pseudo device.
The pseudo device will have the Global Unique Identifier included its name.
3)Sun 系统
多路径软件PowerPath
ASM will use raw partitions, associated with the pseudo device:
多路径软件Sun Traffic Manager
ASM can use the pseudo device.
The pseudo device will have the Global Unique Identifier included its name.
Use /dev/rdsk/cxtydz that’s generated by HDLM
HDLM generates a scsi (cxtydzx) address where the controller is highest unused controller number.
Use /dev/FJSVmplb/[r]dsk/mplbI*1s{0-7}. *1 "I" is MPLB Instance number
4)Linux 系统
多路径软件IBM-SDD
ASM can use the raw device associated with the Vpath.
You must use SDD-Linux driver 1.6.05+ . Goto IBM SDD site to get latest driver
DS6000
Enterprise Storage Server (ESS)
SAN Volume Controller (SVC)
ASM can use raw partitions associated with the /dev/emcpowerx device.
Associate the raw devices with the PP device.
ASM should use raw devices associated with /dev/spx
Currently SecurePath is only available on x86 and Itanium, all other 64bit platforms are not supported
ASM can use raw device associated with /dev/mdx device.
Though not a real multipath solution, it does provide rudimentary active/passive support
ASM can use the name generated by DM:
Avail in 2.6 kernel. Refer to following note for specifics
Use /dev/rdsk/cxtydz that’s generated by HDLM
HDLM generates a scsi (cxtydzx) address where the controller is highest unused controller number.
Associate raw device to /dev/FJSVmplb/[r]dsk/mplbI*1s{0-7}
相关推荐
这些工具大多与存储阵列无关,但有些可能需要额外的软件支持,以实现特定的硬件兼容性和功能。 在Oracle ASM中,多路径软件的作用尤为重要,因为它能够确保即使在硬件故障的情况下,数据库的I/O操作也能正常进行,...
- **选择兼容性**:根据VMware版本选择与之兼容的操作系统,确保虚拟机能够顺利运行。 - **选择安装来源**:提供安装介质的来源,比如ISO文件路径。rhel-server-7.6-x86_64-dvd.iso是安装Linux 7.6所需的安装盘镜像...
总的来说,Oracle ASM 视图提供了全面的 ASM 系统监控和管理能力,帮助 DBAs 跟踪资源使用情况、诊断问题、优化性能,并确保数据的可靠性和安全性。理解和有效利用这些视图是高效管理 Oracle ASM 实例的关键。
通常推荐使用稳定版本的Linux发行版作为主机操作系统,如CentOS 4.6或更高版本,以提供良好的兼容性和稳定性支持。 ##### 1.2 客户操作系统环境概况 客户操作系统指的是实际部署Oracle RAC的虚拟机操作系统。文档中...
### ORACLE ASM 学习知识点概述 #### 一、ASM简介 自动存储管理(Automatic Storage Management,简称ASM)是Oracle数据库提供的一种高级文件系统管理工具,它为Oracle数据库提供了高效、可靠的存储解决方案。通过...
5. 路径管理兼容性:VPLEX支持多种路径管理软件,包括EMC PowerPath、Symantec/Veritas DMP和Oracle ASM等。 6. 卷管理器兼容性:VPLEX支持多种卷管理器,包括EMC PowerPath、Symantec/Veritas DMP和Oracle ASM等。...
总的来说,Oracle ASMLib在Oracle RAC环境中扮演着至关重要的角色,它提供了高效、稳定且易于管理的共享存储解决方案,对于确保高可用性和数据一致性至关重要。这个工具包的安装和配置是搭建和维护Oracle RAC集群的...
- **COMPAT.ASM**:兼容性版本号。 - **REDAUNDANCY**:磁盘组的冗余级别。 - **DISK_COUNT**:磁盘组中磁盘的数量。 - **TOTAL_MB**:磁盘组的总大小。 - **FREE_MB**:磁盘组中的可用空间。 - **FAILGROUP_COUNT**...
- **硬件兼容性**:检查硬件是否支持ASM所需的特性,如热插拔磁盘等。 #### 管理ASM的行政影响 实施ASM后,将会对日常管理和运维带来以下影响: - **监控与报警**:需要定期监控ASM的状态,设置适当的报警机制。 ...
4. **故障转移和冗余**:ASMLIB支持多个磁盘,并且可以自动检测和处理磁盘故障,确保数据的安全性和高可用性。 现在我们来看一下压缩包中包含的文件: 1. **oracleasm-support-2.1.8-1.el5.x86_64.rpm**:这是...
在IT领域,特别是Oracle数据库管理中,RHEL6.X(Red Hat Enterprise Linux 6.x)是一个常见的操作系统平台,用于搭建高可用性和高性能的企业级数据库系统。在这个场景中,ASMlib(Oracle ASM Library)是一个关键...
《Linux7.6+Oracle 11g+RAC+multipath...通过这个教程,读者不仅可以了解和掌握Linux7.6、Oracle11g、RAC和多路径的相关知识,还能获得实际操作的经验,为构建和管理高性能、高可用性的企业级数据库环境打下坚实基础。
ASM是Oracle数据库系统中的一种集成存储管理解决方案,它提供了高性能、高可用性和高可扩展性的数据存储服务。在Linux环境中,Oracle ASMLib能够帮助管理员更高效地管理和操作ASM磁盘。 Oracle ASMLib 2.0.4-1.el4....
Oracle RAC是Oracle提供的用于在多个节点上运行同一数据库实例的技术,能够提高数据库的可用性和伸缩性。本文档针对Oracle 11g R2版本在Linux上的安装与配置进行了详尽的阐述。下面是对文档中知识点的详细解释: 1....
ojdbc的不同版本对应于Oracle数据库的不同版本,确保了兼容性和最佳性能。 - ojdbc5适用于Java 5和Oracle 10g/11g,ojdbc6对应Java 6和Oracle 11g/12c,ojdbc7适用于Java 7和Oracle 11g/12c,ojdbc8则匹配Java 8及...
6. **全球化和多语言支持**:驱动程序内置了对多种语言和字符集的支持,适应全球化应用的需求。 7. **性能优化**:包括结果集缓存、批量操作、预编译语句等,以提高数据访问速度和降低网络开销。 8. **安全特性**...
15.2.2多路径软件 15.2.3双网卡绑定 15.2.4合理分配SGA大小 15.2.5提高内存的访问效率 15.3 RAC Database 15.3.1 Oracle版本 15.3.2数据表空间的调整 15.3.3 DML语句性能调整 15.3.4临时表空间的调整 15.3....
在RHEL 5.1环境下,要注意的是,由于这是较老的操作系统版本,可能需要额外考虑兼容性和安全更新问题。同时,Oracle官方的支持可能会随着版本的过时而逐渐减少,因此在生产环境中建议使用最新或长期支持的RHEL版本。...
Oracle 9i Client是...总之,Oracle 9i Client是连接Oracle数据库的重要工具,其安装和配置涉及到网络设置、数据库连接以及版本兼容性等多个方面。了解和掌握这些知识点,对于管理和维护基于Oracle的系统至关重要。