Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with DataGuard fast start failover

YadorJan 28 2013 — edited Feb 14 2013
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2013
Added on Jan 28 2013
7 comments
5,036 views