I think transparent App failover is used in OPS where 2 or more DB with 1 or more CPUs are running off shared storage. If one server fails, the other one still runs and this config. won't cause any disruption.