Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Pradeep.

Asked: October 04, 2019 - 12:56 pm UTC

Last updated: October 22, 2019 - 3:30 am UTC

Version: 12.2.0.1

Viewed 1000+ times

You Asked

Dear Sir,

In case of an outage on the primary database, the standard failover procedure applies, and after some time primary server available then how it going to sync all 3 server.
please help me to understand this.

Thanks
Pradeep

and Connor said...

A far sync node is like a "router", a means of getting your redo from your primary to another destination as fast as possible. So a typical configuration is:

primary ------ sync transport ------- far sync node ------- async transport ---------- standby database

So transactions on your primary are being transmitted synchronously to your far sync node. The standby node might be *slighty* out of data, because the redo logs are being transmitted asynchronously.

So if your primary node get destroyed, your far sync node is still OK, it will continue to send any outstanding logs to the standby until the standby has "caught up". The benefit here is that

- your redo logs are protected (because they are on the far sync node)
- primary performance is not impacted (because you located the far sync node "close" to the primary)
- the standby can be a long distance away and over a slower network without impacting production response time but still guaranteeing no data loss.

Hope this helps.

Here is a good whitepaper on the subject

https://www.oracle.com/technetwork/database/availability/farsync-2267608.pdf


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database