Raw Devices still rules the roost

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

Advertisements

Tagged: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: