1 / 15

RAC and Shared Storage

RAC and Shared Storage. Objectives. After completing this lesson, you should be able to understand: RAC and shared storage technologies Oracle Cluster File System Automatic Storage Management. RAC and Shared Storage Technologies. Storage is a critical component of grids:

chiko
Download Presentation

RAC and Shared Storage

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RAC and Shared Storage

  2. Objectives • After completing this lesson, you should be able to understand: • RAC and shared storage technologies • Oracle Cluster File System • Automatic Storage Management

  3. RAC and Shared Storage Technologies • Storage is a critical component of grids: • Fundamental sharing storage • New technology trends • Supported shared storage for Oracle grids: • Network Attached Storage • Storage Area Network • Supported file storage for Oracle grids: • Raw volumes • Cluster file system • ASM

  4. Oracle Cluster File System • Is a shared disk cluster file system for Linux and Windows • Improves management of data for RAC by eliminating the need to manage raw devices • Provides open solution on the operating system-side (Linux), free, and open source • Can be downloaded from OTN: • http://oss.oracle.com/projects/ocfs/ (Linux) • http://www.oracle.com/technology/software/products/database/oracle10g/index.html (Windows)

  5. Application Database Filesystem ASM Volumemanager Operating system Automatic Storage Management • Portable and high-performancecluster file system • Manages Oracle database files • Data spread across disksto balance load • Integrated mirroring acrossdisks • Solves many storage management challenges

  6. ASM: Key Features and Benefits • Stripes files rather than logical volumes • Online disk reconfiguration and dynamic rebalancing • Adjustable rebalancing speed • Provides redundancy on a file basis • Supports only Oracle database files • Database cluster file system with performance of RAW I/O usable on all storage platforms • Automatic database file management • No more hot spots: Eliminate manual I/O tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

  7. ASM: New Concepts ASMdisk group Database ASM file Data file Tablespace Segment ASM disk Extent File-system file orraw device Allocation unit Oracleblock Physicalblock

  8. GMON GMON ASM: General Architecture Node1 Node2 Group Servicestom=+ASM1 bob=+ASM1harry=+ASM1 Group Services tom=+ASM2 bob=+ASM2harry=+ASM2 DB instance SID=sales1 DB instance SID=sales2 DBW0 ASMB DBW0 ASMB ASM instance SID=+ASM1 ASM instance SID=+ASM2 RBAL FG FG RBAL FG FG ASMB ASMB RBAL RBAL DB instance SID=test1 DB instance SID=test2 DBW0 DBW0 ARB0 ARB0 … … RBAL RBAL ARBA ARBA ASM disks ASM disks ASM disks ASM disks ASM disks ASM disks ASM disk group Tom ASM disk group Bob ASM disk group Harry

  9. How Many ASM Disk Groups Per Database • Two Disk Groups are recommended • Leverage maximum of LUNs • Backups can be stored on oneFRA disk group • Lower performance may be used for FRA (or inner tracks) • Exceptions • Additional Disk Groups for different capacity or performance characteristics • Different ILM storage tiers Data DG FRA DG ERP DB CRM DB HR DB

  10. Database Storage Consolidation • Shared storage across several databases • RAC and single Instance can use the same ASM instance • Benefits: • Simplified and centralized management • Higher storage utilization • Higher performance GL Payroll & GL Payroll … … … 10 x 100 GB 10 x 50 GB 10 x 50 GB

  11. ASM: Administration Page

  12. ASM Scalability • ASM imposes the following limits: • 63 disk groups • 10,000 ASM disks • 4 petabyte per ASM disk • 40 exabyte of storage • 1 million files per disk group • Maximum file size: • External redundancy: 35 TB • Normal redundancy: 5.8 TB • High redundancy: 3.9 TB

  13. Possible Alternatives to ASM • Using CFS: • Simpler management • Use of OMF with RAC • Single Oracle software installation • Autoextend • Using raw: • Performance • Use when CFS not available • Cannot be used for ARCHIVELOG files (on UNIX)

  14. Demos • Install ASM in its own home directory in a RAC. http://www.oracle.com/technology/obe/demos/admin/demos.html

  15. Summary • In this lesson, you should have learned about: • RAC and shared storage technologies • Oracle Cluster File System • Automatic Storage Management

More Related