Oracle DBMS_DG
Version 11.2.0.3
 
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
Security Model Public synonym exists but no privileges granted by SYS
 
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
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan All Rights Reserved