DISABLE_FS_FAILOVER

The DISABLE_FS_FAILOVER function can be used to to disable fast-start failover. Using this function will prevent the observer from initiating a failover to the target standby.

DISABLE_FS_FAILOVER Function

DBMS_DG.DISABLE_FS_FAILOVER (
     force           IN BOOLEAN DEFAULT FALSE,
     severity        OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter Description

Parameter	Description
`force`	A boolean value to indicate whether fast-start failover should be disabled with the `FORCE` option. A value of `TRUE` will cause this function to disable fast-start failover on the member the session is connected. A value of `FALSE` will cause this function to disable fast-start failover on the primary and current target standby. If both databases cannot disable fast-start failover, it will remain enabled.
`severity`	The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers: `ORA-0`: normal, successful completion `ORA-16501`: The Oracle Data Guard broker operation failed. `ORA-16502`: The Oracle Data Guard broker operation succeeded with warnings.

force

A boolean value to indicate whether fast-start failover should be disabled with the FORCE option. A value of TRUE will cause this function to disable fast-start failover on the member the session is connected. A value of FALSE will cause this function to disable fast-start failover on the primary and current target standby. If both databases cannot disable fast-start failover, it will remain enabled.

severity

The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers:

ORA-0: normal, successful completion
ORA-16501: The Oracle Data Guard broker operation failed.
ORA-16502: The Oracle Data Guard broker operation succeeded with warnings.

Usage Notes

This function returns a binary integer.
If the primary and target standby database have a network connection, specify FALSE for the force parameter to disable fast-start failover on all databases in the broker configuration. If errors occur during the disable operation, the broker returns an error message and stops the disable operation. You may need to reissue the call with a value of TRUE for the force parameter to override the error conditions and disable fast-start failover on the database to which you are connected.
Use a value of TRUE for the force parameter when the network between the primary and target standby databases is disconnected or when the database upon which the function is called does not have a connection with the primary database. A value of TRUE for the force parameter disables fast-start failover on the database to which you are connected, even when errors occur.
Calling this function using a value of TRUE for the force parameter on a primary database that is disconnected from the observer and the target standby database does not prevent the observer from initiating a fast-start failover to the target standby database.
You can call this function with a value of FALSE for the force parameter while connected to any database in the broker configuration so long as connectivity exists between that database and the primary.
If this function is called with a value of TRUE for the force parameter at the target standby database and the connection subsequently resumes with the primary database, fast-start failover is disabled on all databases in the configuration.
Calling this function with a value of TRUE for the force parameter while connected to the primary will disable fast-start failover on the target standby database if there is network connectivity between both databases

Errors	Description
`ORA-00000: normal, successful completion`	Fast-start failover was disabled according to the value specified by the force parameter.
`Other`	The Data Guard broker was unable to disable fast-start failover.