CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
HOME | BROWSE | GROUPS | REFERENCE | ADD CODE | LINKS | SPONSORS
It's time to sign up for your 2010 PSOUG membership!
Click here to join PSOUG now!
Search the Reference Library pages:  
Help us help you! Take our 1-minute PSOUG survey. Free Oracle Magazines & 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
 
Contact Us Legal Notices and Terms of UsePrivacy Statement
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [52 visitors online]    © 2009 psoug.org