Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database High Availability Overview
- 1 Overview of High Availability
- 2 High Availability and Data Protection – Getting From Requirements to Architecture
- 3
Features for Maximizing Availability
- 3.1 Oracle Data Guard
- 3.2 Oracle GoldenGate
- 3.3 Best Practice: Oracle Active Data Guard and Oracle GoldenGate
- 3.4 Recovery Manager
- 3.5 Oracle Secure Backup
- 3.6 Oracle Real Application Clusters and Oracle Clusterware
- 3.7 Oracle RAC One Node
- 3.8 Oracle Automatic Storage Management
- 3.9 Fast Recovery Area
- 3.10 Corruption Prevention, Detection, and Repair
- 3.11 Data Recovery Advisor
- 3.12 State Object Quarantine
- 3.13 Oracle Security Features
- 3.14
Oracle Flashback Technology
- 3.14.1 Oracle Flashback Query
- 3.14.2 Oracle Flashback Version Query
- 3.14.3 Oracle Flashback Transaction
- 3.14.4 Oracle Flashback Transaction Query
- 3.14.5 Oracle Flashback Table
- 3.14.6 Oracle Flashback Drop
- 3.14.7 Restore Points
- 3.14.8 Flashback Pluggable Database
- 3.14.9 Block Media Recovery Using Flashback Logs or Physical Standby Database
- 3.14.10 Flashback Data Archive
- 3.15 Oracle Data Pump and Data Transport
- 3.16 Oracle Replication Technologies for Non-Database Files
- 3.17
Client and Application Failover
- 3.17.1
Client Failover Processing for Connections
- 3.17.1.1
Services
- 3.17.1.1.1 Service Usage in a Single-Instance Database and Data Guard Environment
- 3.17.1.1.2 Service Usage in an Oracle RAC Database Environment
- 3.17.1.1.3 Service Usage in an Oracle RAC Database and Data Guard Environment
- 3.17.1.1.4 Service Usage in a Replicated Environment or Oracle Active Data Guard Environment
- 3.17.1.2 Fast Application Notification
- 3.17.1.1
Services
- 3.17.2 Transaction Failover and Protection
- 3.17.3 Oracle Database with Global Data Services
- 3.17.1
Client Failover Processing for Connections
- 3.18 Oracle Multitenant
- 3.19 Oracle Sharding
- 3.20 Oracle Restart
- 3.21 Oracle Site Guard
- 3.22 Zero Data Loss Recovery Appliance
- 4 Oracle Database High Availability Solutions for Unplanned Downtime
- 5
Oracle Database High Availability Solutions for Planned Downtime
- 5.1
High Availability Solutions for Migration
- 5.1.1 Platform Migration
- 5.1.2 Database Migration to a Different Character Set
- 5.1.3 Migrating to Multitenant Architecture
- 5.1.4 Migration to Oracle ASM Storage
- 5.1.5 Migrating a Database from a Single-Instance System to an Oracle RAC Cluster
- 5.2 Dynamic and Online Resource Provisioning
- 5.3 Online Reorganization and Redefinition
- 5.4
Oracle High Availability Solutions for System and Software Maintenance
- 5.4.1 Operating System Upgrades and Hardware Upgrades
- 5.4.2 Online Patching
- 5.4.3 System and Cluster Upgrades Using Data Guard
- 5.4.4 Patching and Rolling Upgrades With Oracle Real Application Clusters
- 5.4.5 Rolling Upgrade with Oracle Clusterware
- 5.4.6 Rolling Upgrade with Oracle Automatic Storage Management
- 5.4.7 Rolling Upgrade of Exadata Storage Server Software
- 5.4.8
Database Rolling Upgrade with Data Guard
- 5.4.8.1 Performing Database Upgrades Using Data Guard and Physical Standby Databases
- 5.4.8.2 Performing Database Upgrades Using Data Pump Full Transportable Export/Import
- 5.4.8.3 Performing Database Upgrades Using Transportable Tablespace
- 5.4.8.4 Performing Database Upgrades Using Oracle GoldenGate
- 5.4.8.5 Performing Database Upgrades Using Oracle GoldenGate and Data Guard
- 5.5
Online Application Maintenance and Upgrades
- 5.5.1 Edition-Based Redefinition
- 5.5.2 Oracle GoldenGate for Rolling Upgrades
- 5.5.3 DDL with the WAIT Option
- 5.5.4 ENABLE, DISABLE, and FOLLOWS Clauses for CREATE TRIGGER
- 5.5.5 Enhanced ADD COLUMN Functionality
- 5.5.6 Finer-Grained Dependencies
- 5.5.7 Invisible Indexes
- 5.5.8 Invisible Columns
- 5.5.9 Multiple Indexes on the Same Set of Columns
- 5.5.10 Dependent PL/SQL Recompilation After Online Table Redefinition
- 5.1
High Availability Solutions for Migration
- 6
Operational Prerequisites to Maximizing Availability
- 6.1 Understand Availability and Performance SLAs
- 6.2 Implement and Validate a High Availability Architecture That Meets Your SLAs
- 6.3 Establish Test Practices and Environment
- 6.4 Set Up and Use Security Best Practices
- 6.5 Establish Change Control Procedures
- 6.6 Apply Recommended Patches and Software Periodically
- 6.7 Execute Disaster Recovery Validation
- 6.8 Establish Escalation Management Procedures
- 6.9 Configure Monitoring and Service Request Infrastructure for High Availability
- 6.10 Check the Latest MAA Best Practices
- 7
High Availability Architectures
- 7.1 Introduction to MAA Reference Architectures
- 7.2 The Bronze Tier – A Single Instance HA Architecture
- 7.3 The Silver Tier - High Availability with Automatic Failover
- 7.4 The Gold Tier - Comprehensive High Availability and Disaster Recovery
- 7.5 The Platinum Tier - Zero Outage for Platinum Ready Applications
- 7.6 Oracle Database Sharding Reference Architecture
- 7.7 Integrating Oracle Fusion Middleware High Availability
- 7.8 Integrating High Availability for All Applications
- 8 Oracle Engineered Systems
- 9 Optimizing Return on Investment
- Glossary
- Index