Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • restarting network in linux Linux/Unix
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • SQL Server: How to see current transactions or requests SQL Server
  • Very Good Oralce Internal Tuning Book Oracle
  • Rman Notes -1 Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • Guide to Linux System Command Mastery Linux/Unix
  • cp_filesystem.sql Oracle
  • Find All internal Parameters Oracle
  • V$INSTANCE of Oracle in MYSQL MYSQL
  • SYSOPER Mystery Oracle
  • Absolute file number and relative file number Oracle
  • Default User Profile Oracle
  • TRUNCATE Privs Oracle

Difference between SYNC and AFFIRM

Posted on 27-Jan-2010 By Admin No Comments on Difference between SYNC and AFFIRM

LGWR SYNC AFFIRM in Oracle Data Guard is used for zero data loss. How does one ensure zero data loss? Well, the redo block generated at the primary has to reach the standby across the network (that’s where the SYNC part comes in – i.e. it is a synchronous network call), and then the block has to be written on disk on the standby (that’s where the AFFIRM part comes in) – typically on a standby redo log.

Can you have LGWR SYNC NOAFFIRM? Yes sure. Then you will have synchronous network transport, but the only thing you are guaranteed is that the block has reached the remote standby’s memory. It has not been written on to disk yet. So not really a zero data loss solution (e.g. what if the standby instance crashes before the disk I/O).

To sum up -> LGWR SYNC AFFIRM means primary transaction commits are waiting for ntk I/O + disk I/O acks. LGWR SYNC NOAFFIRM means primary transaction commits are waiting for ntk I/O only.

Oracle, rman-dataguard

Post navigation

Previous Post: useful dg links
Next Post: oracle fast start failover best practice

Related Posts

  • find_cons.sql Oracle
  • TRUNCATE Privs Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • longtx.sql Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 10g oem configuration Oracle
  • secure crt settings Linux/Unix
  • JSON/XML Types in Oracle Oracle
  • login.sql Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • nfs mount command Linux/Unix
  • SAN Linux/Unix
  • Looping for remote servers and find its database from oratab file. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme