Taylor, Chris David wrote,on my timestamp of 27/08/2009 11:42 PM:
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.
Wouldn't have a clue about the HP solution. Replicating our DW db at the moment using EMC's Clarion synchronous replication over a dark fibre network to a DR site. 1.5TB size. The major determinant for it working is to have ALL luns for your db in one single synchronous replication group. More than one group and you'll have a corrupt replicated db. Synchronous SAN replication involves a performance penalty on ALL writes, not just data/index writes. Ie: temp and undo, all get written to both sites. That means: wide pipes needed. Ours does 400MB/s aggregate total and is *just* enough at the moment.
About to start exploring a Dataguard alternative in September, to reduce the amount of data we have to send. The cost of upgrading that 400MB/s pipe is stratospheric, while with DG we only have to send 500GB of logs a day and we can wear a small delay in synch. Means maximum performance option of DG is fine.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx -- http://www.freelists.org/webpage/oracle-l