Oracle DBMS_DG
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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