Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, alan.

Asked: June 14, 2017 - 2:43 pm UTC

Last updated: June 19, 2017 - 3:04 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hello,
I have a question about sync attribute of ADG on 11.2.0.4.
Oracle doc says that transaction can commit only if primary db receive the ack from all destinations which set for sync.
But our application wants commit as soon as posible when primary db recieve ack from just one destination,not all,and we dont want set async attribute.
How can we design this ADG?

Thank you!
alan

and Connor said...

Check out DATA_GUARD_SYNC_LATENCY

https://docs.oracle.com/database/122/REFRN/DATA_GUARD_SYNC_LATENCY.htm#REFRN-GUID-A0965F0B-608C-4B68-85D1-9F14EFC191CC

It might be useful to achieve what you're after.

From the docs:

"Note:
You could also set the database initialization parameter, DATA_GUARD_SYNC_LATENCY, which is global for all synchronous standby destinations. It defines the maximum amount of time (in seconds) that the primary database may wait before disconnecting subsequent destinations after at least one synchronous standby has acknowledged receipt of the redo.

For example, suppose you have three synchronous standby destinations and you set DATA_GUARD_SYNC_LATENCY to a value of 2. If the first standby acknowledges receipt of the redo immediately, then the primary database waits no longer than 2 seconds for the other two standbys to respond. If one or both respond within 2 seconds, then they are maintained as active destinations. Destinations that do not respond in time are marked as failed. In both cases the primary remains in zero data loss protection mode because one synchronous standby has acknowledged receipt of the redo. Any failed synchronous standbys are reconnected as normal after the number of seconds specified for the REOPEN attribute have passed"

Rating

  (1 rating)

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

Comments

tan alan, June 19, 2017 - 1:03 am UTC

Hi,
The DATA_GUARD_SYNC_LATENCY is useful,but is's for 12c,our database is 11.2.0.4.



Connor McDonald
June 19, 2017 - 3:04 am UTC

Looks like its time to upgrade then