This is a collection of Oracle technical white papers categorized by topic. There is no claim to completeness. If you are aware of further ones that should be listed, please let me know.
Sometimes the URL changes, the site is broken, or just disappears somehow? Do you sleep better when having everything on disk? Then Download all white papers listed below as a zip file (114 MB). I’d always recommend checking the online version as these might get updated, but just in case, I prefer having a copy in my notebook.
Autonomous Database
- Oracle Autonomous Database Technical Overview
- Oracle Autonomous Database Strategy
- Oracle Autonomous Database – Self-Driving
- Oracle Autonomous Database – Self-Securing
- Oracle Autonomous Database – Self-Repairing
Exadata Cloud and Cloud@Customer
- Oracle Exadata Cloud Service X8M
- Oracle Exadata Database Service on Exadata Cloud@Customer X8M
- Exadata Cloud@Customer Security Controls
- Oracle Exadata Cloud@Customer for Banking
Database Migration
- Oracle Zero Downtime Migration 21c – Technical Brief
- Oracle Zero Downtime Migration – ZDM Physical Migration Step by Step Guide
- Oracle Zero Downtime Migration 21.2 – Step-by-Step Guide – Logical Migration from On-Premises to ADB
- Oracle Zero Downtime Migration 21c – Step by Step Guide – Logical Migration and In-Flight Upgrade from On-Premises to DBCS and ExaCS
- Oracle Zero Downtime Migration – Logical Migration Performance Guidelines
- Migration to the Oracle Cloud with an Oracle GoldenGate Hub Configuration
- Migrating to Oracle Database
- Oracle Database Utilities Data Pump Best Practices for Export and Import
Maximum Availability Architecture (MAA)
- High Availability Overview and Best Practices
- Oracle Maximum Availability Architecture (MAA)
- Oracle MAA Reference Architectures
- Oracle Cloud Maximum Availability Architecture
- Maximum Availability with Oracle Database 19c
- Maximize Availability with Oracle Database 12c Release 2
- Client Failover Best Practices for Highly Available Oracle Databases
Real Application Clusters (RAC)
- The New Generation Oracle RAC
- Application Development Best Practices for Oracle Real Application Clusters (RAC)
- Oracle Real Application Clusters (RAC) on Oracle Database 19c
- Oracle Real Application Clusters (RAC) on Oracle Database 18c
- Oracle Database 12c Release 2 with Oracle Real Application Clusters – New Features Overview
- Oracle Real Application Clusters One Node
- Oracle Real Application Clusters on Oracle VM Environments
- Installing Oracle Extended Clusters on Exadata Database Machine
(Active) Data Guard
- Oracle Active Data Guard versus Storage Remote Mirroring
- Oracle (Active) Data Guard 19c
- Oracle Active Data Guard Far Sync – Zero Data Loss at Any Distance
- Data Guard Maximum Availability – Outage / Resolution Matrix for Zero Data Loss Protection
- Preventing, Detecting, and Repairing Block Corruption: Oracle Database 12c
- Role Transition Best Practices – Data Guard and Active Data Guard
- Redo Apply Best Practices – Oracle Data Guard and Active Data Guard
- Best Practices for Configuring Redo Transport for Data Guard and Active Data Guard 12c
- Best Practices for Synchronous Redo Transport – Data Guard and Active Data Guard
- Best Practices for Asynchronous Redo Transport – Data Guard and Active Data Guard
- Creating a Single Instance Physical Standby for a RAC Primary
Hybrid Disaster Recovery
- Hybrid Data Guard to Oracle Cloud Infrastructure
- Disaster Recovery using Exadata Cloud
- Hybrid Data Guard to Exadata Cloud Services
- Hybrid Data Guard to ExaCC
Application Continuity
- Application Continuity for the Oracle Database
- Application Checklist for Continuous Service for MAA Solutions
- ContinuousAvailability – Best Practices for Adopting Transparent Application Continuity
- Best Practices for Applications Using Autonomous Database – Dedicated
- Application Checklist for Continuous Service with Autonomous Database on Shared Infrastructure
- Application Continuity with Oracle Database12c Release 2
- Planned Database Maintenance of Oracle Autonomous Database on Shared Exadata Infrastructure with JD Edwards EnterpriseOne
- Transaction Guard with Oracle Database
- Fast Application Notification (FAN)
- Design and Deploy Tomcat Applications for Planned, Unplanned Database Downtimes and Runtime Load Balancing with UCP
GoldenGate
- Oracle GoldenGate Advantages
- Oracle Maximum Availability Architecture (MAA) GoldenGate Hub
- Using Oracle GoldenGate on Oracle Cloud Marketplace
- Platinum MAA: Oracle GoldenGate Microservices Architecture Integrated with Oracle Active Data Guard
- Oracle GoldenGate Microservices Architecture on Oracle Exadata Database Service Configuration Best Practices
- Oracle GoldenGate Microservices Architecture with Oracle Real Application Clusters Configuration Best Practices
- Oracle GoldenGate with Oracle Real Application Clusters Configuration Best Practices
- Transparent Role Transitions With Oracle Data Guard and Oracle GoldenGate
- Oracle GoldenGate Performance Best Practices
Database Consolidation
- Oracle Multitenant with Oracle Database 19c
- Best Practices for Database Consolidation
- Consolidation Best Practices
- Oracle Multitenant New Features In Oracle Database 12c Release 2
- Oracle Multitenant
Sharding
Edition-Based Redefinition
Global Data Services (GDS)
Database Backup
- Oracle Database Backup Cloud Service
- Oracle Cloud Infrastructure Exadata Backup & Restore Best Practices using Cloud Object Storage
- ExaCS Database Backup and Restore with Object Storage Performance Observations
Database Cloning
Database Patching
Database Upgrade
- Oracle Database Rolling Upgrades
- Automated Database Upgrades using Oracle Active Data Guard and DBMS_ROLLING
- Upgrade and Migrate to Oracle Database 19c
- Upgrading to Oracle Database 12c (12.1.0.2)
- Oracle Database 12c: Full Transportable Export/Import
Database Monitoring
- Strategies for Scalable, Smarter Monitoring using Oracle Enterprise Manager Cloud Control 13c
- Oracle Enterprise Manager for Autonomous Databases
- Oracle Enterprise Manager for Exadata Cloud
Database Performance
- Oracle Database 19c: Real Application Testing Overview
- Parallel Execution with Oracle Database
- The Oracle Optimizer – Explain the Explain Plan
- Understanding Optimizer Statistics With Oracle Database 12c Release 2
- Best Practices for Gathering Optimizer Statistics with Oracle Database 12c Release 2
- Optimizer with Oracle Database 12c Release 2
Database In-Memory
- Oracle Database In-Memory with Oracle Database 19c
- Oracle Database In-Memory – High Availability Best Practices
- Oracle Database In-Memory: In-Memory Aggregation
- When to Use Oracle Database In-Memory
Database Security
- Securing the Oracle Database
- Oracle Database Vault – Best Practices
- Oracle Database Vault – DBA Administrative Best Practices
- Converting to Transparent Data Encryption with Oracle Data Guard using Fast Offline Conversion
- Managing Oracle Database Encryption Keys in Oracle Cloud Infrastructure with Oracle Key Vault
- Zero Data Loss Recovery Appliance Cyber Security Architecture
Database Heartbeat 