This is Just stuff I find on various echnologies ranging from databases to Cloud related tech. This Blog will have topics and content based on things i learn.
I can also be found at http://www.twitter.com/fuadar

Sunday, February 13, 2011

Dataguard Notes Part 1

Over the recent weeks pretty much most of my time has been spent debugging and working with Dataguard related issues and i thought i'd start this post about some notes
1. Know thy purpose.
Before deciding what type of dataguard environment you want to setup , Make sure you understand the business requirements and plan accordingly. If the purpose is DR only use Physical Dataguard. If the purpose is business reporting , use Logical Dataguard.
2. Understand the Load.
It is very important to understand the logic and the business reason behind the setup. Often people recommend a Dataguard setup without actually working through the requirements. This can lead to a cheaper but totally unusable solution which might require lots of rework . Logical Dataguard is much prone to such issues since users expect it to be up and available for performing read only activities and also expect it to be in sync real-time.
Part 2 will go into some technical details on trying to troubleshoot Dataguard issues and how to identify potiential issues .