Oracle Database DR replication and consistency

Hello experts,
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.
Veliko DragievAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I'll through this in the pot, we have been recently looking at VMware vSphere vSAN for this purpose.

vSAN datastores shared and replicated between ESXi hosts, using 1 x SSD and 1 x Magnetic HDD minimum for the datastore.

the VM is replicated across the vSAN datastore on Hosts, BUT it does depend on your networking for replication, recommended 10GBe.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Veliko DragievAuthor Commented:
So basically this vSAN is a feature from VMware vSphere 5.5 update 1.
And using it we don't have to use additional IBM Physical SAN replication for the same purpose?

What if we decide to not virtualize Oracle DB servers?
What will help in this case - since DataGuard and GoldenGate are for Oracle Enterprise Edition only?
Could Oracle Streams solve the Replication consistency issue for Hot-Standby between the Sites?
slightwv (䄆 Netminder) Commented:
Oracle marketing is pushing Real Application Clusters and Dataguard for HA and DR setups.

We are using Streams Replication as long as it lasts (It has been deprecated in 12c.  Oracle is making everyone buy Goldengate!).

Streams Replication is included in Enterprise.  Not sure if it is an 'Option' in Standard.

Looks like Basic Replication is included in Standard:

Not sure what features 'Basic Replication' provides or if it will solve your overall requirement.

As far as Oracle databases and VMWare, you need to be aware of Oracle's Support policy:
Support Position for Oracle Products Running on VMWare Virtualized Environments (Doc ID 249212.1)
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

johnsoneSenior Oracle DBACommented:
For an Oracle solution, I don't see why you need Dataguard.  I know they push it, but there certainly isn't a reason that you couldn't script something yourself.

This would only work as a DR solution and not a HA solution.

Essentially set up a secondary log archive destination on the standby server.  Restore a backup to that server, then recover the database until cancel.  Cancel when all logs are applied, then repeat (you only have to repeat the recovery, not the restore).  As long as you never open it, unless you have a disaster, it should be in perfect shape.  Personally, I would make a copy of it and open it to see everything is OK every once in a while, for personal sanity.

If you need the HA ability, you are probably better off with Enterprise Edition.
Veliko DragievAuthor Commented:
Sounds like an idea, but is this really a hot standby database. Probably with some scripts and so I could achieve that.

For HA, I am going to use Oracle Fail Safe, since we are on Windows Server and we will use the clustering that Windows offers.
For Oracle Standard Edition, RAC is also an option, but it supports a Cluster only of 4 Sockets in total.

Mainly I am interested how to achieve Database consistency, if we replicate the SAN, where the production DB will stay. Of course Oracle Streams does not provide the functionality of automatic failover or something like that to be hot standby, but it could help for the DB consistency I guess.
johnsoneSenior Oracle DBACommented:
Yes, it is a physical standby.  However without dataguard, you may have to do some things manually.

I don't believe that the managed recovery mode would be available.  Basically, all you do is:


Essentially do that every day and it won't be that far behind.  You could do it as often as you wanted.  The recover database will essentially stop when it runs out of archives and as long as you don't open it, the database will still be in a state that recovery can continue with the next set of logs.

You need to have checks in place so that you are sure it is progressing through the recovery and no archives are being missed.
Veliko DragievAuthor Commented:
Seems that from VMware point of view - the first comment could be the solution.

About the physical standby - this is what we have now. But I think this is kind of cold-standby setup.
I am not sure if it is robust enough for Disaster Recovery Site.
I think that Oracle Streams offer the replicated DB to be in read/write state and this could be a benefit when Disaster switchover, because the failover will be only on IP level at DNS...maybe.

Unfortunately Oracle Streams offer only Sync mode for Oracle Standard Edition and there are quite a lot restrictions for using it as DR solution for replication.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.