Using Oracle Database 10g Automatic Storage Management with FUJI...

preview
试读
27页
Oracle、ASM
需积分: 0 2 下载量 21 浏览量 更新于2011-07-11 收藏 453KB PDF 举报
在IT领域，尤其是在数据库管理与存储系统集成方面，Oracle Database 10g的Automatic Storage Management (ASM)与FUJITSU Storage的结合提供了一个高效且可靠的数据管理解决方案。本篇内容将深入探讨这一主题，从Oracle ASM的功能特性到FUJITSU Storage系统的独特优势，再到最佳实践策略，为读者呈现一个全面的技术概览。 ### Oracle Database 10g Automatic Storage Management (ASM) Oracle Database 10g中的Automatic Storage Management（ASM）是一项创新功能，旨在简化数据库系统及存储环境的管理。它本质上是集成了集群文件系统和逻辑卷管理器的组合体，紧密嵌入Oracle 10g数据库内部。ASM针对Oracle数据库文件特别设计，作为标准功能包含在Oracle Database 10g中，无需额外成本。 #### ASM架构 ASM通过虚拟化存储硬件，自动化数据分布和I/O负载均衡，显著提高了数据库操作效率。其架构支持动态重构磁盘组，允许在不中断服务的情况下调整存储配置。此外，ASM还提供镜像和恢复功能，确保了数据的高可用性和快速恢复能力。 ### FUJITSU Storage Systems FUJITSU的ETERNUS存储系统以其高可用性、性能调优能力和点对点复制功能而著称，这些特性使其成为与Oracle ASM配合使用的理想选择。 #### 高可用性 FUJITSU的ETERNUS系统通过冗余设计和故障切换机制，确保了系统的持续运行，即使在部分组件发生故障时也能保持数据的完整性和业务连续性。 #### 性能调优 针对不同应用需求，FUJITSU的ETERNUS提供了精细的性能调优选项，包括智能缓存管理和优化的I/O路径，从而提高了数据访问速度，增强了整体系统响应能力。 #### 点对点复制功能 ETERNUS的点对点复制技术确保了数据在多个存储设备间的一致性，对于实现数据备份和灾难恢复策略至关重要。 ### 最佳实践 结合Oracle ASM与FUJITSU ETERNUS存储系统的最佳实践涉及多方面，旨在实现高可靠性、高性能和有效的资源管理： #### 高可靠性和高可用性 通过ASM的镜像和冗余策略，结合ETERNUS系统的高可用性设计，可以构建出能够承受硬件故障的存储解决方案，保障关键业务的连续运行。 #### 数据库加速 利用ASM的I/O分布和动态重构功能，结合ETERNUS的性能调优技术，可显著提高数据库处理速度，满足高强度工作负载的需求。 #### 系统关系管理和故障监控 实施细致的监控策略，及时发现并响应潜在问题，是维护系统稳定性的关键。这包括定期检查ASM磁盘组状态和ETERNUS存储系统的健康状况。 #### ASM磁盘组配置指南 合理规划ASM磁盘组的配置，如选择合适的冗余级别和磁盘类型，对于优化存储性能和容错能力至关重要。 ### 结论 Oracle Database 10g的ASM与FUJITSU ETERNUS存储系统的整合，不仅简化了存储管理，还显著提升了数据库系统的性能和可靠性。通过遵循上述最佳实践，企业可以构建出一个既高效又稳健的数据管理平台，以应对不断增长的数据量和复杂的应用场景。
Best Practices White Paper
Sep 6, 2005
Fujitsu Limited
Using Oracle Database 10g
Automatic Storage Management with FUJITSU Storage
[Best Practices] Using Oracle Database 10g Automatic Storage Management with FUJITSU Storage
All Rights Reserved Copyright © FUJITSU LIMITED 2005
Contents
1. Introduction............................................................................................................................... 1
2. Fujitsu’s ETERNUS Storage Systems ..................................................................................... 2
2-1. High Availability.................................................................................................................................................. 2
2-2. Performance Tuning........................................................................................................................................... 2
2-3. Point-in-time copy feature.................................................................................................................................. 2
3. Fujitsu Storage Management software.................................................................................... 2
3-1. Fujitsu Storage Cruiser ...................................................................................................................................... 2
3-2. Fujitsu AdvancedCopy Manager........................................................................................................................ 3
4. Oracle Technologies................................................................................................................. 3
4-1. Automatic Storage Management........................................................................................................................ 3
4-2. ASM Architecture ............................................................................................................................................... 3
4-3. I/O Distribution ................................................................................................................................................... 3
4-4. Dynamic Reconfiguration of a disk group.......................................................................................................... 4
4-5. Rebalancing ....................................................................................................................................................... 4
4-6. ASM Mirroring .................................................................................................................................................... 4
4-7. ASM Recovery ................................................................................................................................................... 4
5. Best Practices ........................................................................................................................... 4
5-1. High Reliability and High Availability.................................................................................................................. 4
5-2. Database Acceleration....................................................................................................................................... 4
5-3. System Relation Management and Failure Monitoring...................................................................................... 5
5-4. ASM Disk Group Configuration Guideline.......................................................................................................... 5
6. Conclusion ................................................................................................................................ 6
7. Appendix.................................................................................................................................... 7
7-1. Cluster System by the Combination of Oracle RAC and PRIMECLUSTER...................................................... 7
7-2. Database Space Management by Fujitsu Storage Manager ............................................................................. 8
7-3. Backup/Recovery Procedure Methods and Usage Example............................................................................. 9
7-4. Additional Technical References...................................................................................................................... 24
[Best Practices] Using Oracle Database 10g Automatic Storage Management with FUJITSU Storage
All Rights Reserved Copyright © FUJITSU LIMITED 2005
1
1. Introduction
This document describes the most efficient database environment that provides the combined benefits and
advantages of the new Oracle Database 10g feature, Automatic Storage Management (ASM), and Fujitsu
ETERNUS storage systems.
Automatic Storage Management is a new feature in Oracle Database 10g that provides data management
features within the database that simplifies the management of database systems and storage environments.
ASM is the combination of a clustered file system and logical volume manager that is tightly integrated and
embedded within the Oracle database 10g. ASM was specifically designed to operate with Oracle database
files. ASM is a standard Oracle Database 10g feature that is included at no additional cost with the database
system. ASM is designed to optimize the operation of Oracle databases and simplify storage management by
virtualizing storage hardware, automating tasks and optimizing performance thereby reducing operational
overhead, administrator intervention – and human error – and overall management costs.
ASM is Oracle’s collection of intelligence and best practices learned over many years. The ASM disk group
virtualization interface allows DBAs to easily and dynamically add or remove disks for a particular disk group
without interrupting the database operation. ASM will automatically begin to use a new disk as soon as it is
added to the disk group, and will automatically rebalance data between old and new disks to continually
optimize I/O performance. ASM also eliminates disk fragmentation and hotspots thereby reducing
management overhead.
ASM provides up to 3-way mirroring for higher availability and is an alternative to mirroring provided by the
hardware RAID in storage arrays. The Oracle DBA simply defines a failure groups within a disk group and
ASM will automatically mirror the data across two or more failure groups, which can help to avoid downtime in
the event of component failures, such as a disk controller or even entire disk array. This powerful redundancy
feature increases availability without any additional management overhead. Since failure groups are
automatically managed by ASM fail over or fail back activities are fully managed without the intervention of an
operator by ASM when the failed component is replaced.
Fujitsu’s ETERNUS is the storage systems that meet the requirements in mission-critical-environment.
ETERNUS6000 is highly scalable, large capacity disk array, and ETERNUS3000 is mid range disk array. In
any model, all major components are redundantly equipped and are hot-swappable to ensure business
continuity with high reliability and high availability. ETERNUS storage systems provide an online
volume-replication feature that enables non-disruptive database backup operation.
This white paper describes the most efficient method to configure a high-performance, high-availability Oracle
database environment by the combination of ASM and ETERNUS.
[Best Practices] Using Oracle Database 10g Automatic Storage Management with FUJITSU Storage
All Rights Reserved Copyright © FUJITSU LIMITED 2005
2
2. Fujitsu’s ETERNUS Storage Systems
2-1. High Availability
Fujitsu ETERNUS storage system provides high availability that guarantees secure operation in mission critical
environments.
All major components are redundantly equipped. In the event of a component failure, ETERNUS automatically
reallocates the rest of active components for non-disruptive operation. Plus, all major components are
hot-swappable.
Disk drives are configured in RAID groups. In the event of a disk-drive failure, the data is quickly rebuilt in a
hot-spare disk to maintain the data redundancy. Plus, ETERNUS storage system constantly monitors each disk
drive for pre-failure detection. If one of the disk drives is likely to fail, ETERNUS proactively copies the data to
the hot-spare disk. This enables disk-drive exchange while maintaining the data redundancy.
The interfaces between servers and ETERNUS storage systems also deliver a high available mechanism. This
mechanism is provided by ETERNUS Multipath Driver or GR Multipath Driver that manages multiple Fibre
Channel paths. Even if one path fails, operations of a database and other applications can continue by
automatically rerouting data through the rest of active paths. Such a highly available mechanism guarantees
continuous operations even in the event of a server-side HBA failure or switch failure.
2-2. Performance Tuning
Fujitsu ETERNUS storage system provides features to exchange drives or to change RAID configurations
without disrupting accesses to the volumes. With these features, it is possible to optimize access performance
without stopping operations.
RAID Migration provides two features to reorganize disk drives. One is a feature to include the currently-used
RAID drives into the destination RAID group. This feature is useful when reconfiguring the same-specification
drives into a different RAID-level group. The other feature is useful when moving the data from the source
RAID drives to a different type of target RAID drives, for example, from a 10,000rpm-drive RAID group to
a15,000rpm-drive RAID group. Both features can be used without quitting accesses to the RAID group, and
the switching from the source to destination is automatically performed by ETERNUS.
2-3. Point-in-time copy feature
Fujitsu ETERNUS storage system provides a point-in-time copy feature that creates a copy of the source
volume data at a certain point in time within the storage system without stopping the operations of a database
or other applications.
System requirement for 24 x 365 continuous operation is growing. System administrators must make backups
without disrupting business operations, such as database operation, and without putting heavy loads on the
servers. ETERNUS provides two types of replication features: Equivalent Copy (EC) and One Point Copy
(OPC). With EC, the source and target volumes are previously synchronized and split when the replicated
volume is required. With OPC, a copy volume can be instantly created on demand. Both of these features can
be used according to business requirements.
3. Fujitsu Storage Management software
3-1. Fujitsu Storage Cruiser
Fujitsu Storage Cruiser offers the advanced storage resource management features based on the SAN
(Storage Area Network) management features. With versatile management features for configuration,
troubleshooting, performance and correlation, Fujitsu Storage Cruiser provides stable operation for any type of
storage system, including SAN, DAS (Direct Attached Storage) and NAS (Network Attached Storage).
[Best Practices] Using Oracle Database 10g Automatic Storage Management with FUJITSU Storage
All Rights Reserved Copyright © FUJITSU LIMITED 2005
3
In SAN environments, the management of only physical connection topologies is not enough. Without the
management of logical connection topologies, it is impossible to exactly understand the impact of a
device/component failure. Fujitsu Storage Cruiser not only graphically displays logical connections, but also
quickly reflects reconfigurations or component failures on the display. This enables a quick action in the event
of a system failure.
3-2. Fujitsu AdvancedCopy Manager
Fujitsu offers Fujitsu AdvancedCopy Manager, an application to control the Equivalent Copy and One Point
Copy features of ETERNUS. With Fujitsu AdvancedCopy Manager, it is possible to manage replicated spaces,
and to non-disruptively create a consistent database copy synchronizing with the original database operation.
4. Oracle Technologies
4-1. Automatic Storage Management
ASM enables a disk group to be designated as storage for Oracle database files, control files and backup files.
A disk group consists of multiple disk drives and is managed as a unit by ASM. Any file stored in a disk group is
automatically striped over all the disk drives in the group. ASM provides clustering capabilities and is available
not only for single SMP machine but across multiple nodes of Oracle Real Application Clusters. In order to
generate maximum performance, ASM automatically and dynamically distributes I/O loads among all the disk
drives, even if data usage pattern is rapidly changing. It prevents fragmentation of space so there is no need to
relocate data for shortage of space. By selecting the desired reliability and performance level of operation,
ASM sets the management characteristics for each file, and does not require operator’s interaction on every
file.
4-2. ASM Architecture
ASM feature is performed by ‘ASM instance’ that is different from ‘DB instance’. ASM instance manages data
mapping information in a disk group by using metadata describing the layout of ASM files.
DB instance performs actual access to data files by using the data mapping information from the ASM instance.
4-3. I/O Distribution
A file (an ASM file) created on a disk group is divided evenly and stored among all the disk drives in the disk
group. This prevents I/O concentration on a single disk drive. There are two stripe widths: COARSE and FINE.
The default for control file and redo log file is FINE and for others it is COARSE.
ASM
instance
DB
instance
Data
mapping
information is
provided
Data access
Meta and data management

剩余26页未读，继续阅读

资源推荐
资源评论
xucjack
  • 粉丝: 0
  • 资源: 4
上传资源 快速赚钱
voice
center-task 前往需求广场，查看用户热搜

最新资源