{"id":8310,"date":"2020-04-15T16:02:52","date_gmt":"2020-04-15T16:02:52","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/oracle-data-guard-far-sync-zero-data-loss\/"},"modified":"2026-11-03T19:29:33","modified_gmt":"2026-11-03T19:29:33","slug":"oracle-data-guard-far-sync-zero-data-loss","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/oracle-data-guard-far-sync-zero-data-loss\/","title":{"rendered":"Oracle Data Guard Far Sync:- zero data loss"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

In this blog, I discuss an Oracle\u00ae for Data Guard feature, Far Sync. Oracle designed this new configuration to support synchronous redo transport between the primary and standby database, which are physically far apart. This technique in Oracle 12c ensures zero data loss and protection for primary databases located at any distance.<\/p>\n

The feature accepts a redo from a primary database and ships the redo to the standby. Because the Far Sync instance doesn\u2019t contain datafiles, you cannot open it as a primary or a standby in the future. The Far Sync instance minimizes impact on commit response time, reducing that time to an acceptable threshold value with higher data protection.
\n <\/p>\n

 Architecture<\/strong><\/p>\n

The following image shows a sample of Far Sync architecture:<\/p>\n

\"oracle<\/p>\n

Image Source<\/em><\/a> <\/p>\n

 Configuration<\/strong><\/p>\n

To configure Far Sync, perform the following steps.<\/p>\n

1. Create a Far Sync control file from a primary and copy it to the Far Sync server<\/strong><\/p>\n

Run the following code:<\/p>\n

    ALTER DATABASE CREATE FAR SYNC INSTANCE CONTROLFILE AS \u2018\/home\/oracle\/farsync.ctl’;<\/em><\/p>\n

 2. Mount the Far Sync instance with the Far Sync control file you created<\/strong><\/p>\n

Select the Far Sync role by running the following code:<\/p>\n

    SQL> select database_role from v$database;
\n    DATABASE_ROLE
\n    \u2014\u2014\u2014\u2014\u2014-
\n    FAR SYNC<\/em><\/p>\n

 3. Set parameters for the primary database<\/strong><\/p>\n

On the primary database, add the following parameters to the init file:<\/p>\n

    LOG_ARCHIVE_CONFIG=’DG_CONFIG=(oraprimary,orafarsync,orastandby)’ scope=both;
\n    LOG_ARCHIVE_DEST_2=’SERVICE=farsync SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orafarsync’
\n    LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oraprimary<\/em><\/p>\n

 4. Set parameters for Far Sync<\/strong><\/p>\n

In the Far Sync instance, add the following parameters to the init file:<\/p>\n

    LOG_ARCHIVE_CONFIG=’DG_CONFIG=(primary,farsync,standby)’
\n    LOG_ARCHIVE_DEST_2=’SERVICE=standby ASYNC VALID_FOR=( STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=orastandby’
\n    LOG_ARCHIVE_DEST_1=’LOCATION= USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orafarsync’<\/em><\/p>\n

 5. Set parameters for the standby database<\/strong><\/p>\n

On the standby database, add the following parameters to init file:<\/p>\n

    LOG_ARCHIVE_CONFIG=’DG_CONFIG=(primary,farsync,standby)’
\n    LOG_ARCHIVE_DEST_2=’SERVICE=primary ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oraprimary’
\n    LOG_ARCHIVE_DEST_1=’LOCATION= USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orastandby’<\/em><\/p>\n

Conclusion<\/strong><\/p>\n

The Far Sync feature helps to configure a zero-data-loss long-distance standby database for organizations. It also helps to overcome inhibitions and win the confidence of enterprises that think zero data loss can’t be real and worry about database performance.<\/p>\n

A Far Sync instance also offloads from the primary database the overhead of resolving gaps in the archived logs received by the remote standby database. The instance can conserve WAN bandwidth by performing redo transport compression without impacting primary database performance (off-host compression).<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Data Guard Far Sync:- zero data loss<\/p>\n","protected":false},"author":2,"featured_media":8312,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26710","content_type":"blog","created_by":"10130","authored_on":"2024-03-14T16:02:52+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Vivek Dhiman. Oracle Database Administrator, Rackspace Technology ","seo_description":"Discover the benefits of Oracle Data Guard Far Sync feature for zero data loss and protection. Support synchronous redo transport.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26710-insights_image-oracle-technical-blog-1-insights_0.jpg","field_partners":"Oracle","rxt_platforms":"Oracle","product":"","publisheddate":"2020-04-15T16:02:52","rxt_solutions":"Data, Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Zero Data Loss with Oracle Data Guard Far Sync | Rackspace Technology","field_topics":"Data","field_slug":"oracle-data-guard-far-sync-zero-data-loss","footnotes":""},"categories":[178],"tags":[189,206,204],"class_list":["post-8310","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-data","tag-oracle","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=8310"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8310\/revisions"}],"predecessor-version":[{"id":10030,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/8310\/revisions\/10030"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/8312"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=8310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=8310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=8310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}