Re: notifications from ONS in Oracle Restart when the node dies

How are the services configured in the databases and with Oracle Restart/srvctl? If I am understanding the documentation, that notification should come from the new primary. FAN events are always published through ONS. However, the event notifying a failover is only published for database services that have been configured to be active while the database is in the primary role on the new primary database.

Services that must be active in any given database role (primary, physical standby, logical standby, or snapshot standby) must be configured with the Server Control utility (SRVCTL) explicitly on each database where the service must be active.

https://docs.oracle.com/en/database/oracle/oracle-database/19/dgbkr/using-data-guard-broker-to-manage-switchovers-failovers.html#GUID-05918DD1-FB0F-435B-873B-A43BEC1C7638

At the moment, I don’t have a good way of testing to see if the documentation matches reality, but the services and their configuration (specifically with -role) might be a good thing to doublecheck.

Thanks,
Ross

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Tim Gorman <tim.evdbt_at_gmail.com> Date: Tuesday, March 15, 2022 at 3:25 PM To: ORACLE-L <oracle-l_at_freelists.org> Subject: notifications from ONS in Oracle Restart when the node dies CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Colleagues and friends,

I have a customer who is testing FAN-FCF failovers in a DataGuard configuration, and the problem is that when the ONS (Oracle Notification Service) dies along with the host on which the primary database resides, how is the FAN-FCF client informed of the failure?

Is there a way reference the ONS via a load balancer that is based on the ONS on both the host on which the DataGuard primary database resides as well as the ONS on the host on which the DataGuard standby database resides?

Everything is working well until the primary host goes down, so shouldn't the standby ONS take over and send the necessary notification?

Thoughts?

Thanks!

-Tim
--

https://urldefense.com/v3/__http://www.freelists.org/webpage/oracle-l__;!!N4fOi5Mv!JxUAShMRRe0d7i1L1CNvoLR4dB9xy4dHy0E_IZaQLziTLP5JpvIY9UvvtEPCWLAhUz8$<https://urldefense.com/v3/__http:/www.freelists.org/webpage/oracle-l__;!!N4fOi5Mv!JxUAShMRRe0d7i1L1CNvoLR4dB9xy4dHy0E_IZaQLziTLP5JpvIY9UvvtEPCWLAhUz8$>

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 15 2022 - 22:54:23 CET