Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview of High Availability

• 1.1 What Is High Availability?
• 1.2 Importance of Availability
• 1.3 Cost of Downtime
• 1.4 Causes of Downtime
• 1.5 Roadmap to Implementing the Maximum Availability Architecture (MAA)

2 Determining Your High Availability Requirements

• 2.1 About Determining High Availability Requirements
• 2.2 Analysis Framework for Determining High Availability Requirements
  • 2.2.1 Business Impact Analysis
  • 2.2.2 Cost of Downtime
  • 2.2.3 Recovery Time Objective (RTO)
  • 2.2.4 Recovery Point Objective (RPO)
  • 2.2.5 Manageability Goal
  • 2.2.6 Total Cost of Ownership (TCO) and Return on Investment (ROI)
• 2.3 High Availability Architecture Requirements
  • 2.3.1 Business Performance, Budget, and Growth Plans

3 Oracle Database High Availability Solutions for Unplanned Downtime

• 3.1 Oracle High Availability Solutions and Recovery for Unplanned Downtime
• 3.2 Fast-Start Fault Recovery
• 3.3 Oracle Restart
• 3.4 Oracle Real Application Clusters and Oracle Clusterware
  • 3.4.1 Benefits of Using Oracle Clusterware
  • 3.4.2 Benefits of Using Oracle Real Application Clusters and Oracle Clusterware
• 3.5 Oracle Data Guard
  • 3.5.1 Types of Standby Databases
  • 3.5.2 Benefits of Using Oracle Data Guard and Standby Databases
• 3.6 Oracle Streams
• 3.7 Oracle Flashback Technology
  • 3.7.1 Oracle Flashback Query
  • 3.7.2 Oracle Flashback Version Query
  • 3.7.3 Oracle Flashback Transaction
  • 3.7.4 Oracle Flashback Transaction Query
  • 3.7.5 Oracle Flashback Table
  • 3.7.6 Oracle Flashback Drop
  • 3.7.7 Oracle Flashback Restore Points
  • 3.7.8 Oracle Flashback Database
  • 3.7.9 Block Media Recovery Using Flashback Logs
  • 3.7.10 Flashback Data Archive
• 3.8 Oracle Automatic Storage Management
• 3.9 Fast Recovery Area
• 3.10 Recovery Manager
• 3.11 Data Recovery Advisor
• 3.12 Oracle Secure Backup
• 3.13 Oracle Security Features
• 3.14 LogMiner
• 3.15 Oracle Exadata Storage Server Software (Exadata Cell)
• 3.16 Oracle Database File System (DBFS)
• 3.17 Client Failover
• 3.18 Automatic Block Repair
• 3.19 Corruption Prevention, Detection, and Repair

4 Oracle Database High Availability Solutions for Planned Downtime

• 4.1 Oracle High Availability Solutions and Recovery Times for Planned Downtime
  • 4.1.1 Operating System Upgrades and Hardware Upgrades
  • 4.1.2 System and Cluster Upgrades and Migrations Using Oracle Data Guard
  • 4.1.3 Oracle Interim Database Patches
  • 4.1.4 Online Patching
  • 4.1.5 Upgrading Oracle Clusterware
  • 4.1.6 Upgrading Oracle Automatic Storage Management (Oracle ASM)
  • 4.1.7 Storage Migration
  • 4.1.8 Migrating Oracle Exadata Storage Server Software
  • 4.1.9 Upgrading Oracle Exadata Storage Server Software
  • 4.1.10 Patch Set and Database Upgrades
  • 4.1.11 Platform Migration Across the Same Endian Format Platforms
  • 4.1.12 Platform Migration Across Different Endian Format Platforms
• 4.2 Dynamic Resource Provisioning
  • 4.2.1 Dynamic Reconfiguration of the Database
  • 4.2.2 Automatic Tuning of Memory Management
  • 4.2.3 Automated Distribution of Data Files, Control Files, and Log Files
• 4.3 Online Reorganization and Redefinition
• 4.4 Transportable Technologies
• 4.5 Online Application Maintenance and Upgrades
  • 4.5.1 Edition-Based Redefinition
  • 4.5.2 Oracle Streams for Rolling Upgrades
  • 4.5.3 DDL with the WAIT Option
  • 4.5.4 ENABLE, DISABLE, and FOLLOWS Clauses for CREATE TRIGGER
  • 4.5.5 Enhanced ADD COLUMN Functionality
  • 4.5.6 Finer-Grained Dependencies
  • 4.5.7 Invisible Indexes
  • 4.5.8 Materialized View Logging Control
  • 4.5.9 Dependent PL/SQL Recompilation After Online Table Redefinition

5 Optimizing Return on Investment (ROI)

• 5.1 Grid Computing
• 5.2 Database Server Grid
• 5.3 Database Storage Grid
• 5.4 Disaster Recovery Using Active Standby Databases
  • 5.4.1 Active Data Guard Option for Physical Standby Databases
  • 5.4.2 Web Scale Using Standby Reader Farms
• 5.5 Oracle VM and Domain Live Migration

6 Optimizing Manageability

• 6.1 Intelligent Infrastructure
• 6.2 Change Assurance
• 6.3 Oracle Enterprise Manager Grid Control

7 High Availability Architectures and Solutions

• 7.1 Oracle Database High Availability Architectures
  • 7.1.1 Oracle Database
  • 7.1.2 Oracle Database with Oracle Clusterware (Cold Cluster Failover)
  • 7.1.3 Oracle Database with Oracle Real Application Clusters (Oracle RAC)
  • 7.1.4 Oracle Database with Oracle RAC on Extended Clusters
  • 7.1.5 Oracle Database with Oracle Data Guard
  • 7.1.6 Oracle Database with Oracle Clusterware and Oracle Data Guard
  • 7.1.7 Oracle Database with Oracle RAC and Oracle Data Guard
  • 7.1.8 Oracle Database with Oracle Streams
• 7.2 Choosing the Correct High Availability Architecture
• 7.3 Integrating Application Server High Availability
  • 7.3.1 Oracle Application Server High Availability Architectures
  • 7.3.2 Redundant Architectures
  • 7.3.3 High Availability Services in Oracle Application Server
• 7.4 Integrating High Availability for All Applications

Glossary

Index