RE: Replicating Live Oracle DataFiles/LUNs to remote site via SAN tool?

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>, Richard.Goulet@xxxxxxxxxxx
  • Date: Wed, 2 Sep 2009 07:27:49 +0000 (GMT)

I heard 11gR2 ASM can do snapshots woudl be interesting hwo it would compare 
with SAN based replication

--- On Thu, 27/8/09, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> wrote:

From: Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>
Subject: RE: Replicating Live Oracle DataFiles/LUNs to remote site via SAN tool?
To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Date: Thursday, 27 August, 2009, 4:05 PM

         1) For you it's extremely easy to set up.  You just sit back and watch 
the Unix admin do all of the work. I like that.
         2) If there is a problem with the solution your not on the carpet for 
         3) If and when you upgrade of patch the remote system gets the update 
as well, less work.  Assuming that ORACLE_HOME is replicated as well.
        1) If the DR database doesn't start for any reason you know who's to 
blame.  You of course.
        2) If your database expands onto new luns they may or may not be 
included in the replication works.
        3) Adding a new lun in some products requires downtime because you have 
to rebuild the remote system.
        4) You need a LARGE network pipe between the sites and it HAS to be 
        5) If you do have a network issue between the sites your database can 
hang because the replication software is bogged down.  Not likely to occur 
immediately or in the event of a short outage, but longer outages will get 
there sooner or later.
    As for expense, yes these solutions are expensive.  There's the cost of two 
identical SANs, the network connection, and the software.  But Oracle EE isn't 
a drop in the bucket either.  On the other hand if you've already got EE then 
replicating via Data Guard  may be more cost effective, especially if your not 
using the standby database as a reporting instance and the network pipe isn't 
large or reliable.
Dick Goulet 
Senior Oracle DBA 
PAREXEL International 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Thursday, August 27, 2009 9:43 AM
To: 'Oracle L'
Subject: Replicating Live Oracle DataFiles/LUNs to remote site via SAN tool?

Any of you guys/gals replicating LIVE datafiles from one SAN to another in a 
remote location?
We're looking at using HP's CA tool to replicate LIVE datafiles across a WAN to 
another SAN.  The replication is block based, so any block that changes on the 
primary LUN is immediately replicated to the remote LUN at the remote site.
Is anyone doing anything similar to this?  Pros? Cons?  I have a hard time 
imagining that this is a good idea but perhaps it is doable.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


Other related posts: