DataGuard 12.1 – FastSync and FarSync

From 12c onwards, Data Guard maximum availability supports the use of the noaffirm redo transport parameter. It enables Maximum Availability protection mode at larger distances with less performance impact then before. In “LogXptMode=FASTSYNC” mode, standby database returns receipt acknowledgment to its primary database as soon as redo is received in memory. The standby database does not wait for the Remote File Server (RFS) to write to a standby redo log file.

This is how FastSync set up: Continue reading → DataGuard 12.1 – FastSync and FarSync

Global Data Services (GDS) with Active Data Guard – High Availability

In this blog post, I will talk about how you can perform workload routing across the standby databases based on Database role with GDS. GDS provides this functionality without requiring Oracle Clusterware to be installed. But if clusterware is installed then GDS automatically register the global service to GI home. When role transition happens in Data Guard Broker configuration, GDS relocates the global services automatically as per the role attribute. There is no need to write custom logic or database startup triggers to achieve this behavior. Continue reading → Global Data Services (GDS) with Active Data Guard – High Availability

Oracle Data Guard 12cR1 with Data Guard Broker

The purpose of this blog is to guide you through configuring Oracle Data Guard Fast-Start Failover (FSFO) using Data guard broker with physical standby database.

Oracle Data Guard

Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases. Oracle Data Guard maintains one or many secondary databases as alternatives to the primary production database. Continue reading → Oracle Data Guard 12cR1 with Data Guard Broker