Home » Other » Marketplace » Another replication solution: goldengate
Another replication solution: goldengate [message #292989] Thu, 10 January 2008 07:41 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Using Data Pump in Oracle 10g? [message #292996 is a reply to message #292995] Thu, 10 January 2008 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Using Data Pump in Oracle 10g? [message #293667 is a reply to message #292989] Mon, 14 January 2008 08:42 Go to previous messageGo to next message
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
Re: Using Data Pump in Oracle 10g? [message #358577 is a reply to message #293667] Tue, 11 November 2008 21:46 Go to previous messageGo to next message
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
Re: Using Data Pump in Oracle 10g? [message #415077 is a reply to message #358577] Fri, 24 July 2009 11:22 Go to previous messageGo to next message
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
Re: Using Data Pump in Oracle 10g? [message #415081 is a reply to message #415077] Fri, 24 July 2009 11:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Using Data Pump in Oracle 10g? [message #415108 is a reply to message #415077] Fri, 24 July 2009 22:32 Go to previous messageGo to next message
dba_oracle
Messages: 2
Registered: November 2008
Junior Member
You sound more like a sales rep. Makes your advice worthy nothing
Does anyone have any documentation on goldengate [message #424729 is a reply to message #292995] Mon, 05 October 2009 12:32 Go to previous messageGo to next message
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
Re: Does anyone have any documentation on goldengate [message #424735 is a reply to message #424729] Mon, 05 October 2009 13:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about the links and docs already posted?

Regards
Michel
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:
  


Current Time: Thu Mar 28 18:12:19 CDT 2024