This discussion is archived
7 Replies Latest reply: Nov 16, 2012 8:27 AM by Don Seiler RSS

Physical standby DB in RAC

Tom Newbie
Currently Being Moderated
Version :11.2.0.3 on Solaris 10

We are planning to create a 3-node RAC physical standby for our 3-node RAC Primary DB. I was told that the mrp process (Managed recovery process) at the standby site should be configured to run only on one of 3 instances in the standby side. Is this true ?
  • 1. Re: Physical standby DB in RAC
    mseberg Guru
    Currently Being Moderated
    Hello;

    I don't see where that's documented :

    http://www.oracle.com/technetwork/database/features/availability/dataguard11g-rac-maa-1-134639.pdf

    http://oracle.su/docs/11g/server.112/e10700/title.htm

    RAC: Frequently Asked Questions [ID 220970.1]

    But it makes sense since I don't see how you would do it any other way without conflicts.

    Going with Yes - Seems like they refer to it as "redo apply instance"

    Active Data Guard RAC Standby - Apply Instance Node Failure Impact [ID 1357597.1]

    Best Regards

    mseberg
  • 2. Re: Physical standby DB in RAC
    CKPT Guru
    Currently Being Moderated
    Tom wrote:
    Version :11.2.0.3 on Solaris 10

    We are planning to create a 3-node RAC physical standby for our 3-node RAC Primary DB. I was told that the mrp process (Managed recovery process) at the standby site should be configured to run only on one of 3 instances in the standby side. Is this true ?
    Yes, MRP will be active any one node of the cluster and other nodes will be sitting as "IDLE".
    you can refer MAA article for RAC primary and RAC standby http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimaryracphysicalsta-131940.pdf
    http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-rac-standby-133152.pdf
  • 3. Re: Physical standby DB in RAC
    rcc50886 Journeyer
    Currently Being Moderated
    Version :11.2.0.3 on Solaris 10
    
    We are planning to create a 3-node RAC physical standby for our 3-node RAC Primary DB. I was told that the mrp process (Managed recovery process) at the standby site should be configured to run only on one of 3 instances in the standby side. Is this true ?
    primary : 3-node RAC and all 3 nodes can ship the archivelogs to standby site

    Standby: 3-node RAC and only one of the instance will apply the recevied logs (i.e MRP runs on only one node at any point of time)

    -Thanks
  • 4. Re: Physical standby DB in RAC
    Tom Newbie
    Currently Being Moderated
    So, this means, during the last stage of Standby setup , whichever Instance I connect and issue
    alter database recover managed standby database disconnect from session;
    If I issued the above command from Instance 3 , the mrp process will be running only on Node3. Right ?
  • 5. Re: Physical standby DB in RAC
    mseberg Guru
    Currently Being Moderated
    Hello;

    From what I have read since you posted the question, that would be correct.

    This may be of interest :



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

    http://davidalejomarcos.wordpress.com/2010/03/15/creating-a-3-node-standby-database-part-ii/

    http://davidalejomarcos.wordpress.com/?s=3-node+standby&searchbutton=go!



    Best Regards

    mseberg

    Edited by: mseberg on Nov 13, 2012 10:08 AM
  • 6. Re: Physical standby DB in RAC
    rcc50886 Journeyer
    Currently Being Moderated
    So, this means, during the last stage of Standby setup , whichever Instance I connect and issue 
    
    alter database recover managed standby database disconnect from session;
    
    
    If I issued the above command from Instance 3 , the mrp process will be running only on Node3. Right ?
    yes, it will run form node3.

    -Thanks
  • 7. Re: Physical standby DB in RAC
    Don Seiler Newbie
    Currently Being Moderated
    Yes MRP only runs on one instance of a RAC standby. Obviously that node needs to have access to the archivedlogs for all of the primary threads. Usually best to keep archivedlogs (and FRA in general) in ASM.

Legend

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