> What exactly does the fail over do?

Hello,

in case the main database server is not reachable, the connection switches to the second databbase server (failover partner).
The databases on both machines are synchronized. The second machine is a hot standby, so it is not really used, when the main server is up and running.

Regards
Thomas