| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| |
| 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 | |
| |
| |
| A 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 | |