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