This post is part of a blog series.
Just like observer priorities, this is another cool feature first introduced in Oracle 21c.
If your Fast-Start Failover setup doesn’t have a third site for the observer, the usual advice is to place it with your primary database. But if you want true high availability, making sure the observer is always up, you’ll want two observers on the primary site and two on the secondary site (for when the standby takes over as primary).
Before 21c, you could only use up to three observers, which made this setup impossible.
|
1 2 |
edit database db_site1 set property PreferredObserverHosts='obs1_site1,obs2_site1'; edit database db_site2 set property PreferredObserverHosts='obs1_site2,obs2_site2'; |
Starting with 21c (and, of course, 26ai), you can now configure four observers. That solves the high-availability challenge when you’ve only got two sites.
The following two tabs change content below.
Latest posts by Ludovico (see all)
- Data Guard 26ai – #13: Show / edit all members at once - February 13, 2026
- Data Guard 26ai – #12: ORDS support for Data Guard - February 12, 2026
- Data Guard 26ai – #11: SQLcl support for Data Guard commands - February 10, 2026