This content has been marked as final. Show 7 replies
I don't see where that's documented :
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]
Tom wrote:Yes, MRP will be active any one node of the cluster and other nodes will be sitting as "IDLE".
Version :188.8.131.52 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 ?
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
primary : 3-node RAC and all 3 nodes can ship the archivelogs to standby site
Version :184.108.40.206 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 ?
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)
From what I have read since you posted the question, that would be correct.
This may be of interest :
Edited by: mseberg on Nov 13, 2012 10:08 AM
yes, it will run form node3.
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 ?