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.
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.