From oracle-l-bounce@freelists.org Tue Sep 20 10:15:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8KFFKML010587 for ; Tue, 20 Sep 2005 10:15:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8KFFG6H010567 for ; Tue, 20 Sep 2005 10:15:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E11D41EF084; Tue, 20 Sep 2005 10:15:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23341-02; Tue, 20 Sep 2005 10:15:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A5001EEF55; Tue, 20 Sep 2005 10:15:04 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=BTEKyfzUYSGPaFW7Kd13/WQT47rjq7nk4d6Y3EfGDYd8nt1Vtflz4TBGkjnCAt9xHoNT5Soe99Wk+R2bAnCXDSkq6OGDpR/KUIi7/ERmv5VDbGnlA6ZoVDubqV0NHDbGbKDG05awZwjIz0k5XRLVyi05pPIy4MnyIzCfVvjWlzk= Message-ID: Date: Tue, 20 Sep 2005 11:13:12 -0400 From: Sandeep Dubey To: makbo@pacbell.net Subject: Re: Replication question Cc: oracle-l In-Reply-To: <43302198.9080404@pacbell.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_398_20261174.1127229192123" References: <43302198.9080404@pacbell.net> X-archive-position: 25686 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dubey.sandeep@gmail.com Precedence: normal Reply-To: dubey.sandeep@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_398_20261174.1127229192123 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, the databases are exactly identical - same scripts to create=20 tablespace, tables, indexes, views, whatever. We are currently in 9i.=20 Replication should be near real time - 15 to 30 minutes are acceptable but= =20 not overnight. I can create db link from C to A or B. A and B are remote databases while = C=20 is in our data center.=20 So how do I do it. Create readonly snapshots for A and B separately. How do= =20 you merge in to C's main table? Or is it possible to have C's table as=20 updateable snapshot which is also a table for its application?=20 Sandeep=20 On 9/20/05, Mark Bole wrote:=20 >=20 > Sandeep Dubey wrote: > > Hi, > > > > I have three identical databases say A, B and C. >=20 > Identical tablespaces? Identical schemas? Identical tables, keys, > constraints? >=20 > I want to replicate > > from A and B to C. Meaning C will have its own data plus the data from = A > > and B. I can not create a db link from A or B pointing to C for securit= y > > reasons. >=20 > Create dblinks in C for A and B instead. >=20 > Also handing over the stream_admin password of C to A and B to > > push their changes through streams is not very good idea. I can not hav= e > > multimaster replication as C is not sending its change to A or B. > > > > Please suggest how this can be done? >=20 > You didn't mention version. Transportable tablespaces? Export/Import? > Log Miner? >=20 > Is any one using streams to capture > > data from remote database to your data center? Seems like streams push > > technology is a security hole. >=20 > Any method of taking data out of one database and loading it into > another is going to have security issues, especially if you want it to > run unattended. Your management needs to decide what level of risk they > will accept to achieve a certain level of benefit. >=20 > -- > Mark Bole > http://www.bincomputing.com >=20 >=20 >=20 > -- > http://www.freelists.org/webpage/oracle-l > ------=_Part_398_20261174.1127229192123 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Yes, the databases are exactly identical - same scripts to create tabl= espace, tables, indexes, views, whatever.  We are currently in 9i= . Replication should be near real time - 15 to 30 minutes are acceptable bu= t not overnight.
 
I can create db link from C to A or B. A and B are remote databases wh= ile C is in our data center. 
So how do I do it. Create readonly snapshots for A and B  se= parately. How do you merge in to C's main table? Or is it possible to have = C's table as updateable snapshot which is also a table for its applica= tion? 
 
Sandeep 

 
On 9/20/05, = Mark Bole <makbo@pacbell.net> wrote:
Sandeep Dubey wrote:
> Hi,=
>
> I have three identical databases say A, B and C.

Id= entical tablespaces?  Identical schemas?  Identical tab= les, keys,
constraints?

I want to replicate
> from A and B to C. Mean= ing C will have its own data plus the data from A
> and B. I can not = create a db link from A or B pointing to C for security
> reasons.

Create dblinks in C for A and B instead.

Also handing over t= he stream_admin password of C to A and B to
> push their changes thro= ugh streams is not very good idea. I can not have
> multimaster repli= cation as C is not sending its change to A or B.
>
> Please suggest how this can be done?

You didn't men= tion version.  Transportable tablespaces?  Export/Impor= t?
Log Miner?

Is any one using streams to capture
> data fr= om remote database to your data center? Seems like streams push
> technology is a security hole.

Any method of taking data ou= t of one database and loading it into
another is going to have security = issues, especially if you want it to
run unattended.  Your man= agement needs to decide what level of risk they
will accept to achieve a certain level of benefit.

--
Mark Bo= le
http://www.bincomputing.com



--
http://www.freelists.org/webpage/oracle-l

------=_Part_398_20261174.1127229192123-- -- http://www.freelists.org/webpage/oracle-l