RE: EMC's SRDF vs Oracle DataGuard
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <Smith.Steven@xxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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?
Steve Smith
Desk: 303-231-5499
Fax: 303-231-5696
Other related posts:
