CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [257 users online]    © 2010 psoug.org