Re: RAC- Replication

From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Wed, 18 Apr 2012 17:46:42 +0300
Message-ID: <CAKnHwteYz27OShSObOicUdAwC8MKNgBtzDNc+YGGo+ppj0xRWQ_at_mail.gmail.com>

Online redo logs for RAC instances should be placed on shared storage, so each instance has access to all redo logs.

From documentation:
http://docs.oracle.com/cd/B19306_01/server.102/b14229/ha_streams.htm#i1006387

"Using RAC with Streams introduces some important considerations. When running in a RAC cluster, a capture process runs on the instance that owns the queue that is receiving the captured logical change records (LCRs)."

Ilmar

On Wed, Apr 18, 2012 at 5:21 PM, Paul Harrison <cure_at_austin.rr.com> wrote:
> I thought streams input is the redo logs and every instance has its own redo
> logs.
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Hemant K Chitale
> Sent: Tuesday, April 17, 2012 7:28 PM
> To: cure_at_austin.rr.com
> Cc: ORACLE-L
> Subject: Re: RAC- Replication
>
> Data replicatiin (whether Basic or Advanced Replication or Streams or Golden
> Gate) is not tied to the instance of a RAC database that it is replicating
> from. (Golden Gate would have to read from all the redo threads of the
> database).
> It is from database to database not from instance to instance. Both "data
> nodes" access the same database.
> Hemant K Chitale
>

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

Received on Wed Apr 18 2012 - 09:46:42 CDT