Oracle | DBMS

Oracle DBMS_DG Version 21c

General Information

Library Note

Morgan's Library Page Header

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: 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('FSFO Disabled: Expected Status ORA-16646');

        dbms_output.put_line('Actual Status = ORA-' || status);

      END;

      /