This content has been marked as final. Show 8 replies
If you need failover between data centres, you should probably be looking at Data Guard rather than any form of RAC.
we will configure about over 10 instances on the RAC One Node - the box will have plenty of memory and enough CPU's. Therefore a RAC One Node will make more sense - at least from our point of view - as several standby databases. But this is not the point of this thread - let's take it as I described: failover will be done with RAC One Node.
It would be great to get some answers to the questions I have asked.
Many thanks & Rgds
My questions now are:Yes, automatically and transparent
- will that really automatically be done?
- what happens to the sessions which were connected to the database before the HW-failure?Depend if you are using Omotion the connection will be redirected to another node, if you are cold failover the client will be have a short downtime.
- is it possible to determine how long this failover will take?Depend of failure, but normal (could failover) is on range from 1 to 3 minutes, using (omotion- hot failover) no downtime.
Read it :
Maybe this can clarify your issues.
Any question just ask.
Edited by: Levi Pereira on Dec 5, 2012 11:58 AM
PS: Ignore use of Omotion if you have "downtime after HW-outage". Consider only cold failover.
Hi Levi ,
many thanks for your answers and the link - that certainly helps!
Hello again. Are you under the impression that RAC One Node will move the database will move from one machine to another? It won't. The database will remain exactly where it is. All RAC One Node can do do is relocate the instance from one machine to another. Given that you mention two data centres, I doubt that this is what you need - unless you have a stretched cluster that clovers both data centres, and shared sdtorage visible on both sites.
Oracle Clusterware will automatically detect the failure and restart the Oracle RAC One Node database on another server in the pool.From info previously posted I considered he are using "Oracle Clusterware in Extended / Stretched Clusters".If not... there is no way to implement any RAC architecture.
In our case we would have the active node in Datacenter 1, the passive node in Datacenter 2.
Yes, we have shared storage - and the cluster itself will cover both nodes (DC1 and DC2).
Ok ..It all depends on the bandwidth between the DC1 and DC2
I have Rac one 1 Db on a 2 node active passive setup. I have seen instance swinging from node 1 to node 2 if the Node 1 fails. IF you want to swing the instance from DC1 to DC2 it will provide the Node 2 can reach the storage...I have seen the outage or session may hang for a minute or 2..Most of the timess sessions will be moved but it may break also......It protect says 95% orf session....