RE: EMC's SRDF vs Oracle DataGuard
Date: Wed, 23 Jan 2008 17:59:03 -0500
You can probably make it work. See Wilton's comments.
Beyond that, remember that with a physical standby it is possible to temporarily cancel remote recovery and clone/rename/open point-in-time, which would give you a refreshed point in time load and reporting database from which to feed your datawarehouses. And notice that the location is your remote location, so you will thereby utilize your production scaled environment that is otherwise mostly empty just applying redo logs and a few misc. tasks.
This feeds the natural triage of OLTP being fully serviced quickly in a site disaster at the cost of the DW databases, which usually fits with the economic survival model if folks plan through the logistics of running the business when the primary IT site (often corporate headquarters) is inoperable.
If that triage does not fit your model, then you simply add the extra horsepower to the recovery site, but you still do not have to totally duplicate it.
Good luck. Thinking through the entire business logistics plan to determine requirements should be upstream from choosing the technical methodology of executing the failover. I admit to being quite biased toward physical standbys since they have worked well since before Oracle called it a product and it essentially is as reliable as Oracle's recovery model. Since at least 6.0.36 that has been very reliable indeed.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Smith, Steven K - MSHA
Sent: Wednesday, January 23, 2008 10:53 AM To: oracle-l
Subject: EMC's SRDF vs Oracle DataGuard
We are in the process of installing two EMC DMX-3 disk arrays. One local and one remote. (1000+ miles distant)
We have a requirement to have the production OLTP and warehouse databases standby in the remote location. Not real time, but close.
We are investigating the use of EMC's SRDF in place of data guard to maintain the remote Oracle environments. The main reason we are leaning this way is because the warehouse is fed from the oltp instance (materialized views) in addition to 4 or 5 outside sources. We can replicate the entire database/load/source files/etc environments and have a setup 'ready to start' with minimal modifications on our part.
Does anyone have experience maintaining standby databases using SRDF? Is EMC selling me a bill of goods?
Fax: 303-231-5696Received on Wed Jan 23 2008 - 16:59:03 CST