Posts

Oracle AI Database 26ai(23.26.2)— DML Redirection for Data Guard per Pluggable Database

By -
  Oracle AI Database 26ai introduces DML Redirection for Data Guard per Pluggable Database , allowing write operations to be transparently redirected from a standby PDB to its corresponding primary PDB. With this enhancement, a standby PDB is no longer limited to serving read-only workloads. Applications can perform both read and write operations while connected to the standby PDB, with write requests automatically executed on the primary PDB. This makes the standby environment a more valuable resource by offloading additional application activity and increasing the flexibility of disaster recovery environments. Let’s verify this feature with a simple test. Step 1 — Verify the Standby PDB Connect to the standby database ( CDB2 ) and verify that the target PDB ( AMOL ) is opened in READ ONLY mode. [oracle @OEL9 - DB2 ~ ]$ sqlplus / @cdb2 as sysdba SQL * Plus: Release 23.26 .2 .0 .0 - Production on Tue Jul 14 13 : 29 : 04 2026 Version 23.26 .2 .0 .0 Copyright (c) 1982 , 202...
Post a Comment
Read more

Automatic Standby PDB Instantiation and Standby Redo Log Creation in Oracle AI Database 26ai(23.26.2)

By -
  Oracle AI Database Release Update 23.26.2 introduces an important enhancement for Data Guard per Pluggable Database (PDB) environments. When a protected PDB is added through Data Guard Broker, Oracle automatically performs several tasks that previously required manual intervention. Prior to Release Update 23.26.2 , creating a standby PDB typically involved multiple manual steps, such as: Copying datafiles to the standby CDB Creating Standby Redo Logs (SRLs) Verifying the standby configuration Starting with 23.26.2 , Data Guard Broker automates these operations, simplifying the deployment process and reducing the risk of configuration errors. To demonstrate this enhancement, I created a standby PDB named AMOL on the standby database CDB2 using the following Broker command: DGMGRL> ADD PLUGGABLE DATABASE 'amol' AT cdb2 SOURCE is 'amol' AT cdb1 PDBFileNameConvert is "'/CDB1/','/CDB2/'" ; Pluggable Database "AMOL" added N...
Post a Comment
Read more