Re: Oracle Stream or Golden Gate?

From: Lu Jiang <lu.jiang69_at_yahoo.com>
Date: Tue, 4 Dec 2012 17:28:52 -0800 (PST)
Message-ID: <1354670932.58412.YahooMailNeo_at_web120006.mail.ne1.yahoo.com>

Hi Luis,
 
Thanks for sharing and the details. Now I have more reason to use Golden Gate. Although it needs license fee, it requires less maintenance would save our time. Time is money ^_^  
Regards,
Lu
 

---

From: Luis <lcarapinha_at_gmail.com>
To: lu.jiang69_at_yahoo.com
Cc: "curtisbl_at_gmail.com" <curtisbl_at_gmail.com>; list <oracle-l_at_freelists.org> Sent: Tuesday, December 4, 2012 5:05 PM
Subject: Re: Oracle Stream or Golden Gate?

Hi Lu,
I've been working with Oracle Streams (11.2.0.3) on a bi-directional environment with 2 or more databases. It takes a lot of effort to get it right, but as soon as you setup all the correct rules it works fine, performance is quite decent also in my env. Some things you need to know:

1) Sequences current value is not propagated to target database (it was a BIG issue for me).
2) Supplemental logging is mandatory. More attention is required for tables without PK/FK or UNIQUE INDEXES
3) Conflict handling is HARD!  Took me a lot of time to learn how they work and how to solve it when Oracle can't resolve conflicts
4) DML and DDL replication works as expected, but once you find a conflict you need to figure out how to create a conflict resolution rule or handle it manually everytime it happens..
5) Streams will not get more new features on 12c (or 11g). Oracle is advertising GG.
6) GG was not an option for me because of the price.

Regards,
Luis Marques

On Tue, Dec 4, 2012 at 9:44 PM, Lu Jiang <lu.jiang69_at_yahoo.com> wrote:

Bobby,
> 
>Thanks for the useful information. I will go with Golden Gate.
>Currently we will just use Golden Gate for one way replication (may use it for other purpose in the future). How difficult is the implementation? Are there any good books, or the installation guide / Oracle documentation is good enough?
>Was it a pain to handle DDL with Oracle Stream?
> 
>Thanks,
>Lu
> 
>
>________________________________
>From: Bobby Curtis <curtisbl_at_gmail.com>
>To: lu.jiang69_at_yahoo.com
>Cc: list <oracle-l_at_freelists.org>
>Sent: Tuesday, December 4, 2012 2:57 PM
>Subject: Re: Oracle Stream or Golden Gate?
>
>
>Lu,
>
>Good question.  I have pulled away from Oracle Streams and gone more
>towards Golden Gate.  Depending on what you want to do with Golden Gate,
>it is the better solution.  Deploying Golden Gate for just a disaster
>recovery or migration purposes is fairly quick unless you need to
>replicate DDL statements (simple but takes a little longer).  Golden
>Gate is flexible and can be used for many different use cases.
>
>There is always maintenance with any technology you choose to go with. 
>Golden Gate, I've found it mostly to be based on the needs of the end
>user.  Trail files could take some filesystem space if not applied
>quickly or the extract/replicat processes abend. Overall, I would say
>that Golden Gate would provide less maintenance.
>
>I'll answer any questions you might have if more details are needed. 
>Just let me know.
>
>Regards
>
>Bobby L. Curtis
>(e): curtisbl_at_gmail.com | (t): @curtisbl294
>http://dbasolved.com
>
>On 12/4/2012 2:47 PM, Lu Jiang wrote:
>> Hi all,
>> 
>> I have to pick one of them - Oracle Stream or Golden Gate for our reporting system (I actually like logical standby since looks we only need an exact copy of prod database for reporting purpose, less maintenance, but it is not an option). The replica reporting db will be a RAC database and reside in the same cluster and same nodes as the prod database.
>> 
>> Have done Oracle multi-master advance replication implementation several years ago, I knew it needs a lot of maintenance. Think Oracle Stream had a lot of improvement but I never tried.
>> 
>> Have read some articles comparing these two replication products. It seems Oracle stream has no future, Oracle Golden Gate is expected to be the main replication method in the future. Also we may use Golden gate for no down time migration.
>> 
>> Could anyone used Oracle Stream and Golden Gate shed some light? Which one is better in terms of deployment and maintenance? Less maintenance is important since we are so busy.
>> 
>> Thanks,
>> Lu
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Cumprimentos, 
Luís Marques
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 05 2012 - 02:28:52 CET