Sign in  |  Register
Advanced search
Publication Cover

CITATION

Vengurlekar, Nitin; Vallath, Murali; and Long, Rich. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide. US: McGraw-Hill Osborne Media, 2007.

Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide

Authors: Nitin Vengurlekar, Murali Vallath and Rich Long

Published:  November 2007

eISBN: 9780071595629 0071595627 | ISBN: 9780071496070
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • 1 Storage Stack Overview
  • Disk Drive Technology
  • Disk Drive Performance
  • Disk Interface
  • IDE/EIDE/ATA/PATA
  • SCSI (Parallel)
  • SATA
  • FC and FC-AL
  • SAS
  • Storage System Architectures
  • DAS
  • NAS
  • SAN
  • Channel, Networks, and Protocols
  • SAN Components
  • FC (Fabric) Switches
  • HBA
  • Storage Arrays
  • RAID and RAID Controllers
  • iSCSI
  • Software-iSCSI Initiators
  • TCP Offload Engine (TOE) NIC
  • iSCSI HBA
  • InfiniBand
  • Oracle and I/O Characteristics
  • Types of File to Access
  • I/O Access Patterns
  • I/O Request Calls
  • Basic Variables That Affect I/O Performance
  • Protecting the Storage Stack from Failures
  • Summary
  • 2 ASM Instances
  • Starting ASM
  • ASM Background Processes
  • ASM SGA and Parameter Sizing
  • ASM init.ora Parameters
  • Best Practices for ASM init.ora Parameters
  • ASM and Single Point of Failure
  • ASM Installation
  • Initializing an ASM Instance
  • Upgrading ASM Software
  • Upgrading the ASM Instance from 10.x to 11.x
  • Patching ASM
  • ASM and Security
  • One ASM Instance and Multiple UNIX Userids
  • ASM and Privileges
  • ASM and orapwd
  • ASM Management
  • Summary
  • 3 ASM Disks
  • ASM Storage Provisioning
  • ASM Storage Device Configuration
  • ASM Disk Device Discovery
  • Third-Party Volume Managers and ASM
  • ASM and Storage Arrays
  • Preparing ASM Disks on OS Platforms
  • Configuring ASM Disks on Solaris
  • Configuring ASM on AIX
  • ASM and Windows
  • asmtool
  • asmtoolg
  • ASM and Multipathing
  • Summary
  • 4 Diskgroups and Failure Groups
  • Diskgroup Management
  • Creating Diskgroups
  • ASM Disk Names
  • Diskgroup Numbers
  • Disk Numbers
  • ASM Redundancy and Failure Groups
  • Creating ASM Redundancy Diskgroups
  • Designing for ASM Redundancy Diskgroups
  • Allocating ASM Extent Sets
  • Disk Partnering
  • Recovering Failure Groups
  • ASM and Extended Clusters
  • ASM Preferred Read
  • Recovering from Transient and Permanent Disk Failures
  • Recovering from Disk Failures in Oracle Database 10g
  • Recovering from Disk Failures in Oracle Database 11g––Fast Disk Resync
  • I/O Error-Failure Management and ASM
  • Space Management Views for ASM Redundancy
  • Diskgroups and Attributes
  • ASM and Database Compatibility
  • Summary
  • 5 ASM Space Allocation and Rebalance
  • ASM Space Allocation
  • ASM Allocation Units
  • ASM Extents
  • ASM Striping
  • Setting Larger AU Sizes for VLDBs
  • ASM Rebalance
  • Rebalance Operation
  • Fast Rebalance
  • Effects of Imbalanced Disks
  • ASM and Storage Array Migration
  • ASM and OS Migration
  • Important Points on ASM Rebalance
  • Summary
  • 6 ASMLIB Concepts and Overview
  • Benefits of ASMLIB
  • Device Discovery
  • I/O Processing
  • Performance and Reliability
  • Oracle’s ASMLIB Implementation
  • Oracle ASMLIB Installation
  • Summary
  • 7 ASM Files, Aliases, and Templates
  • ASM Filenames
  • ASM Directories
  • ASM Aliases
  • Templates
  • Summary
  • 8 ASM Command-Line
  • Interactive and Noninteractive Modes
  • Connected and Nonconnected Modes
  • ASM Metadata Backup and Restore in ASMCMD
  • Backup Mode
  • Restore Mode
  • Backup and Recovery Example
  • Bad Block Remapping in ASMCMD
  • ASMCMD Copy
  • Summary
  • 9 Managing Databases in ASM
  • Database Interaction with ASM
  • Diskgroups and Databases
  • Interaction between ASM and Database
  • ASM Implementations
  • Using ASM on a Single Node
  • Using ASM on Multiple Nodes
  • Consolidating and Clustering Databases
  • Clustering ASM
  • Database init.ora Parameters to Support ASM
  • Migration to ASM
  • Converting Non-ASM Databases to ASM Using RMAN
  • Converting Non-ASM Datafiles to ASM Using RMAN
  • Moving Datafiles from One Diskgroup to Another
  • Converting ASM Files Using DBMS_FILE_TRANSFER
  • Transferring Non-ASM Datafiles to ASM Using FTP
  • Accessing an ASM Virtual Folder via FTP
  • Using EM to Simplify ASM Migration
  • ASM Performance Monitoring Using EM
  • ASM–Database Multiversion Support
  • Transportable Tablespaces and ASM
  • Performing the Preliminary Steps to Set Up TTS
  • Converting the Database
  • Summary
  • 10 ASM Persistent Data Structures
  • Physical Metadata
  • Disk Header
  • Allocation Table (AT)
  • Free Space Table (FST)
  • Partnership Status Table (PST)
  • Virtual Metadata
  • File Directory
  • Disk Directory
  • Active Change Directory (ACD)
  • Continuing Operations Directory (COD)
  • Template Directory
  • Alias Directory
  • Attributes Directory
  • Staleness Directory
  • Staleness Registry (SR)
  • Summary
  • 11 ASM Operations
  • ASM Instance Discovery
  • RDBMS Operations on ASM Files
  • File Create
  • File Open
  • File I/O
  • File Close
  • File Delete
  • ASM File Allocation
  • External Redundancy Diskgroups
  • Variable-Sized Extents
  • ASM Striping
  • ASM Redundancy
  • Failure Groups
  • Disk Partners
  • Allocation with ASM Redundancy
  • I/O to ASM Mirrored Files
  • Rebalance
  • Resync
  • Relocation
  • ASM Instance Recovery and Crash Recovery
  • Disk Discovery
  • Mount Diskgroup
  • Create Diskgroup
  • Add Disk
  • Online Disk
  • Select from V$ASM_DISK and V$ASM_DISKGROUP
  • Summary
  • 12 From Discussion to Deployment
  • Why System Administrators Freak Out over ASM
  • Why Vendors of Storage and Volume Managers Dislike ASM
  • ASM––What’s in It for the Business
  • Improves Storage Utilization
  • Lowers Storage Administration Cost
  • Improves Application Availability
  • Lowers Deployment Cost
  • What DBAs Need to Know before Talking to System Administrators about ASM
  • Peer Politics
  • Summary
  • A: ASM and Storage Array Configurations
  • Best Practices for EMC Clariion and ASM
  • Best Practices for HP StorageWorks EVA 8000 and ASM
  • Configuring ASM with EMC DMX-3
  • Configuring the Initial ASM Diskgroup with CVM/VxVM
  • ASM and NetApp NAS
  • General Recommendations
  • B: Troubleshooting ASM
  • ASM Startup Issues
  • Diskgroup Cannot be Mounted
  • Disk Space–Related Issues
  • A Walkthrough of an ASM Alert Log
  • C: Scripts and Tips
  • Leveraging Unix Files as ASM
  • Automatically Starting Up and Shutting Down ASM Instances in Non-RAC Environments
  • Migrating Individual Non-ASM Datafiles to ASM
  • Creating DataPump Filesets and ASM
  • Creating Extra Controlfiles in ASM
  • Using ASM SQL Scripts
  • Reporting Disk Imbalances
  • The Script
  • The Sample Script Output
  • Reporting ASM iostat Information––asmiostat.sh
  • The Sample Script
  • The Sample Script Output
  • D: Typical ASM Diskgroup Commands
  • Mount a Diskgroup
  • Dismount a Diskgroup
  • Add ASM Disks to the Diskgroup
  • Drop ASM Disks from the Diskgroup
  • Check Diskgroup Consistency
  • Modify the Rebalance Power Level
  • Drop a Diskgroup
  • E: References
  • Index