Table of Contents
- Title and Copyright Information
- Preface
-
Part I 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
- Oracle Data Guard
- Oracle GoldenGate
- Best Practice: Oracle Active Data Guard and Oracle GoldenGate
- Recovery Manager
- Oracle Real Application Clusters and Oracle Clusterware
- Oracle RAC One Node
- Oracle Automatic Storage Management
- Fast Recovery Area
- Corruption Prevention, Detection, and Repair
- Data Recovery Advisor
-
Oracle Flashback Technology
- Oracle Flashback Query
- Oracle Flashback Version Query
- Oracle Flashback Transaction
- Oracle Flashback Transaction Query
- Oracle Flashback Table
- Oracle Flashback Drop
- Restore Points
- Oracle Flashback Database
- Flashback Pluggable Database
- Block Media Recovery Using Flashback Logs or Physical Standby Database
- Flashback Data Archive
- Oracle Data Pump and Data Transport
- Oracle Replication Technologies for Non-Database Files
- Oracle Multitenant
- Oracle Sharding
- Oracle Restart
- Online Reorganization and Redefinition
- Zero Data Loss Recovery Appliance
- Fleet Patching and Provisioning
- Edition-Based Redefinition
- 4 Oracle Database High Availability Solutions for Unplanned Downtime
- 5 Oracle Database High Availability Solutions for Planned Downtime
- 6 Enabling Continuous Service for Applications
-
7
Operational Prerequisites to Maximizing Availability
- Understand High Availability and Performance Service-Level Agreements
- Implement and Validate a High Availability Architecture That Meets Your SLAs
- Establish Test Practices and Environment
- Set Up and Use Security Best Practices
- Establish Change Control Procedures
- Apply Recommended Software Updates and Security Updates Periodically
- Establish Disaster Recovery Environment
- Establish and Validate Disaster Recovery Practices
- Establish Escalation Management Procedures
- Configure Monitoring and Service Request Infrastructure for High Availability
- Exercise Capacity Planning
- Check the Latest MAA Best Practices
-
Part II Oracle Database High Availability
Best Practices
- 8 Overview of Oracle Database High Availability Best Practices
-
9
Oracle Database Configuration Best
Practices
- Use a Server Parameter File (SPFILE)
- Enable Archive Log Mode and Forced Logging
- Configure an Alternate Local Archiving Destination
- Use a Fast Recovery Area
- Enable Flashback Database
- Set FAST_START_MTTR_TARGET Initialization Parameter
- Protect Against Data Corruption
- Set the LOG_BUFFER Initialization Parameter to 128MB or Higher
- Set USE_LARGE_PAGES=ONLY
- Use Bigfile Tablespace
- Use Automatic Shared Memory Management and Avoid Memory Paging
- Use Oracle Clusterware
- 10 Oracle Flashback Best Practices
-
11
Oracle Global Data Services Best
Practices
- Introduction to Global Data Services
- Application Workload Suitability for Global Data Services
- Global Data Services in Oracle Maximum Availability Architecture
- Partial or Full Site Outage with Global Data Services
-
Global Data Services
Configuration
- High-Level Deployment Steps
- Configuration Example
- Configuration Best Practices
- Using FAN ONS with Global Data Services
- Application-Level Configuration
- Configuring FAN for OCI Clients
- Controlling Logon Storms
- Graceful Application Switchover
- Using Oracle Active Data Guard with Global Data Services
- Using Oracle GoldenGate with Global Data Services
- Global Data Services Failover Across Regions Flow
- Global Data Services Limitations and Requirements
- Part III Oracle RAC and Clusterware Best Practices
-
Part IV Oracle Data Guard Best
Practices
- 13 Overview of MAA Best Practices for Oracle Data Guard
-
14
Plan an Oracle Data Guard
Deployment
- Oracle Data Guard Architectures
- Application Considerations for Oracle Data Guard Deployments
-
Assessing and Optimizing Network
Performance
- Gather Topology Information
- Understanding Network Usage of Data Guard
- Understanding Targets and Goals for Instantiation
- Understanding Throughput Requirements and Average Redo Write Size for Redo Transport
- Verify Average Redo Write Size
- Understand Current Network Throughput
- Optimizing Redo Transport with One and Many Processes
- Using This Data
- Determining Oracle Data Guard Protection Mode
- Offloading Queries to a Read-Only Standby Database
-
15
Configure and Deploy Oracle Data
Guard
-
Oracle Data Guard Configuration
Best Practices
- Apply Oracle Database Configuration Best Practices First
- Use Recovery Manager to Create Standby Databases
- Use Oracle Data Guard Broker with Oracle Data Guard
- Set Log Buffer Optimally
- Set Send and Receive Buffer Sizes
- Set SDU Size to 65535 for Synchronous Transport Only
- Configure Online Redo Logs Appropriately
- Use Standby Redo Log Groups
- Protect Against Data Corruption
- Use Flashback Database for Reinstatement After Failover
- Use Force Logging Mode
- Configure Fast Start Failover to Bound RTO and RPO (MAA Gold Requirement)
- Configure Standby AWR
- Configuring Multiple Standby Databases
- Oracle Active Data Guard Far Sync Solution
- Encrypting a Database Using Data Guard and Fast Offline Encryption
-
Oracle Data Guard Configuration
Best Practices
-
16
Tune and Troubleshoot Oracle Data
Guard
- Overview of Oracle Data Guard Tuning and Troubleshooting
-
Redo Transport Troubleshooting and
Tuning
- Gather Topology Information
- Verify Transport Lag and Understand Redo Transport Configuration
- Gather Information to Troubleshoot Transport Lag
- Compare Redo Generation Rate History on the Primary
- Evaluate the Transport Network and Tune
- Gather and Monitor System Resources
- Tune to Meet Data Guard Resource Requirements
- Advanced Troubleshooting: Determining Network Time with Asynchronous Redo Transport
-
Tuning and Troubleshooting
Synchronous Redo Transport
- Understanding How Synchronous Transport Ensures Data Integrity
- Assessing Performance in a Synchronous Redo Transport Environment
- Why the Log File Sync Wait Event is Misleading
- Understanding What Causes Outliers
- Effects of Synchronous Redo Transport Remote Writes
- Example of Synchronous Redo Transport Performance Troubleshooting
-
Redo Apply Troubleshooting and
Tuning
- Understanding Redo Apply and Redo Apply Performance Expectations
- Verify Apply Lag
- Gather Information
- Compare Redo Generation Rate History on the Primary
- Tune Single Instance Redo Apply
- Enable Multi-Instance Redo Apply if Required
- Addressing a Very Large Redo Apply Gap
- Improving Redo Apply Rates by Sacrificing Data Protection
- Role Transition, Assessment, and Tuning
- Data Guard Performance Observations
- 17 Monitor an Oracle Data Guard Configuration
-
18
Optimizing Automatic Failover in
Common Scenarios to Minimize Downtime
- Automatic Database Failover for Primary Database Outages
- Automatic Data Integrity and Avoidance of Split Brain
- Automatic Reconnect Following Any Outage That Results in Network Timeout
- Automatic Reconnect Following Resolution of Standby Outage
- Data Guard Broker Properties That Affect Outage Repair Times
- Data Guard Standby Database Outage Repair
- Oracle Active Data Guard Far Sync – Examples and Outage Scenarios
- Primary Database Outage Repair
-
Part V MAA Platinum and Oracle GoldenGate
Best Practices
- 19 MAA Platinum Reference Architecture Overview
- 20 Overview of Oracle GoldenGate Best Practices
- 21 Cloud Within Region: Configuring Oracle GoldenGate Hub for MAA Platinum
-
22
Cloud Across Regions: Configuring
Oracle GoldenGate Hub for MAA Platinum
- Overview of MAA GoldenGate Hub
- Planning GGHub Placement in the Platinum MAA Architecture
- Task 1: Configure the Source and Target Databases for Oracle GoldenGate
- Task 2: Prepare a Primary and Standby Base System for GGHub
-
Task 3: Configure Oracle GoldenGate for the
Primary and Standby GGHub
- Step 3.1 - Install Oracle GoldenGate Software
- Step 3.2 - Configure the Cloud Network
- Step 3.3 - Configure ACFS File System Replication Between GGHubs in the Same Region
- Step 3.4 - Create the Oracle GoldenGate Deployment
- Step 3.5 - Configure Oracle Grid Infrastructure Agent (XAG)
- Step 3.6 - Configure NGINX Reverse Proxy
- Step 3.7 - Securing Oracle GoldenGate Microservices to Restrict Non-Secure Direct Access
- Step 3.8 - Create a Clusterware Resource to Manage NGINX
- Step 3.9 - Create an Oracle Net TNS Alias for Oracle GoldenGate Database Connections
- Task 4: Configure the Oracle GoldenGate Environment
-
23
Cloud: Oracle GoldenGate
Microservices Architecture on Oracle Exadata Database Service Configuration Best
Practices
- Overview of Oracle GoldenGate Microservices Architecture Configuration on Oracle Exadata Database Service
- Task 1 - Before You Begin
- Task 2 - Configure the Oracle Database for GoldenGate
- Task 3 - Create a Shared File System to Store the Oracle GoldenGate Deployment
- Task 4 - Install Oracle GoldenGate
- Task 5 - Create the Oracle GoldenGate Deployment
- Task 6 - Configure the Network
- Task 7 - Configure Oracle Grid Infrastructure Agent
- Task 8 - Configure NGINX Reverse Proxy
- Task 9 - Create Oracle Net TNS Alias for Oracle GoldenGate Database Connections
- Task 10 - Create a New Profile
- Task 11 - Configure Oracle GoldenGate Processes
-
24
Cloud MAA Platinum: Oracle
GoldenGate Microservices Architecture Integrated with Active Data
Guard
- Overview
- Task 1 - Before You Begin
- Task 2 - Configure the Oracle Database for GoldenGate
- Task 3 - Configure Oracle Database File System
- Task 4 - Install Oracle GoldenGate
- Task 5 - Create Oracle GoldenGate Deployment Directories
- Task 6 - Network Configuration
- Task 7 - Configure Standby NGINX Reverse Proxy
- Task 8 - Configure Oracle Grid Infrastructure Agent
- Task 9 - Create Oracle Net TNS Alias for Oracle GoldenGate Database Connections
- Task 10 - Configure Oracle GoldenGate Processes
- Example Distribution Path Target Change Script
-
25
On-Premises: Configuring Oracle
GoldenGate Hub
- Overview of MAA GoldenGate Hub
- Planning GGHub Placement in the Platinum MAA Architecture
- Task 1: Configure the Source and Target Databases for Oracle GoldenGate
- Task 2: Prepare a Primary and Standby Base System for GGHub
- Task 3: Configure Oracle GoldenGate for the Primary and Standby GGHub
- Task 4: Configure the Oracle GoldenGate Environment
-
26
On-Premises: Oracle GoldenGate
Microservices Architecture with Oracle Real Application Clusters Configuration Best
Practices
- Summary of Recommendations when Deploying Oracle GoldenGate on Oracle RAC
- Task 1: Configure the Oracle Database for Oracle GoldenGate
- Task 2: Create the Database Replication Administrator User
- Task 3: Create the Database Services
- Task 4: Set Up a File System on Oracle RAC
- Task 5: Install Oracle GoldenGate
- Task 6: Create the Oracle GoldenGate Deployment
- Task 7: Oracle Clusterware Configuration
- Task 8: Configure NGINX Reverse Proxy
- Task 9: Create Oracle Net TNS Alias for Oracle GoldenGate Database Connections
- Task 10: Configure Oracle GoldenGate Processes
- Task 11: Configure Autostart of Extract and Replicat Processes
-
27
On-Premises MAA Platinum: Oracle
GoldenGate Microservices Architecture Integrated with Active Data Guard
- Prerequisites
- Task 1: Configure the Standby Database for Oracle GoldenGate
- Task 2: Modify the Primary Database Service
- Task 3: Create the Standby Database Service
- Task 4: Configure DBFS on the Standby Cluster Nodes
- Task 5: Install Oracle GoldenGate Software
- Task 6: Create Oracle GoldenGate Deployment Directories
- Task 7: Configure the Standby NGINX Reverse Proxy
- Task 8: Configure Oracle Clusterware
- Task 9: Create Oracle Net TNS Aliases for Oracle GoldenGate Database Connections
- Task 10: Configure Oracle GoldenGate Processes
- Example Distribution Path Target Change Script
- 28 Managing Outages for Oracle GoldenGate Hub
- 29 Oracle GoldenGate Active-Active Guidance for Developers and Administrators
- 30 Troubleshooting Oracle GoldenGate
-
Part VI Oracle Database Cloud Best
Practices
- 31 Overview of Oracle Database Cloud Best Practices
- 32 Oracle Maximum Availability Architecture and Oracle Autonomous Database
- 33 Oracle Maximum Availability Architecture in Oracle Exadata Cloud Systems
-
34
Oracle Maximum Availability
Architecture for Multicloud
- MAA Evaluations on Multicloud Solutions
- Oracle Maximum Availability Architecture for Oracle Database@Azure
- Oracle Maximum Availability Architecture for Oracle Database@Google Cloud
-
35
Oracle Data Guard Hybrid Cloud
Configuration
- Benefits Of Hybrid Data Guard in the Oracle Cloud
- MAA Recommendations for Using Exadata Cloud for Disaster Recovery
- Security Requirements and Considerations
- Platform, Database, and Network Prerequisites
- Instantiate the Standby Using Oracle DBaaS Tools
- Data Guard Life Cycle Operations
- Health Check and Monitoring
-
Part VII Continuous Availability for
Applications
-
36
Configuring Continuous
Availability for Applications
- About Application High Availability Levels
- Configuring Level 1: Basic Application High Availability
- Configuring Level 2: Prepare Applications for Planned Maintenance
- Configuring Level 3: Mask Unplanned and Planned Failovers from Applications
- Reference
-
36
Configuring Continuous
Availability for Applications
- Part VIII Oracle Multitenant Best Practices
- Part IX Full Site Switch in Oracle Cloud or On-Premises