This post is part of a blog series.
I’ve already blogged about it on the official Oracle MAA Blog (read here) , but let me insist on this.
Role transitions (switchover, failover) are much faster in Oracle Data Guard 26ai.
Depending on the configuration and workload, they can be up to five times faster! No changes to the application code or configuration: you get this improvement out of the box.
Here’s an example of two identical configurations using 19.29 and 23.26.1, one PDB, and no application services (basically, an empty database):
Switchover in 19.29
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
$ dgmgrl sys/{password} DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Jan 12 15:05:07 2026 Version 19.29.0.0.0 Copyright (c) 1982, 2025, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "dgb1929ru" Connected as SYSDBA. DGMGRL> set time on 15:05:18 DGMGRL> switchover to dgb1929rub Performing switchover NOW, please wait... Operation requires a connection to database "dgb1929rub" Connecting ... Connected to "dgb1929rub" Connected as SYSDBA. New primary database "dgb1929rub" is opening... Operation requires start up of instance "b1929ru" on database "dgb1929ru" Starting instance "b1929ru"... Connected to an idle instance. ORACLE instance started. Connected to "dgb1929ru" Database mounted. Switchover succeeded, new primary is "dgb1929rub" 15:06:02 DGMGRL> |
Total: ~44 seconds
Switchover in 23.26.1
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
$ dgmgrl sys/$pass DGMGRL for Linux: Release 23.26.1.0.0 - Production on Mon Jan 12 15:43:29 2026 Version 23.26.1.0.0 Copyright (c) 1982, 2026, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "dgdb261" Connected as SYSDBA. DGMGRL> set time on 15:43:54 DGMGRL> switchover to dgdb261b 2026-01-12T15:43:55.742+00:00 Performing switchover NOW, please wait... 2026-01-12T15:43:55.811+00:00 Operation requires a connection to database "dgdb261b" Connecting ... Connected to "dgdb261b" Connected as SYSDBA. 2026-01-12T15:43:55.971+00:00 Continuing with the switchover... 2026-01-12T15:43:58.726+00:00 New primary database "dgdb261b" is opening... 2026-01-12T15:43:58.728+00:00 Operation requires start up of instance "db261" on database "dgdb261" Starting instance "db261"... Connected to an idle instance. ORACLE instance started. Connected to "dgdb261" Database mounted. 2026-01-12T15:44:14.181+00:00 Switchover succeeded, new primary is "dgdb261b" 2026-01-12T15:44:14.193+00:00 Switchover processing complete, broker ready. |
Total: < 20 seconds
😎
The following two tabs change content below.
Latest posts by Ludovico (see all)
- Data Guard 26ai – #1: Faster role transitions - January 27, 2026
- Mini-blog series: Oracle Data Guard 26ai new features - January 27, 2026
- Announcing ADG-Topology - December 18, 2025