Simplify your Job ndash; Automatic Storage Management.ppt

Simplify your Job – Automatic Storage Management Angelo Storage Management Gap DBA Storage Challenges Databases are rapidly growing in size DBAs have to manage thousands of data files Decreasing windows of scheduled downtime Storage resources involve many organizations Database Admin Systems Admin Storage Admin Network Admin Management of database storage is increasing in complexity and cost Automatic Storage Management (ASM) Portable, high performance cluster file system Data is spread across disks to balance load Integrated mirroring across disks Removes need for third-party volume manager and file system ASM – How it Works No volumes: just a pool of storage ASM – How it Works No volumes: just a pool of storage Partitions total disk space into uniform sized megabyte units ASM – How it Works No volumes: just a pool of storage Partitions total disk space into uniform sized megabyte units Units assigned to a file are managed and tracked by ASM ASM – How it Works No volumes: just a pool of storage Partitions total disk space into uniform sized megabyte units Units assigned to a file are managed and tracked by ASM Online add/remove of disk with automatic rebalancing ASM – How it Works No volumes: just a pool of storage Partitions total disk space into uniform sized megabyte units Units assigned to a file are managed and tracked by ASM Online add/remove of disk with automatic rebalancing The Operational Stack Data Mirroring with ASM ASM can mirror data across storage arrays No additional logging or expensive NVRAM to recover mirrors Database logging recovers mirrors Designed to tolerate component failures Disk Groups Failure Groups Where DBAs Spend Their Time ASM Functions Drill Down Getting started Defining a DB Adding/deleting/migrating storage Hot spots Storage fragmentation Traditional vs ASM - Setup Determine required storage capacity Install Volume Manager, File System Architect data layout to avoid hot spot Create logical volumes Create file system