Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.68.MISMATCH!feeder.news-service.com!newshub.sdsu.edu!flph200.ffdc.sbc.com!prodigy.net!flph199.ffdc.sbc.com!prodigy.com!flpi107.ffdc.sbc.com!nlpi065.nbdc.sbc.com.POSTED!28110ad8!not-for-mail From: Michael Austin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070802 SeaMonkey/1.1.4 MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: What is the best way to replicate few tables between 2 Oracle 10g severs ? References: <1b53dd4e-96fa-452f-b7bd-1f49c87a255d@v23g2000pro.googlegroups.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 48 Message-ID: <0T1Gl.24149$c45.22894@nlpi065.nbdc.sbc.com> NNTP-Posting-Host: 70.230.253.40 X-Complaints-To: abuse@prodigy.net X-Trace: nlpi065.nbdc.sbc.com 1239984700 ST000 70.230.253.40 (Fri, 17 Apr 2009 12:11:40 EDT) NNTP-Posting-Date: Fri, 17 Apr 2009 12:11:40 EDT Organization: at&t http://my.att.net/ X-UserInfo1: TSU[@SBE@ZR[SRPX@HHV_WTATB]^PUDO@HTHOCULF@^PGDTFOG[]FACY@TZZXQ[KS^ESKCJLOF_J_NGAWNTG^_XGTNTAHULK[X[NRTC@G\P^PLT_OCBRHUO@@TBQZDZMHD[YZ@NLXQXIWMOSXT_KOLK^^CXFF\WHMI^C@EGA_[FXAQ@E^TGNMUXGYNS[QQVL Date: Fri, 17 Apr 2009 11:13:30 -0500 Xref: news.cambrium.nl stevedhoward@gmail.com wrote: > On Apr 16, 2:50 am, Veeru71 wrote: >> We need to replicate (1-way) a bunch of tables from Server-A to >> Server-B in close to real-time. >> Server-B is located in a foreign country. >> >> Apporx. # of tables to be replicated : 50 (size : 50 GB) >> Approx amount of data that gets replicated (changed data) per day : >> 100 MB >> Oarcle Versions : 10g, Solaris >> >> Constraints (due to some security reasons): >> - Server-B SHOULD NOT have any DB-Links to connect to Server-A >> - No UserId/Password of Server-A should be used anywhere in scripts/ >> code/config files, etc on Server-B. >> >> What is the best way to achieve this ? Initially we thought of using >> Matreialized Views, but because of the above constraint, it may not >> be feasible. >> >> Do you think Oracle Streams would work ? Would it be an over-kill ? >> Any other options ? >> >> Thanks for your help. > > For the amount of data you are talking about (100MB per day), you can > probably get away with just triggers on the DB A tables that insert > into DB B. > > The streams option always bothers me, personally. We used it to > migrate a fairly large database last year on what was then 10.2.0.3 > from AIX single node to Linux RAC, and we had all kinds of weird > issues, about 20 one-offs to apply, you name it. We were beginners > with streams, so I'm sure we were inefficient in how we set it up, but > I wouldn't call it "easy" to configure, especially with database that > generate a lot of redo. > > YMMV, > > Steve With the security requirement of near real-time (not yet quantified here) no pwd in config files and no dblinks, you are going to be hard-pressed to find any solution that does not require a pwd for authentication. Configuring some sort of SSL with public key exchange might be of some help (Streams can do SSL - just not sure where exactly the pwd/key is authenticated - and have not had to do this just yet).