Problems with DataGuard fast start failover
YadorJan 28 2013 — edited Feb 14 2013Hello,
I need some help.
I work for a client on a Data Guard 11gR2 installed on 2 physical servers running Windows 2008 Server R2.
The broker is configured and the MaxAvailibility mode is activated.
I'm able to switchover and failover successfully.
The problems are coming when we try to configure FSFO.
We configure the systems to meet the FSFO's requirements:
- MaxAvailibility
- LogXptMode = SYNC
- Flashback enabled on both primary and standby
- FastStartFailoverTarget parameters are set properly
We configure the Observer on another server, virtual (vmware), running Windows 2008 Server R2.
All the 3 servers are pinging each other successfully, tnsping also, no problem.
I'm able to activate the FSFO successfully.
But later, both primary and standby are down, with these error messages in alert log:
On primary:
Primary has heard from neither observer nor target standby within FastStartFailoverThreshold seconds.
It is likely an automatic failover has already occurred. Primary is shutting down.
ORA-16830: primary isolated from fast-start failover partners longer than FastStartFailoverThreshold seconds: shutting down
LGWR (ospid: 6336): terminating the instance due to error 16830
Instance terminated by LGWR, pid = 6336
The standby database has not been started...
I have also errors Fatal NI Connect 12514 and 12518 with ns main err code: 12564 in alert log
But I can't find the problem. All my tests with ping, tnsping and connection through SQL*Plus between servers were OK.$
No firewall are configured.
The parameter FastStartFailoverThreshold is set to 30 seconds.
Is there a problem in the data guard configuration or is there any other problem with Oracle Net , listeners ?
The fact is that without FSFO, the Data Guard works perfectly.
Thank you for your help.
Best Regards