Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Allows applications to notify the primary database or the fast-start failover target database in an Oracle Data Guard broker environment to initiate a fast-start failover when the application encounters a condition that warrants a failover.
AUTHID
CURRENT_USER
Dependencies
DBMS_DRS
GV$DATAGUARD_STATS
GV$FS_FAILOVER_HISTOGRAM
GV$DATAGUARD_CONFIG
GV$DATAGUARD_STATUS
GV$FS_FAILOVER_STATS
Documented
Yes
Exceptions
Error Code
Reason
ORA-16646
Fast-Start Failover is disabled
ORA-16666
Unable to initiate Fast-Start Failover on a standby database
ORA-16817
Unsynchronized Fast-Start Failover configuration
ORA-16819
Fast-Start Failover observer not started
ORA-16820
Fast-Start Failover observer is no longer observing this database
ORA-16829
Lagging Fast-Start Failover configuration
First Available
11.1
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmsdg.sql
INITIATE_FS_FAILOVER
Specify a condition string that, when encountered by an application, allows the application to request the primary database to immediately invoke a fast-start failover
dbms_dg.initiative_fs_failover(condstr IN VARCHAR2)
RETURN BINARY_INTEGER;
set serveroutput on
DECLARE
status INTEGER;
BEGIN
status := dbms_dg.initiate_fs_failover('Failover Requested');
dbms_output.put_line('FSFO Disabled: Expected Status ORA-16646');
dbms_output.put_line('Actual Status = ORA-' || status);
END;
/
