Link to home
Start Free TrialLog in
Avatar of Mushfique Khan
Mushfique Khan

asked on

Is Oracle Golden Gate a DR solution?

Hi gurus,

Had a discussion with Oracle folks and he said that Oracle Golden Gate is a DR solution, where as I don't agree.

Bringing it here, so can see, what others have to say, obviously along with justification.

Regards
MK
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Yes, Golden Gate is a DR solution.  It allows for complete replication between two or more servers.

What makes you think it isn't a DR solution?
Avatar of Mushfique Khan

ASKER

thanks ... let's wait for others too, where as Oracle said in its own paper:

Oracle GoldenGate is Oracle’s full-featured replication solution designed to address a wide range of requirements. GoldenGate maintains a synchronized logical copy of a production database that is open read-write at all times. A GoldenGate replica, for example, can offload reporting applications that require read-write database access or can be used to load-balance read-write workloads using multimaster replication. Increased flexibility, however, is accompanied by several trade-offs for data protection and operational simplicity compared to Active Data Guard. GoldenGate is used for disaster recovery by customers who accept these trade-offs in return for its additional flexibility.

http://www.oracle.com/technetwork/database/availability/disaster-recovery-2526839.pdf
What makes you think Golden Gate isn't a DR solution?
I'd like to ask the very same question: What makes you think Golden Gate isn't a DR solution?

Btw: If Golden Gate should be too expensive and you're trying to find other means to perform such things, you may want to take a look at http://www.dbvisit.com/ (and their products) ;-)
>>and you're trying to find other means

There are many ways you can do it outside of official Oracle products.  Before Data Guard, you could do pretty much the same thing yourself.

The issue you have is when it comes time for Oracle to support you when something bad happens.  If you go with a 3rd party product or your own invention, you would probably want to make sure Oracle will support it.
basically we are inclined towards Active Data Guard or even Data Guard/Standby is fine too, for a pure pure MAA

please advise.
Active Data Guard is built on top of Golden Gate. If you don't consider Golden Gate a DR solution then you might not like Active Data Guard.

What solution you pick is entirely up to you.  Each has its own positives and negatives. You need to decide which ones meet your specific requirements.
ASKER CERTIFIED SOLUTION
Avatar of Abhimanyu Suri
Abhimanyu Suri
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I know they are separate products.

I'll try to find the supporting documentation but many years ago ADG used Streams Replication components to do what it does.  With Streams Replication deprecated, Oracle moved those pieces to utilize GGcomponents.  They are separate products but I'm pretty sure ADG uses some GG features.
Actually, oracle integrated lot of streams packages and procedures, after buying golden gate.

Also, to add, if it is few schema uni directional replication then one can consider Shareplex as well, that works pretty efficiently, and has a wonderful feature of compare-repair. And excellent support.

For active-active, i'd go with GG, not that shareplex doesnt support it, but I have experienced performance issues in uni-directional replication itself
thanks Suri
look at the essence of DR.
can you continue at the DR site when the primary goes down ?

the timeframe in which you can do that is an aspect, but it's really only a detail
GoldenGate is capable of that, so it's a DR solution.


if you take that essence ...
a few pigeons with an USB drive might work too :)
but i would consider at least 2 pigeons !

we used 2 modern pigeons once: planes
but it was for a planned move: europe to us
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>do not agree that OGG is built as a DR solution

http://www.oracle.com/technetwork/database/availability/disaster-recovery-2526839.pdf

Disaster Recovery for Oracle Database
Zero Data Loss Recovery Appliance, Active Data Guard and Oracle GoldenGate

GoldenGate is used for disaster recovery by customers who accept these trade-offs in return for its additional flexibility.

>>Note: The statement DG is built on OGG is a wrong statment whoever said that can confirm with Oracle support

I did clarify what I meant.  I still believe ADG uses some aspects of replication behind the scenes.  I'm going off of conversations I had with Oracle many years ago.  When I get some time, I'm still planning on locating the supporting information.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
However in retrospect I would not like to bet on whether DG uses OGG in the background comment that I gave as it is Oracle and I am not part of that company and they can change their design decisions anytime. So please ignore my comment on that. But on a very logical level I still do believe both would be different.

As for use of components there would sure be some common parts as all kind of replication in Oracle be it queues, streams, golden gate specially integrated capture and replicat they all use buffered queues, redo reading structure etc. So there is bond to be some commonalities in all these replication products from Oracle.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have no idea how old this is but from a quick search, here is what I found:
Oracle Streams and Oracle Data Guard (including Data Guard SQL Apply) are independent features of the Oracle database based on some common underlying infrastructure and technology.

http://www.oracle.com/technetwork/database/features/availability/dataguardstreams-087866.html

Streams and Golden Gate both took advantage of XStream:
https://docs.oracle.com/database/122/XSTRM/toc.htm

It appears that you must license GoldenGate to now use XStream.

I'm guessing it is XStream that Data Guard has in common with the replication products but I cannot confirm this.
Hi slightwv,

Really surprised to see these kinds of replies from a senior person like you ...

"I have no idea how old this is but from a quick search, here is what I found:"

Is this forum for this kind of posts ... don't think so, if you are not sure, you shouldn't be participating and wasting time of others, what do you think, does this makes any sense.

Please ...
I stand by my statement.  I just cannot easily find supporting information.  Oracle normally doesn't publish low level integration of its products and how they work.
@Mushfique: I'd rather calm down if I were you!! Everyone here is trying to help people like you! I don't see any point in getting so rude and offending! If you don't the way things get done here on EE, why don't you just ask someone else?!