Oracle | DBMS

Oracle DBMS_DG Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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: Packages and Types Reference

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('Actual Status = ORA-' || status);

        IF status = 16646 THEN

          dbms_output.put_line('FSFO Disabled);

        END IF;

      END;

      /