Re: Replication question
- From: Sandeep Dubey <dubey.sandeep@xxxxxxxxx>
- To: makbo@xxxxxxxxxxx
- Date: Tue, 20 Sep 2005 13:23:38 -0400
Can anyone present a solution please?
Sandeep
On 9/20/05, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote:
>
> Yes, the databases are exactly identical - same scripts to create
> tablespace, tables, indexes, views, whatever. We are currently in 9i.
> Replication should be near real time - 15 to 30 minutes are acceptable but
> not overnight.
> I can create db link from C to A or B. A and B are remote databases while
> C is in our data center.
> So how do I do it. Create readonly snapshots for A and B separately. 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 application?
> Sandeep
>
> On 9/20/05, Mark Bole <makbo@xxxxxxxxxxx> wrote:
> >
> > Sandeep Dubey wrote:
> > > Hi,
> > >
> > > I have three identical databases say A, B and C.
> >
> > Identical tablespaces? Identical schemas? Identical tables, keys,
> > constraints?
> >
> > 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
> > security
> > > reasons.
> >
> > Create dblinks in C for A and B instead.
> >
> > 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
> > have
> > > multimaster replication as C is not sending its change to A or B.
> > >
> > > Please suggest how this can be done?
> >
> > You didn't mention version. Transportable tablespaces? Export/Import?
> > Log Miner?
> >
> > Is any one using streams to capture
> > > data from remote database to your data center? Seems like streams push
> >
> > > technology is a security hole.
> >
> > 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.
> >
> > --
> > Mark Bole
> > http://www.bincomputing.com
> >
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
>
>
Other related posts:
