Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2nd Edition

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2nd Edition

by Scott Jesse, Bill Burton, Bryan Vongray
Released April 2011
Publisher(s): Oracle Press
ISBN: 9780071752077

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Leverage Oracle Database 11g Release 2 High Availability Features

Protect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource.

  • Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version
  • Build test clusters and hosts using Oracle VM
  • Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System
  • Create synchronized standby databases using Oracle Data Guard
  • Reliably archive and restore data with Oracle Recovery Manager
  • Use Oracle Flashback to identify and undo user errors
  • Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment

Table of contents

  1. Cover Page
  2. Oracle Database 11g Release 2 High Availability
  3. Copyright Page
  4. Dedication
  5. Contents
  6. contents1
  7. Acknowledgments
  8. Introduction
  9. PART I Oracle’s Grid Infrastructure
    1. 1 Architecting the Oracle Database Grid
      1. LunarTrax: To the Moon and Beyond!
      2. Planning the Grid
      3. The Grid and Planned Maintenance
        1. Oracle Technologies: Reducing the Impact of Maintenance
      4. Recovering Quickly from Failures
        1. Oracle Technologies at Play
      5. Protecting Against and Recovering from User Errors
        1. Oracle Technology Checkpoint: Flashback Query and Flashback Table
        2. Again with the Flashback Database
      6. Planning for Expansion and Future Growth
        1. Oracle Technology: Automatic Storage Management
        2. Again with the Oracle Clusterware
      7. Disaster Recovery
        1. Oracle Technology: Oracle Data Guard
      8. What Next?
        1. Test, Test, and Test Some More
      9. Go Forth and Conquer
    2. 2 Oracle VM
      1. Virtualization Basics
      2. Oracle VM
        1. Oracle VM Server and Dom-0
        2. Oracle VM Manager
      3. Using Oracle VM Manager
        1. Server Pools
        2. Servers
        3. Resources
        4. Virtual Machines
      4. Using Oracle VM Server
      5. Multiple VM Servers Using iSCSI for Shared Discs
      6. Supported Oracle VM Configurations for Grid Infrastructure and Oracle RAC
      7. Using Prebuilt Oracle RAC Templates
      8. Summary
    3. 3 Grid Infrastructure
      1. Cluster Ready Services
      2. CRS Concepts
        1. Voting Disk/File
        2. Oracle Cluster Registry (OCR)
        3. Oracle Local Registry (OLR)
        4. Grid Naming Service (GNS)
        5. Single Client Access Name and Its Listener
        6. Virtual IP Addresses
        7. Cluster Time Synchronization Services
        8. Server Pools and Policy-Based Cluster Management
        9. Role-Separated Management
        10. Node Number Pinning and Leases
        11. Agents
        12. Integrating Intelligent Platform Management Interface (IPMI)
      3. CRS Architecture
        1. Oracle HA Services Daemon
        2. Cluster Ready Services Daemon (CRSD)
      4. Clusterware Trace Files
      5. Summary
    4. 4 Grid Infrastructure Installation and Configuration
      1. GI Installation Choices and Requirements
        1. Shared GI Home vs. Local GI Home
        2. Separate Users for GI Home and DB Home
        3. Shared Storage Choices for Clusterware Files
        4. Networking Requirements for CRS and Oracle RAC
        5. Network Interface Bonding
        6. Hardware Requirements
      2. Cluster Verification Utility
      3. Grid Infrastructure Install
        1. Troubleshooting a GI Installation
        2. Recovering from Failure in root.sh
      4. Adding and Removing Nodes from a Cluster
        1. Adding a Node
        2. Deleting a Node
      5. Upgrading to GI
        1. Things to Note for ASM
        2. Upgrade Paths
        3. The Actual Upgrade
      6. What’s New for 11.2.0.2
      7. Summary
    5. 5 Oracle Automatic Storage Management
      1. ASM Concepts
        1. ASM for Single-Instance Databases
        2. ASM Instances
        3. ASM Disks
        4. ASM Disk Groups
        5. ASM Files, Directories, and Aliases
        6. ASM Metadata
        7. ASM Dynamic Volumes
        8. ASM Dynamic Volume Manager
      2. ASM Cluster File System
        1. ACFS for the Database Home
        2. ACFS for a General Purpose File System
        3. ACFS Read-Only Snapshots
        4. ACFS Tagging
        5. ACFS Replication
        6. ACFS Security
        7. ACFS Encryption
      3. Summary
  10. PART II Oracle Real Application Clusters (Oracle RAC)
    1. 6 Oracle RAC Setup/Configuration
      1. Oracle RAC/RDBMS Install Options
        1. Shared Home vs. Private Drives for the RDBMS
        2. Owner of the DB Home
      2. File System Choice for DB Files
      3. cluvfy
      4. Installing Oracle RAC
        1. Patching the Environment
        2. ASM Disk Group Creation
        3. Database Creation with DBCA
      5. Workload Management Considerations
      6. Enabling Archiving
      7. Extending Oracle RAC Databases to New Nodes
        1. Extending the Oracle RDBMS/Oracle RAC Home
        2. Add an Instance to a Policy-Managed Database
        3. Add an Instance to an Administrator-Managed Database
      8. Deleting an Instance from the Oracle RAC Database
        1. Delete an Instance from a Policy-Managed Database
        2. Delete an Instance from an Administrator-Managed Database
      9. Installing Earlier RDBMS Releases
        1. Using Older Oracle Database Versions with GI
        2. Installing a Version 10.2 RDBMS on 11.2 GI
        3. Creating a 10.2 Database Using DBCA
      10. Oracle RAC on Extended Distance Clusters
        1. Stretching a Cluster
        2. Stretching Network Connections
        3. Shared Storage
        4. Voting Disks
      11. Summary
    2. 7 Oracle RAC Administration
      1. Oracle RAC vs. Single-Instance: Additional Processes
        1. LCK: Lock Process
        2. LMD: Lock Manager Daemon Process
        3. LMON: Lock Monitor Process
        4. LMS: Lock Manager Server Process
        5. ACFS: ASM Cluster File System CSS Process
        6. ACMS: Atomic Control File to Memory Service Process
        7. GTXn: Global Transaction Process
        8. LMHB: Global Cache/Enqueue Service Heartbeat Monitor
        9. PING: Interconnect Latency Measurement Process
        10. RMSn: Oracle RAC Management Process
        11. RSMN: Remote Slave Monitor Process
      2. Oracle RAC vs. Single-Instance: The Basics
        1. Cache Fusion: A Brief Intro
        2. Dynamic Resource Mastering
        3. Reconfiguration
        4. Cache Coherency in an Oracle RAC Environment
      3. Redo and Rollback with Oracle RAC
        1. Redo Logs and Instance Recovery
        2. Redo Logs and Media Recovery
      4. Parallelism in an Oracle RAC Environment
        1. Types of Parallelism
      5. Monitoring the Environment
        1. Database Control and Grid Control
        2. OS Watcher (OSW)
        3. Cluster Health Monitor (CHM)
        4. ORION
      6. Tuning with AWR and ADDM
        1. Intelligent Infrastructure
        2. MMON Background Process
        3. Automatic Workload Repository
        4. Automatic Database Diagnostic Monitor
        5. What Drives ADDM?
        6. Interconnect Performance
        7. Sequence Caches
        8. HugePages on Linux
      7. Archiving and Backing Up
        1. Archiving with NFS Mount Points for Your Archive Destination
        2. Archiving in a Cluster File System Environment
        3. Archiving in an ASM Environment
        4. Additional Notes on Archiving in an Oracle RAC Environment
      8. Patches and Patchsets
        1. Rolling Patch Updates
        2. Online Patching (Hot Patching)
        3. The Out-of-Place Patchset Model
        4. Proactive Maintenance Strategy
        5. Recommended Patches
        6. Patchset Updates
      9. Managing the Oracle RAC Database with SRVCTL
        1. The Server Control Utility (SRVCTL)
      10. Management Through Policies
      11. Managing Diagnostic Data
        1. Automatic Diagnostic Repository
        2. ADRCI Command-Line Utility
        3. ADR Structure
        4. ADR in Oracle RAC
        5. Reporting and Resolving a Problem
      12. Summary
    3. 8 Utility Computing: Applications as Services
      1. Services Concepts
        1. Services as a Workload
        2. Services as the Application’s Interface to the Database
        3. Services from the Database Perspective
      2. Distributing Work Among Oracle RAC Nodes for Performance
        1. Client-Side Load Balancing
        2. Server-Side Load Balancing
        3. Load-Balancing Configuration
      3. Event Notification
        1. Notification Concepts
        2. Oracle Notification Service
        3. FAN Callouts
      4. Creating Services and Callouts
        1. Creating Services
        2. Viewing Services from Within the Database
      5. Using SRVCTL to Manage Services and Node Applications
        1. Node Applications
        2. Managing Services via SRVCTL
      6. Cluster Listener Configuration
        1. Grid Naming Service and Listeners
        2. SCAN Listeners
        3. Local Listeners
        4. Listener Registration and PMON Discovery
        5. Why a Virtual IP? TCP Timeouts
        6. Why a SCAN Virtual IP?
        7. Connect-Time Failover
      7. Transparent Application Failover
        1. Server-Side vs. Client-Side TAF
        2. Implementing TAF
        3. Easy Connect
        4. Oracle RAC/Standby/Replication Environments
        5. Integration with OEM
      8. Summary
  11. PART III Disaster Planning
    1. 9 Oracle Data Guard
      1. Making the Right Choice
        1. Physical Standby Databases
        2. Snapshot Standby Databases
        3. Logical Standby Databases
      2. Creating a Physical Standby
      3. Creating a Snapshot Standby
      4. Creating a Logical Standby
        1. Logical Standby Unsupported Objects
      5. Log Transport Services
        1. Defining Log Transport Services Destinations
      6. Log Transport Services Security
      7. Standby Redo Logs
      8. Protection Modes
        1. Maximum Protection
        2. Maximum Availability
        3. Maximum Performance
      9. Handling Network Disconnects
      10. Gap Detection and Resolution
        1. Automatic Gap Resolution
        2. FAL Gap Resolution
      11. Managing a Physical Standby Database
        1. Starting a Physical Standby
        2. Starting and Stopping Managed Recovery
        3. Accommodating Physical Changes on the Primary
        4. Monitoring a Physical Standby
        5. Read-Only Physical Standby Including Oracle Active Data Guard
      12. Managing a Logical Standby Database
        1. Starting and Stopping SQL Apply
        2. Monitoring SQL Apply Progress
        3. Deletion of Standby Archived Logs
        4. Protecting the Logical Standby from User Modifications
        5. Recovering from Errors
        6. Changing the Default Behavior of the SQL Apply Engine
      13. Performing a Role Transition Using Switchover
      14. Performing a Role Transition Using Failover
        1. Failover First Steps
        2. Reinstating a Database After a Failover
      15. Summary
    2. 10 Backup and Recovery for MAA Environments
      1. The Importance of Media Backups
      2. RMAN: A Primer
        1. RMAN and the Controlfile
        2. RMAN and the Data Block
        3. RMAN Command-Line Usage
      3. Preparing an RMAN Backup Strategy
        1. The Flash Recovery Area
        2. RMAN Configuration Parameters
        3. Caring for Your Controlfile
        4. The Snapshot Controlfile
        5. The Recovery Catalog
      4. Backups for the MAA Database
        1. The High Availability Backup Strategy
        2. Backing Up the Flash Recovery Area
        3. Backup Housekeeping
      5. Performing Recovery
        1. Database Recovery: Restore and Recover
        2. Block Media Recovery
        3. Database Recovery: Data Recovery Advisor
      6. Media Management Considerations
        1. The SBT Interface
        2. Backing Up Directly to Tape
        3. Oracle Secure Backup and the OSB Cloud Module
      7. RMAN and Oracle Data Guard
        1. Using RMAN to Build the Standby Database
        2. Using the Physical Standby Database to Create Backups
      8. RMAN and Oracle RAC
        1. RMAN Configuration for the Cluster
      9. Summary
    3. 11 Flashback Recovery
      1. Being Prepared for the Inevitable: Flashback Technology
      2. Laying the Groundwork
      3. Flashback Query and Flashback Table
        1. Configuring for Flashback Query and Flashback Table
        2. Flashback Query
        3. Flashback Versions Query
        4. Flashback Transaction Query
        5. Flashback Table
      4. Flashback Drop
        1. The Recycle Bin
      5. Flashback Transaction
      6. Flashback Database
        1. Flashback Logs
        2. Flashback Retention Target
        3. Flashback Database: Tuning and Tweaking
        4. Different Uses of Flashback Database
      7. Summary
  12. PART IV Enhancing Availability with Additional Features
    1. 12 Oracle Data Guard Broker
      1. Oracle Data Guard Broker Architecture Overview
      2. Oracle Data Guard Broker Configuration
      3. Monitoring an Oracle Data Guard Broker Configuration
      4. Modifying a Broker-Managed Oracle Data Guard Configuration
      5. Role Transitions with Oracle Data Guard Broker
      6. Increasing Database Availability with Fast-Start Failover
      7. Enhancing Application Availability with Fast Application Notification and Role-Based Services
      8. Summary
    2. 13 Oracle Grid Control
      1. What Is Oracle Grid Control?
      2. Grid Control Architecture
      3. Preparing to Install Oracle Grid Control 11g Release 1
        1. OS Prerequisites
        2. Creating and Configuring the Repository Database
      4. Oracle Management Agents
      5. Administration of Grid Control
        1. Common OMS Administration Tasks
        2. Common Agent Administration Tasks
        3. Managing Targets
      6. Monitoring
        1. How Does Grid Control Do It?
        2. Modifying Default Metric Settings
      7. Notifications
        1. Configuring Notification Methods
      8. MAA Environment Administration Using Grid Control
        1. Managing Oracle VM
        2. Managing Grid Infrastructure
        3. Managing Oracle RAC Databases
        4. Managing Oracle Data Guard Configurations
        5. Managing Database Backups
        6. My Oracle Support and Grid Control
      9. Summary
  13. Index

Product information

  • Title: Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2nd Edition
  • Author(s): Scott Jesse, Bill Burton, Bryan Vongray
  • Release date: April 2011
  • Publisher(s): Oracle Press
  • ISBN: 9780071752077