Oracle Database DR replication and consistency
Posted on 2014-07-29
I am a quite new DBA with some years experience in IT field and I need your knowledge and help to resolve my issue.
I have a task to plan our future DB architecture which will include projects running with Oracle Databases and SQL Server Databases, and to make it with very good HA and DR levels.
My most important question is:
Which technology or what kind of configuration could I use to achieve Disaster Recovery Site, which could take ownership of the Oracle Databases and SQL Server Databases with minimal downtime and cost?
Both Primary and DR site have SAN - IBM SVC.
The main issue for me is how to achieve Database consistency with async SAN Replication for a low cost or best for the money.
What is known is:
Oracle DB is Standard Edition 11g with possible upgrade to 12c, currently running on Windows Server 2008 R2 EE.
SQL Server is 2008 Enterprise Edition running on Windows Server 2008 EE SP2.
I did quite a lot research and it seems that in order to achieve such DB consistency for Oracle, I have to use DataGuard or GoldenGate, which are separate licenses, and not Options for Standard Edition and for additional cost (quite expensive).
Main Question: Is such thing possible with Oracle Streams when configuring it for whole database replication?
Probably another possibility is to use our license of VMware vSphere 5.5 Enterprise and use the feature Site Recovery Manager, but I saw somewhere that it is paid additional on the count of VMs that could be able to failover.
Is it possible at all, if we virtualize all Oracle instances and datafiles?
Of course, because we have SAN replication, we maybe could use the features of IBM SVC - for example GlobalMirror and achieve Oracle DB consistency. But as I understand it costs additionally every month, something as subscription.
For SQL Server DBs my idea is to use Database Mirroring in async for the DR site.