Oracle DBMS_DG
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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.0.6
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;
/

Related Topics
Data Guard
DBMS_DRS
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved