topic Re: Data Guard vs Storage Replication in Disk Enclosures

Data Guard vs Storage Replication

avamar11 — Fri, 16 Oct 2009 12:37:46 GMT

Hi ,
Can any one tell me about a good whitepaper or web link comapring replication using Oracle Data Guard versus Storage Replication (synchronous replication ) .

Thanks in advance.....

Re: Data Guard vs Storage Replication

DogBytes — Fri, 16 Oct 2009 13:47:18 GMT

http://www.oracle.com/database/active-data-guard.html

http://h18000.www1.hp.com/products/storage/software/conaccesseva/index.html
or
http://h18006.www1.hp.com/products/storage/software/continuousaccess/index.html

If you're just replicating Oracle data, I would lean toward Data Guard because you can actually do reporting off of the DR database. If you want a simple and reliable method of replication many types of data, I would go with CA (hardware replication) but be aware your replicated data is offline until you do a failover.

What type of storage array do you have? EVA, XP or ??

Re: Data Guard vs Storage Replication

avamar11 — Fri, 16 Oct 2009 14:41:54 GMT

I am having CA Synchronous on XP12000 .Can you please elaborate more on benifits of Storage replication .....

Thanks....

Re: Data Guard vs Storage Replication

DogBytes — Fri, 16 Oct 2009 15:22:53 GMT

CA doesn't know about the application, all changes are replicated to the target. This ideal for HP-UX, VMWare, and clustering solutions like MetroCluster.

If your target site has users who would want to run queries against a standby database, or if you want protection from data corruption, you may want to consider Oracle's product.

Re: Data Guard vs Storage Replication

DogBytes — Fri, 16 Oct 2009 15:27:41 GMT

Here's some more info on Data Guard:

http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html