This discussion is archived
1 Reply Latest reply: Nov 8, 2012 12:15 AM by vivalavida RSS

RAC and standby database configuration

vivalavida Journeyer
Currently Being Moderated
Hi ,
one of our RAC's (production database) has to be moved to another Datacenter the next year. The size of the RAC database is about 3 TB, Oracle release 11gR2.
Now we have the idea the create a standby database in the new Datacenter. This standby database can be converted into a snapshot standby database to give the developers the ability to test their applications. And if this tests succeed the current RAC database can be shut down and new RAC database will be used as the production environment - means that the standby database should turn into a RAC database. This is technically possible - at least in my understanding.

But my question in this thread points into a different direction:
- since the standby database should replace the current RAC database the standby database must get setup on a 2 node environment. In our current environment
we have several standby databases running - but those are always single instances on a single host.

My question is:
Is it possible to setup a standby database on a RAC environment with 2 nodes? I've searched through MOS but didn't find any information about that...

Any help will be appreciated

Rgds
JH
  • 1. Re: RAC and standby database configuration
    Shivananda Rao Guru
    Currently Being Moderated
    My question is:
    Is it possible to setup a standby database on a RAC environment with 2 nodes? I've searched through MOS but didn't find any information about that...
    Yes, it is possible. Refer this
    *Data Guard Physical Standby 11.2 RAC Primary to RAC Standby using a second network [ID 1349977.1]*

    MAA / Data Guard 10g Setup Guide – Creating a RAC Physical Standby for a RAC Primary
    http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimaryracphysicalsta-131940.pdf

    http://wiki.tapriuneclak.com/index.php?title=Oracle_-StepBy_Step_of_Configuring_Oracle_11gR2_(11.2.0.1)_RAC_to_RAC_Dataguard

    http://davidalejomarcos.wordpress.com/2010/02/17/creating-a-3-node-rac-database-as-standby/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points