Oracle DBMS_DG Demos

Oracle DBMS_DG Version 11.2.0.3

General Information

AUTHID

CURRENT_USER

Dependencies

DBMS_DRS

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;
/