Oracle DBMS_DG
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
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

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-2014 Daniel A. Morgan All Rights Reserved