Session Details

All posts relating to Oracle database administration.

Moderator: Tim...

Session Details

Postby adda.road@yahoo.com » Mon Apr 30, 2012 6:38 pm

Hi Tim,

I had 3 databases D1,D2,D3.

My database D1 goes down ,how can get the datails of the session when it goes down?

What is the technical term of this situation?


please clarify my doubt.

thank you,
Rampa.
adda.road@yahoo.com
Senior Member
 
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

Re: Session Details

Postby Tim... » Mon Apr 30, 2012 7:21 pm

Hi.

Not sure what you mean. Is this a RAC database?

If so, then you are probably talking about Transparent Application Failover (TAF). Although it can make some sessions appear to seamlessly fail over, in many cases you will need to code some error management into your application.

There is nothing that will allow you to recovery the state of a sessions from the dead instance. Only commited data will be safe.

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: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Session Details

Postby adda.road@yahoo.com » Tue May 01, 2012 2:04 am

Hi tim,

Tahnks a lot for reply.

Its a Rac Database.

Rampa.
adda.road@yahoo.com
Senior Member
 
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

Re: Session Details

Postby Tim... » Tue May 01, 2012 8:25 am

Hi.

So check out FAN, mentioned previously. If you are willing to code session management into your app, then consider FCF (Fast Connection Failover).

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: 17933
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 6 guests