Table of Contents
- Title and Copyright Information
- Preface
- Changes in Oracle Globally Distributed Database for Oracle Database 23ai
-
1
Oracle Globally Distributed Database Overview
- What is a Distributed Database
- About Oracle Globally Distributed Database
- Oracle Globally Distributed Database as Distributed Partitioning
- Benefits of Oracle Globally Distributed Database
- Example Applications using Oracle Globally Distributed Database
- Flexible Deployment Models
- Data Replication in Oracle Globally Distributed Database
- Data Distribution Methods
- Client Request Routing
- Query Processing
- High Speed Data Ingest
- Deployment Automation
- Data Migration
- Lifecycle Management
- Federated Distributed Database
- Where To Go From Here
-
2
Oracle Globally Distributed Database Architecture and Concepts
- Architecture and Components
- Schema Objects
- Data Distribution Methods
- Client Application Request Routing
- Query Processing and the Query Coordinator
- Data Replication
-
3
Oracle Globally Distributed Database Deployment
- Introduction to Distributed Database Deployment
- Planning Your Deployment
- Install the Oracle Database Software
- Install the Shard Director Software
- Create the Shard Catalog Database
- Create the Shard Databases
- Validate the Shard Database
- Configure the Distributed Database Topology
- Deploy the Configuration
- Create and Start Global Database Services
- Verify Shard Status
- Creating a Shard Catalog Standby
- Example Distributed Database Deployment
-
4
Oracle Globally Distributed Database Schema Design
- Schema Design Considerations
- Sharding Keys
- Creating Schema Objects
- Creating Indexes on Sharded Tables
- Oracle AI Vector Search in a Distributed Database
- Modifying a Distributed Database Schema
- DDL Processing in a Distributed Database
- Running PL/SQL Procedures in a Distributed Database
- Generating Unique Sequence Numbers Across Shards
- High Speed Data Ingest with SQL*Loader
- Schema Creation Examples
- DDL Failure and Recovery Examples
- 5 Shard-Level Replication with Oracle Data Guard
-
6
Raft Replication Configuration and
Management
- Using Raft Replication in Oracle Globally Distributed Database
- Enabling Raft Replication
-
Raft Replication Operations and
Settings
- Specifying Replication Unit Attributes
- Ensuring Replicas Are Not Placed in the Same Rack
- Getting Runtime Information for Replication Units
- Scaling with Raft Replication
- Moving Replication Unit Replicas
- Changing the Replication Unit Leader
- Copying Replication Units
- Moving A Chunk to Another Replication Unit
- Splitting Chunks in Raft Replication
- Getting the Replication Type
- Starting and Stopping Replication Units
- Synchronizing Replication Unit Members
- Enable or Disable Reads from Follower Replication Units
- Viewing Parameter Settings
- Setting Parameters with GDSCTL
- Tuning Flow Control to Mitigate Follower Lag
- Setting Transaction Consensus Timeout
- Dynamic Performance Views for Raft Replication
- Raft Replication Restrictions
-
7
Deploying and Managing a
Directory-Based Oracle Globally Distributed Database
- Directory-Based Sharding Roadmap
- Creating a Shard Catalog for Directory-Based Sharding
- Creating Tables Sharded by Directory
- Managing Keys in Directory-Based Sharding
- DML Support on Tables Sharded by Directory
- Adding a New Tablespace and Chunks (Partition) in a Shardspace
- Chunk Management in Directory Based Sharding
- Splitting Partitions (Chunks)
- Sharding Key Directory Public View
-
8
Query and DML Processing
- How Database Requests are Routed to the Shards
- Connecting to the Query Coordinator
- Query Coordinator Operation
- Query Processing for Single-Shard Queries
- Query Processing for Multi-Shard Queries
- Multi-Shard Query Coordinator Availability and Scalability
- Pushing PL/SQL Function Queries to the Shards
- Gathering Optimizer Statistics on Sharded Tables
- Supported Query Constructs and Example Query Shapes
- Supported DMLs and Examples
-
9
Oracle Globally Distributed Database Administration
- Managing the Oracle Globally Distributed Database Stack
- Oracle Globally Distributed Database Users and Roles
-
Backing Up and Recovering a Distributed Database
- About Distributed Database Backup and Recovery
- Prerequisites to Configuring Centralized Backup and Restore
- Configuring Automated Backups
-
Managing Backup and
Recovery
- Enabling and Disabling Automated Backups
- Backup Job Operation
- Monitoring Backup Status
- Viewing an Existing Backup Configuration
- Listing Backups
- Viewing Backup Job Status
- Validating Backups
- Deleting Backups
- Creating and Listing Global Restore Points
- Restoring Shards From Backup
- Restoring the Shard Catalog from Backup
- Removing Backup Configuration from a Shard
- Running On-Demand Backups
- Running RMAN Commands from GDSCTL
- Error Handling for Automated Backup Operations
- Propagation of Parameter Settings Across Shards
-
Patching and Upgrading Oracle Globally Distributed Database
- Patching and Upgrading Oracle Globally Distributed Database
- Performing a Rolling Upgrade
- Upgrading Oracle Globally Distributed Database Components
- Post-Upgrade Steps for Oracle Globally Distributed Database 21c
- Compatibility and Migration from Oracle Database 18c
- Downgrading an Oracle Globally Distributed Database
- Managing Oracle Globally Distributed Database with Enterprise Manager Cloud Control
- Monitoring an Oracle Globally Distributed Database
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
- 10 Developing Applications for Oracle Globally Distributed Database
- 11 Security in an Oracle Globally Distributed Database Environment
- 12 Migrating to an Oracle Globally Distributed Database
- 13 Using Oracle Globally Distributed Database in Oracle Cloud Infrastructure
-
14
Using the Sharding Advisor
- About Sharding Advisor
- Run Sharding Advisor
- Run Sharding Advisor on a Non-Production System
- Review Sharding Advisor Output
- Choose a Sharding Advisor Recommended Configuration
- Sharding Advisor Usage and Options
- Sharding Advisor Output Tables
- Sharding Advisor Output Review SQL Examples
- Sharding Advisor Security
- 15 JSON Document Collections in a Distributed Database
-
16
Achieving Data Sovereignty with
Oracle Globally Distributed Database
- Overview of Data Sovereignty
- Benefits of Implementing Data Sovereignty with Oracle Globally Distributed Database
- Implementing Data Sovereignty with Oracle Globally Distributed Database
-
Data Sovereignty Use Case
- Overview of the Data Sovereignty Solution
- Deployment Topology for Data Sovereignty
-
Configuring the Data Sovereignty
Use Case
- Configuring VCN Networks in All Three OCI Regions
- Configuring Remote VCN Peering Between All Three Regions
- Configuring Private DNS for Naming Resolution Between the Regions
- Installing a Global Service Manager in Each Region
- Collecting TNS Entries for the Shard Catalog and Shards
- Configuring the Shard Catalog
- Configuring the Shard Databases
- Creating the Oracle Globally Distributed Database
- Implementing a Session-Based Application Context Policy
- 17 Creating a Federated Distributed Database
- 18 Creating Affinity Between Middle-Tier and Shards
-
19
Troubleshooting
-
Troubleshooting Tips
- Pre-Deployment Network Validation
- Checking the Data Distribution Method
- Checking the Replication Type
- Checking the Oracle Data Guard Protection Mode
- Checking Which Shards Are Mapped to a Key
- Checking Shard Operation Mode (Read-Only or Read-Write)
- Checking DDL Text
- Checking Chunk Migration Status
- Checking Table Type (Sharded or Duplicated)
- Checking User Type (Local or ALL_SHARD)
- Identifying Tables Created as Sharded Tablespaces
- Checking if Shard DDL is Enabled or Disabled
- Filtering Data by Sharding Key
- Gathering Optimizer Statistics on Sharded Tables
- Generate HTML SQL Monitor Output for a Query Running from the Shard Catalog
- Tracing and Debug Information
- Common Error Patterns and Resolutions
-
Troubleshooting Tips
- 20 Oracle Globally Distributed Database Reference