Database Cloud Storage

Book description

Implement a Centralized Cloud Storage Infrastructure with Oracle Automatic Storage Management

Build and manage a scalable, highly available cloud storage solution. Filled with detailed examples and best practices, this Oracle Press guide explains how to set up a complete cloud-based storage system using Oracle Automatic Storage Management. Find out how to prepare hardware, build disk groups, efficiently allocate storage space, and handle security. Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management shows how to monitor your system, maximize throughput, and ensure consistency across servers and clusters.

  • Set up and configure Oracle Automatic Storage Management
  • Discover and manage disks and establish disk groups
  • Create, clone, and administer Oracle databases
  • Consolidate resources with Oracle Private Database Cloud
  • Control access, encrypt files, and assign user privileges
  • Integrate replication, file tagging, and automatic failover
  • Employ pre-engineered private cloud database consolidation tools
  • Check for data consistency and resync failed disks

Code examples in the book are available for download

Table of contents

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

Product information

  • Title: Database Cloud Storage
  • Author(s): Nitin Vengurlekar, Prasad Bagal
  • Release date: July 2013
  • Publisher(s): McGraw Hill Computing
  • ISBN: 9780071790161