Note : The focus of this blog is not Data Guard.

We found ourselves in complex situation while implementing Data Guard.  Since our SLA’s are in Milli seconds , Our response times jumped 400% when we implemented synchronous physical Data guard;  All best practices were followed  as per Oracle. See metalink Note:387343.1 and Data Guard Redo Apply and Media Recovery Best Practices 10gR2

Introduction of Data Guard introduced data guard related wait events but log file sync increased more than 10  times indicating  that writes to  standby redo logs were consuming more time. We have a very talented storage team. In the 1st phase, we striped the standby redo log files(1GB)  across 8 disks  in such a way that data only resides on the tracks closer to the drive head. This reduced  the impact of  data guard considerably and helped us to maintain the SLA’s.

In the next phase , we used raw devices for redo logs and control files. With raw devices , Our response times were kind of close to architecture without Data guard.

Our Environment

Database : 10.2.0.3

OS : AIX5.3

Storage: DMX

thanks

Tagged: data guard performance, oracle, raw devices, redo logs, standby redo logs