Re: Advanced Replication combined with Oracle Parallel Server

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 Sun Sep 05 1999 - 04:20:31 CDT