Re: Advanced Replication combined with Oracle Parallel Server

Martin

The replication in the original message was Advanced Replication, which in Oracle terms is done via triggers. Standby database is what Oracle uses to perform log based replication (if you want to think of it that way), and it can be done in OPS as well.

HTH. Pete

Martin Haltmayer wrote:

> I am not familiar with replication, but are you talking about
> replication by sending redolog archives to the other instance or are you
> talking about replication by triggers?
>
> If you are replicating by sending redologs I can imagine there are
> problems as you have to send two redo log threads to the destination
> instance and that Oracle cannot easily determine the processing order of
> redolog entries.
>
> Martin
>
> mjwalsh_at_hotmail.com wrote:
> >
> > Hi
> >
> > has anybody implemented Advanced Replication in an Oracle Parallel
> > Server environment. If so I would be interested to know what problems
> > if any you ran into and if there are any special considerations over
> > and above Advanced Replication in a single instance environment.
> >
> > We have a primary site running a Sun Cluster (2-nodes) with Solaris 2.6
> > and Oracle 8.0.5. running in OPS configuration. We have a failover site
> > which also has a Sun Cluster running 8.0.5. The advice we are getting
> > is that we should run Async Replication at 6 minute intervals.
> >
> > We are an internet based business with most of our 'users' coming in
> > over the web.
> >
> > Questions
> >
> > 1. has anybody done anything like this before.
> > 2. are you aware of any limitations in terms of Oracle which imposes
> > the six minute intervals
> > 3. What conflict resolutions strategies do you use to get around the
> > possibility of users reentering a transaction after being kicked off
> > because they believe it failed as they are connected to the secondary
> > site which hasnt recieved the replicated data.
> > 4. Are there any other limitations in an OPS configuration to be
> > considered. For instance do I need to set my 'job' init.ora parameters
> > on the master node of the cluster only or one or both.
> >
> > Any advice, lessons learnt hints would be greatly apreciated
> >
> > regards
> >
> > Michael Walsh
> > mjwalsh_at_hotmail.com
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.

Received on Tue Sep 07 1999 - 12:34:24 CDT