Dataguard Role Transition

All posts relating to Oracle database administration.

Moderator: Tim...

Dataguard Role Transition

Postby sivakumarocp » Tue Nov 27, 2012 9:57 pm

Hi Tim,

during the role transition (from primary to physical standby) if we issue below command what will happen to the sessions already connected on the primary database.

Code: Select all
alter database commit to switchover to primary with session shutdown


I would like to know if we change the database role from primary to standby does all existing connections on primary will get reconnected or failed over to physical standby?
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: Dataguard Role Transition

Postby Tim... » Wed Nov 28, 2012 9:01 am

Hi.

As far as I know there is no automatic transition.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Dataguard Role Transition

Postby lyzahundley » Mon Dec 10, 2012 2:16 am

Hope there will be in the future.


______________________
How To Find Out Everything There Is To Know About 2 types of life insurance and cheapest term life insurance In 5 Simple Steps
Last edited by lyzahundley on Thu Dec 13, 2012 2:33 am, edited 1 time in total.
lyzahundley
Member
 
Posts: 1
Joined: Mon Dec 10, 2012 1:06 am

Re: Dataguard Role Transition

Postby Tim... » Mon Dec 10, 2012 8:30 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17952
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests