Logical Standby from RAC to single instance
From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Mon, 20 Apr 2009 22:45:04 -0400
Message-ID: <1c8f76b90904201945l117aa6afgfb3a96d0448f0f68_at_mail.gmail.com>
hello everyone,
Date: Mon, 20 Apr 2009 22:45:04 -0400
Message-ID: <1c8f76b90904201945l117aa6afgfb3a96d0448f0f68_at_mail.gmail.com>
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.
- Is absolutely needed that every table in the database to have either a PK or UK?
- 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 20 2009 - 21:45:04 CDT