Sign in  |  Register
Advanced search
Publication Cover

CITATION

Vengurlekar, Nitin and Bagal, Prasad. Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management. US: McGraw-Hill Osborne Media, 2013.

Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management

Authors: Nitin Vengurlekar and Prasad Bagal

Published:  July 2013

eISBN: 9780071790161 0071790160 | ISBN: 9780071790154
Open eBook
  • Cover
  • Title Page
  • Copyright Page
  • About the Authors
  • About the Technical Editor
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • Chapter 1: Automatic Storage Management in a Cloud World
  • The Early Years
  • First Release of ASM and Beyond
  • The Cloud Changes Everything
  • What Is the Cloud?
  • Relational Databases in the Cloud
  • ASM in the Cloud
  • Common Storage Management
  • Enterprise Cloud Robustness
  • Enterprise Cloud Policy Management
  • Cross-Cluster Sharing
  • Summary
  • Chapter 2: ASM and Grid Infrastructure Stack
  • Clusterware Primer
  • OCR Overview
  • Voting File Overview
  • Grid Infrastructure Stack Overview
  • Grid Infrastructure for Standalone Server
  • Grid Infrastructure for Cluster
  • Voting Files and Oracle Cluster Repository Files in ASM
  • Voting Files in ASM
  • Voting File Discovery
  • Voting File Recovery
  • Oracle Cluster Registry (OCR)
  • OCR Recovery
  • The Quorum Failure Group
  • Clusterware Startup Sequence—Bootstrap If OCR Is Located in ASM
  • Disk Groups and Clusterware Integration
  • Summary
  • Chapter 3: ASM Instances
  • Managing ASM Instance
  • Starting Up an ASM Instance
  • Stopping the ASM Instance
  • Authentication for Accessing ASM Instances
  • ASM and ASM SPFILE
  • Managing the ASM SPFILE
  • ASM Background Processes
  • ASM SGA and Parameter Sizing
  • ASM Health Check Monitor
  • Summary
  • Chapter 4: ASM Disks and Disk Groups
  • ASM Storage Provisioning
  • ASM Storage Device Configuration
  • ASM Disk Device Discovery
  • Third-Party Volume Managers and ASM
  • Preparing ASM Disks on NFS
  • Direct NFS
  • Preparing ASM Disks on OS Platforms
  • Linux
  • Solaris
  • AIX
  • ASM and Multipathing
  • Linux Device Mapper
  • Disk Group
  • Disk Group Management
  • ASM Redundancy and Failure Groups
  • ASM and Intelligent Data Placement
  • ASM and Extended Clusters
  • Recovering from Transient and Permanent Disk Failures
  • ASM and I/O Error Failure Management
  • Space Management Views for ASM Redundancy
  • Disk Groups and Attributes
  • Attributes Overview
  • Summary
  • Chapter 5: Managing Databases in ASM
  • Interaction Between ASM and Database
  • Cloning ASM and Database Homes
  • Create Database in Command-Line Mode
  • Database Interaction with ASM
  • Disk Groups and Databases
  • Transportable Tablespaces and ASM
  • Performing the Preliminary Steps to Set Up the TTSs
  • Alert Log Monitoring
  • Monitoring the ASM Disk Group
  • Issues DBAs Encounter with ASM
  • Spfile with an Incorrect Initialization Parameter
  • Archiver Is Stuck
  • Moving the Control Files to ASM
  • Use Cases for DBAs
  • Impact of DB_UNIQUE_NAME for the ASM Directory Structure
  • Backing Up the Database to the FRA Disk Group
  • Specifying Default Locations for Data Files and Redo Logs
  • Copying Files from One ASM Instance to Another
  • How to Migrate from File System to ASM with Minimal Downtime
  • How to Move a Tablespace from One Disk Group to Another
  • Create Multiplexed Redo Logs
  • Summary
  • Chapter 6: ASMLIB Concepts and Overview
  • Benefits of ASMLIB
  • Device Discovery
  • I/O Processing
  • ASMLIB Implementation
  • ASMLIB Installation
  • Setting Up and Configuring ASMLIB
  • Managing Disks in ASMLIB
  • Troubleshooting ASMLIB
  • Summary
  • Chapter 7: ASM Files, Aliases, and Security
  • ASM Filenames
  • ASM Directories
  • ASM Aliases
  • Templates
  • V$ASM_TEMPLATE
  • ASM File Access Control
  • ASM ACL Overview
  • ASM ACL Setup Example
  • Summary
  • Chapter 8: 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
  • Chapter 9: 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 Disk Groups
  • 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 Disk Group
  • Create Disk Group
  • Add Disk
  • Online Disk
  • Select from V$ASM_DISK and V$ASM_DISKGROUP
  • Summary
  • Chapter 10: ACFS Design and Deployment
  • ASM Cluster File System Overview
  • ACFS File System Design
  • ACFS File I/O
  • ACFS Space Allocation
  • Distributed Lock Manager (DLM)
  • Metadata Buffer Cache
  • Recovery
  • ADVM Design
  • ACFS Configuration and Deployment
  • Configuring the Environment for ACFS
  • ACFS Deployment
  • CRS Managed ACFS File Systems
  • Managing ACFS and ADVM
  • ACFS File System Resize
  • Unmounting File Systems
  • Deleting File Systems
  • ADVM Management
  • ACFS Management
  • Summary
  • Chapter 11: ACFS Data Services
  • ACFS Snapshots
  • ACFS Read-Only Snapshots
  • ACFS Read-Write Snapshots
  • ACFS Snapshot by Example
  • ACFS Tagging
  • ACFS Replication Overview
  • Primary File System
  • Current Restrictions (11.2.0.3)
  • Standby File System
  • Planning for ACFS Replication
  • Tagging Considerations
  • Setting Up Replication
  • Replication Configuration and Initiation
  • Pause and Resume Replication
  • Sizing ACFS File Systems
  • ACFS Compare Command
  • Termination of Replication
  • ACFS Security and Encryption
  • Databases and Security
  • ACFS Security
  • Databases and Encryption
  • ACFS and File Encryption
  • ACFS Encryption Key Management
  • ACFS Encryption Configuration and Use
  • ACFS Snapshots, Security, and Encryption
  • ACFS Security and Encryption Implementation
  • Summary
  • Chapter 12: ASM Optimizations in Oracle Engineered Solutions
  • Overview of Exadata
  • Exadata Components
  • 11gR2 Database Optimizations for Exadata
  • ASM Optimizations for Exadata
  • ODA Overview
  • ODA Components
  • ASM Optimizations for ODA
  • ODA and NFS
  • Summary
  • Chapter 13: ASM Tools and Utilities
  • ASMCA
  • ASMCMD
  • Renamedg
  • ASM Storage Reclamation Utility (ASRU)
  • Overview of ASRU Operation
  • When to Use ASRU to Reclaim Storage
  • Using ASRU to Reclaim Storage on 3Par: Use Cases
  • KFOD
  • AMDU
  • Summary
  • Chapter 14: Oracle 12c ASM: A New Frontier
  • Password Files in ASM
  • Disk Management and Rebalance New Features
  • Fast Disk Resync and Checkpoints
  • Fast Disk Replacement
  • Failure Group Repair Timer
  • Rebalance Time Estimations
  • File Priority Rebalance
  • Flex ASM
  • Flex ASM Clustering
  • Flex ASM Listeners
  • Flex ASM Network
  • Remote ASM Access
  • ASM Optimizations on Engineered Systems
  • Error Checking and Scrubbing
  • Other Miscellaneous Flex ASM Features
  • Summary
  • Appendix: Best Practices for Database Consolidation in Private Clouds
  • Private Database Cloud Consolidation: The Business Drivers
  • Initial Server Pool Sizing
  • CPU
  • Partitioning vs. Overprovisioning
  • Memory
  • Storage
  • Complementary Workloads
  • Isolation
  • Database Consolidation
  • Schema Consolidation
  • Summary
  • Index