1/16
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release for Oracle Database High Availability Overview
Changes in Oracle Database 12
c
Release 1 (12.1)
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
2
High Availability and Data Protection – Getting From Requirements to Architecture
2.1
High Availability Requirements
2.2
A Methodology for Documenting High Availability Requirements
2.2.1
Business Impact Analysis
2.2.2
Cost of Downtime
2.2.3
Recovery Time Objective
2.2.4
Recovery Point Objective
2.2.5
Manageability Goal
2.2.6
Total Cost of Ownership and Return on Investment
2.3
Mapping Requirements to Architectures
2.3.1
Oracle MAA Reference Architectures
2.3.2
Bronze Reference Architecture
2.3.3
Silver Reference Architecture
2.3.4
Gold Reference Architecture
2.3.5
Platinum Reference Architecture
2.3.6
High Availability and Data Protection Attributes by Tier
3
Features for Maximizing Availability
3.1
Oracle Data Guard
3.1.1
Oracle Active Data Guard
3.1.2
Data Guard Advantages Over Traditional Solutions
3.1.3
Data Guard and Planned Maintenance
3.1.3.1
Data Guard Redo Apply and Standby-First Patching
3.1.3.2
Data Guard Transient Logical Rolling Upgrades
3.1.3.3
Rolling Upgrade Using Oracle Active Data Guard
3.2
Oracle GoldenGate
3.2.1
Oracle GoldenGate 12
c
3.2.2
Oracle GoldenGate 11
g
Release 2
3.2.3
Oracle GoldenGate and Maximum Availability Architecture
3.3
Best Practice: Oracle Active Data Guard and Oracle GoldenGate
3.3.1
When to Use Oracle Active Data Guard
3.3.2
When to Use Oracle GoldenGate
3.3.3
When to Use Oracle Active Data Guard and Oracle GoldenGate Together
3.4
Recovery Manager
3.5
Oracle Secure Backup
3.6
Oracle Real Application Clusters and Oracle Clusterware
3.6.1
Benefits of Using Oracle Clusterware
3.6.2
Benefits of Using Oracle Real Application Clusters and Oracle Clusterware
3.6.3
Oracle RAC Advantages Over Traditional Cold Cluster Solutions
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
Oracle Security Features
3.13
Oracle Flashback Technology
3.13.1
Oracle Flashback Query
3.13.2
Oracle Flashback Version Query
3.13.3
Oracle Flashback Transaction
3.13.4
Oracle Flashback Transaction Query
3.13.5
Oracle Flashback Table
3.13.6
Oracle Flashback Drop
3.13.7
Restore Points
3.13.8
Oracle Flashback Database
3.13.9
Block Media Recovery Using Flashback Logs or Physical Standby Database
3.13.10
Flashback Data Archive
3.14
Oracle Data Pump and Data Transport
3.15
Oracle Replication Technologies for Non-Database Files
3.15.1
Oracle Database File System
3.15.2
Oracle ASM Cluster File System
3.15.3
Oracle Solaris ZFS Storage Appliance Replication
3.16
Client and Application Failover
3.16.1
Client Failover Processing for Connections
3.16.1.1
Services
3.16.1.2
Fast Application Notification
3.16.2
Transaction Failover and Protection
3.16.2.1
Transaction Guard
3.16.2.2
Application Continuity
3.16.3
Oracle Database with Global Data Services
3.17
Oracle Multitenant
3.18
Oracle Restart
3.19
Oracle Site Guard
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.1.1
Migrating a Database to Oracle Exadata Database Machine or Oracle SuperCluster
5.1.1.2
Platform Migration Solutions
5.1.1.3
Data Pump Tablespace Transportable Export/Import
5.1.1.4
Methods to Reduce Database Migration Downtime
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.4.1
Migrate to Oracle ASM-Managed Storage Using Data Guard
5.1.4.2
Migrate to New Storage Using Oracle ASM Rebalance
5.1.4.3
Migrate to Oracle ASM by Relocating Online Data Files
5.1.5
Migrating a Database from a Single-Instance System to an Oracle RAC Cluster
5.2
Dynamic and Online Resource Provisioning
5.2.1
Renaming and Relocating Online Datafiles
5.2.2
Dynamic Reconfiguration of the Database
5.2.3
Automatic Tuning of Memory Management
5.2.4
Automated Distribution of Data Files, Control Files, and Log Files
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.3.1
Upgrading the Physical Standby Database
5.4.3.2
Best Practices for System and Cluster Upgrades
5.4.4
Patching and Rolling Upgrades With Oracle Real Application Clusters
5.4.4.1
Rolling Patch Installation with Oracle Real Application Clusters
5.4.4.2
Rolling Patch Installation with Data Guard
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.1.1
Editions
5.5.1.2
Editioning Views
5.5.1.3
Crossedition Triggers
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
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.3.1
Configuring the Test System and QA Environments
6.3.2
Performing Preproduction Validation Steps
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 Data Guard Role Transitions
6.8
Establish Escalation Management Procedures
6.9
Configure Monitoring and Service Request Infrastructure for High Availability
6.9.1
Execute Database Health Checks Periodically
6.9.2
Configure Oracle Enterprise Manager Monitoring Infrastructure for High Availability
6.9.3
Configure Automatic Service Request Infrastructure
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.2.1
Oracle Database HA and Data Protection
7.2.2
Database Consolidation in the Bronze Tier
7.2.3
Life Cycle Management and DBaaS
7.2.4
Oracle Engineered Systems
7.2.5
Bronze Summary: Data Protection, RTO, and RPO
7.3
The Silver Tier - High Availability with Automatic Failover
7.3.1
Oracle RAC
7.3.2
Oracle RAC One Node
7.3.3
Silver Tier Summary: Data Protection, RTO, and RPO
7.4
The Gold Tier - Comprehensive High Availability and Disaster Recovery
7.4.1
Oracle Active Data Guard - Real Time Data Protection and Availability
7.4.2
Oracle GoldenGate
7.4.3
Oracle Site Guard
7.4.4
Gold Summary: Data Protection, RTO, and RPO
7.5
The Platinum Tier - Zero Outage for Platinum Ready Applications
7.5.1
Application Continuity
7.5.2
Oracle Active Data Guard Far Sync
7.5.3
Oracle GoldenGate Zero Downtime Maintenance and Active-Active Replication
7.5.4
Edition Based Redefinition
7.5.5
Global Data Services
7.5.6
Platinum Summary: Data Protection, RTO, and RPO
7.6
Integrating Oracle Fusion Middleware High Availability
7.6.1
Oracle WebLogic Server High Availability Architectures
7.6.2
Redundant Architectures
7.6.3
High Availability Services in Oracle Fusion Middleware
7.7
Integrating High Availability for All Applications
8
Oracle Engineered Systems
8.1
Oracle Exadata Database Machine
8.2
Oracle SuperCluster
8.3
Oracle Database Appliance
9
Optimizing Return on Investment
9.1
High ROI Using Grid Computing
9.1.1
Database Server Grid
9.1.2
Database Storage Grid
9.2
High ROI Using Active Standby Databases
9.2.1
Oracle Active Data Guard Option for Physical Standby Databases
9.2.2
Oracle Active Data Guard Reader Farms
9.2.3
Data Guard and the Cloud (Data Protection as a Service)
9.3
High ROI Using Oracle Database Consolidation
9.3.1
Multitenant Architecture
9.3.2
Oracle Virtualization
9.4
High ROI Using Oracle Global Data Services
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.