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
- Oracle Site Guard
- Online Reorganization and Redefinition
- Zero Data Loss Recovery Appliance
- Fleet Patching and Provisioning
- Enabling Continuous Service for Applications
- 4 Oracle Database High Availability Solutions for Unplanned Downtime
- 5 Oracle Database High Availability Solutions for Planned Downtime
-
6
Operational Prerequisites to Maximizing Availability
- Understand Availability and Performance SLAs
- 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 Patches and Software Periodically
- Execute Disaster Recovery Validation
- Establish Escalation Management Procedures
- Configure Monitoring and Service Request Infrastructure for High Availability
- Check the Latest MAA Best Practices
-
Part II Oracle Database High Availability
Best Practices
- 7 Overview of Oracle Database High Availability Best Practices
-
8
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
- Use Automatic Shared Memory Management and Avoid Memory Paging
- Use Oracle Clusterware
-
Part III Oracle Data Guard Best
Practices
- 9 Overview of MAA Best Practices for Oracle Data Guard
- 10 Plan an Oracle Data Guard Deployment
-
11
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 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
- Configuring Multiple Standby Databases
- Oracle Active Data Guard Far Sync Solution
-
Oracle Data Guard Configuration
Best Practices
-
12
Tune and Troubleshoot Oracle Data
Guard
- Overview of Oracle Data Guard Tuning and Troubleshooting
-
Redo Transport Troubleshooting and
Tuning
- System and Network Performance Prerequisites
- Monitor System Resources
- Assess Database Wait Events
-
Assess 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
- Role Transition Assessment and Tuning
- 13 Monitor an Oracle Data Guard Configuration
- Part IV Oracle GoldenGate High Availability Best Practices