home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle.server      Oracle Sysadmins question their careers      44,300 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 42,940 of 44,300   
   chris.brown@coveainsurance.co.uk to All   
   switching to standby in dataguard config   
   21 Dec 16 07:28:18   
   
   I have a primary and standby database ( oracle enterprise 12.1.0.1.0 0 on   
   windows 2012 r2   
      
   I want to know the easiest procedure to follow if and when   
      
   1) we lost the primary    
   2) we need to make the standby the primary   
      
   This is an active\passive config & we don't use any other products eg   
   databroker etc   
      
      
   regards   
   Chris B   
      
   PS My current doc is as follows but is old and hasn't been tested   
      
   1.            select switchover_status  from v$database   
        if <> ‘sessions active ‘ then   
      alter database commit to switchover to primary     
       else    
        alter database commit to switchover to primary  with session shutdown;   
      
   2.  shutdown immediate;   
         Startup;   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca