Dell uses Oracle Data Guard 10 g Release 2 and related Oracle Database capabilities to utilize their physical standby databases for testing and other purposes that require read-write access to the standby database. This has increased the return on investment in Disaster Recovery systems. As important, the increased accuracy of test results has dramatically decreased business risk when changes must be made to their production environment. Dell has implemented via a manual process the near equivalent of the new Data Guard Snapshot Standby feature delivered in Oracle Database 11 g. Oracle Database 10 g users can follow the steps provided in this case study to realize the benefit of a snapshot standby database without having to wait for Oracle Database 11 g to be production in their shops.
About the Author: Sreekanth Chintala works for Dell Inc., and is an OCP Certified DBA who has been using Oracle technologies for 10 years and has over 15 years of I/T experience. Sreekanth specializes in Oracle High Availability, Disaster Recovery solutions and developing emerging Oracle technologies for Dell IT. Sreekanth received his Masters (M.S) from West Virginia University, Master of Technology (M.Tech) from REC Calicut (India) and a Bachelors degree from JNT University, Hyderabad (India). Sreekanth may be reached at firstname.lastname@example.org. All observations and recommendations made in this case study are those of the author.