Category Archives: Oracle AI Database 26ai

Data Guard 26ai – #1: Faster role transitions

Posted on by
Reply

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

Total: ~44 seconds

Switchover in 23.26.1

Total: < 20 seconds

😎

Mini-blog series: Oracle Data Guard 26ai new features

Posted on by
Reply

Thank you for your patience: Oracle AI Database 26ai is now available on Linux x86_64 systems!
This release delivers many new features, including key updates to Data Guard and Active Data Guard: two areas I track as a product manager.
Some improvements aren’t listed in the feature guide, so I’m launching a daily series of brief blog posts over the next month. Each one will spotlight a practical change or enhancement you can try right away.

  1. Faster role transitions
  2. Minimized Stall in Maximum Performance
  3. Choice of Lag Type for Fast-Start Failover
  4. Faster DML Redirection
  5. Fast-Start Failover Observer Priority (21c)
  6. Up to four Fast-Start Failover Observers (21c)
  7. Rolling Upgrade with Application Continuity
  8. Multiple ASYNC connections
  9. Automatic preparation of primary and standby
  10. Data Guard Broker PL/SQL API
  11. SQLcl support for Data Guard commands
  12. ORDS support for Data Guard
  13. Show / edit all members at once
  14. JSON output for DGMGRL
  15. Prevent standby databases from becoming primary
  16. Configuration and member tagging
  17. Automatic standby tempfile creation
  18. PDB Recovery Isolation
  19. Easy AWR snapshots on the standby
  20. Strict database validation
  21. Switchover and Failover Readiness
  22. Easier tracking of role transitions
  23. Easier checking of Data Guard configurations
  24. New command: VALIDATE DGConnectIdentifier
  25. Easier checking of Fast-Start Failover configurations
  26. Fast-Start Failover Lag Histogram
  27. Enhanced observer diagnostic
  28. Fast Start Failover Configuration Validation
  29. Offload AI Inference and Vector Search to Oracle Active Data Guard