Does Oracle Data Guard support automatic switchover/failover?
Yes. Starting with Oracle Database 10g Release 2, Oracle Data Guard offers the Fast-Start Failover feature, through which it is possible to automatically, and quickly fail over to a previously chosen, synchronized standby database in the event of loss of the primary database, without requiring any manual steps to invoke the failover, and without incurring any data loss. Following a fast-start failover, once the old primary database is repaired, Data Guard automatically reinstates it to be a standby database. This act restores high availability to the Data Guard configuration. Refer to the Data Guard Technical white paper for further details on this feature.