iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

November 18, 2017, 12:26:37 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: Standby to Priamry by Force ...  (Read 20850 times)
AllanDBA
AllanDBA
Newbie
Newbie
*
Posts: 0


« on: January 17, 2016, 11:55:00 AM »

Converting Standby to Primary by force:

SQL> select database_role from v$database;     
SQL> alter database recover managed standby database cancel;
SQL> alter database recover managed standby database finish;
SQL> alter database commit to switchover to primary with session shutdown;
SQL> alter database open;
SQL> select database_role from v$database;     

Good Luck!
--admin
Logged
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!