Search the Reference Library pages:  

Oracle DBMS_DG

Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsdg.sql
First Available 11.1
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
Object Privileges execute on dbms_alert granted to execute_catalog_role
 
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
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----