What Causes Fast Start Failover?

Onur ARDAHANLI

2 years ago

In today’s article What Causes Fast Start Failover? We will look for an answer.

We can see what causes this in the figure below.

In order to see this, automatic reinstate must be disabled because this information will be lost as it will rewind the database with Flashback.

[Primary-1] SQL> column LAST_FAILOVER_REASON format a40
[Primary-1] SQL> SELECT last_failover_time, last_failover_reason FROM v$fs_failover_stats;

LAST_FAILOVER_TIME   LAST_FAILOVER_REASON
-------------------- ----------------------------------------

[Primary-1] SQL> column LAST_FAILOVER_REASON format a40

[Primary-1] SQL> SELECT last_failover_time, last_failover_reason FROM v$fs_failover_stats;

LAST_FAILOVER_TIME LAST_FAILOVER_REASON

-------------------- ----------------------------------------