OraFAQ Forum: Marketplace » Another replication solution: goldengate

Home » Other » Marketplace » Another replication solution: goldengate

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Another replication solution: goldengate [message #292989]

Thu, 10 January 2008 07:41

debuzna
Messages: 4
Registered: January 2008

Junior Member

A paid solution I'm familiar with from goldengate.com will do this. There's a program that reads from the online and redo archive logs, writes the transaction in a proprietary format to "trail" files, then you can ftp or otherwise move those files to another machine (if target is online the software can automatically deliver the data) to be used as input for the apply process, in which only the change data is applied via SQL. This works for like databases and works across databases. For example, you could ftp these trail files and use the same files as input for Oracle, SQL Server, DB2, etc., across as major OS's regardless of endianess.

-joe

[Updated on: Mon, 14 January 2008 08:51] by Moderator

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #292993 is a reply to message #292989]

Thu, 10 January 2008 08:06

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is this by chance that your IP is owned by goldengate?

This smells SPAM.

Regards
Michel

[Updated on: Thu, 10 January 2008 08:06]

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #292995 is a reply to message #292989]

Thu, 10 January 2008 08:17

debuzna
Messages: 4
Registered: January 2008

Junior Member

Yes I work for goldengate software and it's not spam because it's a valid solution - the only one posted here so far. I also worked for Quest Software and Oracle Corp who have SharePlex and Streams respectively as data replication solutions. The only major player in this space I've not mentioned is Data Mirror (recently acquired by IBM). So there, I mentioned them all. And from my experience, and I've been replicating over 10 years now, the only one I know that will facilitate change data capture to files that can be copied between machines is goldengate.

But don't take my word for it, lookup yourself:

datamirror.com
goldengate.com
oracle.com
quest.com

Good luck!

-joe

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #292996 is a reply to message #292995]

Thu, 10 January 2008 08:30

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You started with:

Quote:

A paid solution I'm familiar with from goldengate.com will do this.

A fair start would be "I like to introduce a product from ... for which I work" and not this one this seems to say you are just a customer.

Quote:

So there, I mentioned them all.

Where?

I don't have time to verify what you said but as you claimed something now I ask: prove it.
Prove this is not just a commercial post but a technical one and post your test cases/benchmarks/papers.

Regards
Michel

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #293667 is a reply to message #292989]

Mon, 14 January 2008 08:42

debuzna
Messages: 4
Registered: January 2008

Junior Member

Michel,

Good advice on intro; you're absolutely correct and I'm happy to comply moving forward.

I not going to give a complete breakdown between architectures but in a respectful attempt to provide a reasonable answer to your proof request I offer this.

From this public link:
http://www.goldengate.com/technology/architecture.html

Anyone can download this data sheet:
http://www.goldengate.com/pdfs/GoldenGate_DataSheet_TDM.pdf

Which states:
GoldenGate Trail Files – GoldenGate Trail Files are part of GoldenGate TDM’s proprietary queuing mechanism and contain the changed data operations in a transportable, platform-independent universal data format.

Generally available Oracle Streams documents will show that queuing occurs in the database. As for the Quest and IBM products a quick scan of their public docs doesn't say either way if this is possible but obviously vendors are compelled to list what they do support, and if they support transportable, platform-independent universal data format files it's likely they'll list something like that up front.

So I could only come up with a link saying we (GoldenGate) support this but nothing either way for the three other main players in this space. Some other links for those interested:

http://datamirror.com/solutions/oracle/default.aspx (papers require a login)
http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&p=1&u=%2Fnetahtml%2FPTO%2Fsearch-bool.html&r=5& f=G&l=50&co1=AND&d=PTXT&s1=datamirror&OS=datamirror&RS=datamirror (insight into how data is sent/received)
http://www.quest.com/documents/list.aspx?searchoff=true&contenttypeid=20&prod=21 (data sheets without login)

My cup is never full so if anyone's got supplementary or contrasting info I'd appreciate it.

Cheers,
-joe

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #358577 is a reply to message #293667]

Tue, 11 November 2008 21:46

dba_oracle
Messages: 2
Registered: November 2008

Junior Member

Well, Joe or whoever you are. If you are trying to present your self as a tech expert and not a cheap sales guy, do some home work
Here at least two more solid products can perform the replication by reading from redo log files directly which you "forgot" to mention.

Sybase Replication Server: http://www.sybase.com/products/businesscontinuity/replicationserver
Wisdomforce Databasesync: http://www.wisdomforce.com/products-DatabaseSync.html

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #415077 is a reply to message #358577]

Fri, 24 July 2009 11:22

debuzna
Messages: 4
Registered: January 2008

Junior Member

These two mentioned are non-players. Sybase was one of the originals but no one uses them anymore outside of Sybase. And wisdom force like many others don't even register.

Trying to be fair, I gave you links the main players. A web pages don't make a product, my fried. Actual customers usage does.

Cheers,
-joe

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #415081 is a reply to message #415077]

Fri, 24 July 2009 11:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Whoa, that was an instant reply! Took you only 8 months. I hope you don't expect your customers to be that patient.

Report message to a moderator

Re: Using Data Pump in Oracle 10g? [message #415108 is a reply to message #415077]

Fri, 24 July 2009 22:32

dba_oracle
Messages: 2
Registered: November 2008

Junior Member

You sound more like a sales rep. Makes your advice worthy nothing

Report message to a moderator

Does anyone have any documentation on goldengate [message #424729 is a reply to message #292995]

Mon, 05 October 2009 12:32

simarjit_2005
Messages: 1
Registered: August 2009

Junior Member

Hi

I am looking for a documentation on working with or getting familiarization with goldengate replication software . Please let me know if there is anything to read on it..

Regards

Report message to a moderator

Re: Does anyone have any documentation on goldengate [message #424735 is a reply to message #424729]

Mon, 05 October 2009 13:01

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about the links and docs already posted?

Regards
Michel

Report message to a moderator

Previous Topic:	VB.NET/C#.NET/ASP.NET Programmer Analyst - Government Position!
Next Topic:	Direct export from Oracle dump files into most popular databases

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 17:33:04 CST 2025