Changes in This Release for Oracle Database Global Data Services Concepts and Administration Guide

This preface contains:

Changes in Oracle Database 23ai

The following are changes in Oracle Database Global Data Services Concepts and Administration Guide for Oracle Database 23ai.

Global Data Services Suport of True Cache

With the introduction of Oracle Database 23ai, Global Data Services now supports True Cache. Oracle True Cache is an in-memory, consistent, and automatically managed SQL cache for Oracle Database.

Oracle True Cache can be deployed with Oracle Database Global Data Services (GDS) to manage workload routing, dynamic load balancing, and service failover across multiple True Caches and other database replicas.

See:

Oracle True Cache User's Guide for more information.

GDSCTL Commands Supporting RAFT Replication

With the introduction of Oracle Database 23ai, Global Data Services now supports RAFT Replication.

New GDSCTL commands have been added to support RAFT Replication in a sharded environment. They include:

  • ALTER MOVE
  • ALTER TASK
  • CONFIG TASK
  • COPY RU (REPLICATION_UNIT)
  • MOVE RU
  • RELOCATE CHUNK
  • REMOVE RU
  • STATUS RU
  • START|STOP RU
  • SWITCHOVER RU
  • SYNC RU

See:

Global Data Services Control Utility (GDSCTL) Command Reference

Oracle Globally Distributed Database Guide

Changes in Oracle Database 21c

The following are changes in Oracle Database Global Data Services Concepts and Administration Guide for Oracle Database 21c.

New Features

The following features are new in this release:

GDSCTL Commands Supporting Coordinated Backup and Restore of a Sharded Database

New GDSCTL commands have been included in this release to provide an automated and centralized management and monitoring infrastructure for scheduling coordinated backup and restore operations of a sharded database.

See

GDSCTL Commands Supporting Sharding of Existing Databases

When creating a sharded environment from existing databases, the common shared schemas across the existing databases are retreived. The new GDSCTL SYNC SCHEMA command has been added to support this.

There is a new GDSCTL CREATE SHARDCATALOG parameter, -FOR_FEDERATED_DATABASE to support federated sharding.

See

Deprecation and Desupport

The following features are deprecated or desupported in this release:

Deprecation of Service Attribute Values

Several session-related service attribute values have been deprecated in 21c. For more information see:

Deprecation of Service Attribute Value SESSION_STATE_CONSISTENCY = STATIC

Changes in Oracle Database 19c

The following are changes in Oracle Database Global Data Services Concepts and Administration Guide for Oracle Database 19c.

New Features

The following features are new in this release:

Multiple Table Family Support for System-Managed Sharding

The Oracle Globally Distributed Database feature for Oracle Database 18c supported only one table family (a set of related tables sharing the same sharding key) for each sharded database. In Oracle Database 19c, Oracle Globally Distributed Database includes support for multiple table families where all data from different table families reside in the same chunks. This feature applies to system-managed sharded databases only. Different applications accessing different table families can now be hosted on one sharded database.

There is one new GDSCTL command, CONFIG TABLE FAMILY, and several other commands are extended to support this feature: ADD SERVICE, MODIFY SERVICE, CONFIG SERVICE, CONFIG CHUNKS, STATUS ROUTING, and VALIDATE CATALOG.

There are no new SQL keywords or statements introduced with this feature; however, some restrictions are changed with the use of CREATE SHARDED TABLE, DUPLICATED TABLE, and TABLESPACE SET.

See

GSMROOTUSER

A new user called GSMROOTUSER is used to log into CDB$ROOT for CDBs in a sharding configuration (this user is not used in GDS configurations). Any connections to CDB$ROOT in a CDB will now be with GSMROOTUSER.

See

Deprecation and Desupport

The following features are deprecated or desupported in this release:

Desupport of Setting Passwords in GDSCTL Command Line

To enhance security, starting with Oracle Database 19c, the ability to specify passwords from the Global Data Services Control Utility (GDSCTL) command-line when called from the operating system prompt is no longer supported.

This desupport applies only to password changes where GDSCTL is called from a user command-line prompt. For example, the following command is desupported: 

$ gdsctl add database -connect inst1 -pwd gsm_password

Specifying the password from the GDSCTL utility itself is still valid. For example, the following command is valid:

GDSCTL> add database -connect inst1 -pwd gsm_password

This deprecation addresses the security vulnerability when specifying passwords in GDSCTL commands called from the operating system prompt.

Changes in Oracle Database 18c Release 1 (18.1)

The following are changes in Oracle Database Global Data Services Concepts and Administration Guide for Oracle Database 18c Release 1 (18.1)

New Features

The following features are new in this release:

  • ADD SHARD is extended and new commands ADD CDB, MODIFY CDB, CONFIG CDB, and REMOVE CDB are implemented so that Oracle Globally Distributed Database can support a multitenant architecture.

    See add shard, add cdb, modify cdb, config cdb, and remove cdb.

  • With the release of Oracle GoldenGate 18c, the composite sharding method is supported with GoldenGate replication. The add shardgroup and create shardcatalog command documentation is updated accordingly.

    See add shardgroup and create shardcatalog.