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 Globally 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 Sharding
- Where To Go From Here
- 2 Oracle Globally Distributed Database Architecture and Concepts
- 3 Security in an Oracle Globally Distributed Database Environment
-
4
Oracle Globally Distributed Database Deployment
- Introduction to Sharded Database Deployment
- Planning Your Sharded Database 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 Oracle Globally Distributed Database Topology
- Deploy the Configuration
- Create and Start Global Database Services
- Verify Shard Status
- Creating a Shard Catalog Standby
- Example Oracle Globally Distributed Database Deployment
- 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
- 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
Oracle Globally Distributed Database Schema Design
- Schema Design Considerations
- Sharding Keys
- Creating Schema Objects
- Creating Indexes on Sharded Tables
- Modifying an Oracle Globally Distributed Database Schema
- DDL Processing in an Oracle Globally Distributed Database
- Running PL/SQL Procedures in an Oracle Globally Distributed Database
- Generating Unique Sequence Numbers Across Shards
- Schema Creation Examples
- DDL Failure and Recovery Examples
- High Speed Data Ingest with SQL*Loader
-
9
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
-
10
Oracle Globally Distributed Database Administration
- Managing the Oracle Globally Distributed Database Stack
- Oracle Globally Distributed Database Users and Roles
-
Backing Up and Recovering Oracle Globally Distributed Database
- Backup and Restoration Terminology
- Automated and On-Demand Backups
- Supported Backup Destinations
- Limitations
- Prerequisites to Configuring Centralized Backup and Restore
- Configuring Automated Backups
- Enabling and Disabling Automated Backups
- Backup Job Operation
- Monitoring Backup Status
- Viewing an Existing Backup Configuration
- Running On-Demand Backups
- Viewing Backup Job Status
- Listing Backups
- 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 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
- 11 Developing Applications for Oracle Globally Distributed Database
- 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 Sharding JSON Document Collections
-
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 Shard Catalog and Sharded Databases
- Configuring the Shard Catalog
- Configuring the Shard Databases
- Creating the Oracle Globally Distributed Database
- Implementing a Session-Based Application Context Policy
-
17
Troubleshooting
-
Troubleshooting Tips
- Pre-Deployment Network Validation
- Checking the Sharding 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
- 18 Oracle Globally Distributed Database Solutions
- 19 Oracle Globally Distributed Database Reference