Re: Logical Standby from RAC to single instance

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 21 Apr 2009 08:03:08 +0100
Message-ID: <7765c8970904210003u7c692fa2gfe250fdc9b8f24e7_at_mail.gmail.com>

Hi the requirement is that oracle can uniquely identify every row, so pretty much you need a pk or unique constraint. It *may* be that a unique index would do, but i don't believe that is permitted. There should be an maa paper on single instance physical standby for a rac primary which should be your starting point for the build process - since you convert a physical to a logical to build the logical.

On 4/21/09, dd yakkali <dd.yakkali_at_gmail.com> wrote:
> hello everyone,
>
> I had setup Physical Standby on Oracle 10g earlier but never on a RAC
> environment and not a logical standby
>
> Here is what I have
> 2 node 10gR2 RAC on solaris 10 using 11g CRS & 11g ASM
>
> I want to setup a single instance logical standby for the above RAC
> database.
>
> Here are my questions regarding logical standby.
>
> 1) Is absolutely needed that every table in the database to have either a PK
> or UK?
> 2) when I use the RMAN to duplicate the target database for standby, in the
> init.ora of the standby do I have to say cluster_database=false
> and once I open the database do I drop second thread and second undo
> tablespace?
>
> I googled for pointers but could not get a lot of help. There is a MAA paper
> about standby RAC for a Primary RAC.
>
> Can any one point to a step by step process.
>
> Any help is appreciated.
>
> thanks
> deen
>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 21 2009 - 02:03:08 CDT