dbTalk Databases Forums  

typical TAF failover times?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss typical TAF failover times? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mh@pixar.com
 
Posts: n/a

Default typical TAF failover times? - 02-06-2008 , 10:25 PM






First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?

Second, what are some typical TAF failover times? I'm in a
gig-e LAN environment, so there won't be any serious network
timing fluctuations.

For our application it would be preferrable to fail over
as quickly as possible, since we are servicing nodes in
a pretty large compute farm.

Would retries=3,delay=5 be reasonable? Then work
should pick up in 15 seconds or so after a node fails.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

Reply With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 11:32 AM






mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?
Depends on the version.

Quote:
Second, what are some typical TAF failover times? I'm in a
gig-e LAN environment, so there won't be any serious network
timing fluctuations.
Depends on the operating system.

Quote:
For our application it would be preferrable to fail over
as quickly as possible, since we are servicing nodes in
a pretty large compute farm.
Can you think of anyone that desires a slow failover?

Quote:
Would retries=3,delay=5 be reasonable? Then work
should pick up in 15 seconds or so after a node fails.

Many TIA!
Mark
Typical is delay 5 and retries 180 but that does not mean
either is suitable for your environment.

Provide additional information and perhaps we can get you
better answers. Also, why TAF rather than FCF?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #3  
Old   
DA Morgan
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 11:32 AM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?
Depends on the version.

Quote:
Second, what are some typical TAF failover times? I'm in a
gig-e LAN environment, so there won't be any serious network
timing fluctuations.
Depends on the operating system.

Quote:
For our application it would be preferrable to fail over
as quickly as possible, since we are servicing nodes in
a pretty large compute farm.
Can you think of anyone that desires a slow failover?

Quote:
Would retries=3,delay=5 be reasonable? Then work
should pick up in 15 seconds or so after a node fails.

Many TIA!
Mark
Typical is delay 5 and retries 180 but that does not mean
either is suitable for your environment.

Provide additional information and perhaps we can get you
better answers. Also, why TAF rather than FCF?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #4  
Old   
DA Morgan
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 11:32 AM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?
Depends on the version.

Quote:
Second, what are some typical TAF failover times? I'm in a
gig-e LAN environment, so there won't be any serious network
timing fluctuations.
Depends on the operating system.

Quote:
For our application it would be preferrable to fail over
as quickly as possible, since we are servicing nodes in
a pretty large compute farm.
Can you think of anyone that desires a slow failover?

Quote:
Would retries=3,delay=5 be reasonable? Then work
should pick up in 15 seconds or so after a node fails.

Many TIA!
Mark
Typical is delay 5 and retries 180 but that does not mean
either is suitable for your environment.

Provide additional information and perhaps we can get you
better answers. Also, why TAF rather than FCF?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #5  
Old   
DA Morgan
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 11:32 AM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?
Depends on the version.

Quote:
Second, what are some typical TAF failover times? I'm in a
gig-e LAN environment, so there won't be any serious network
timing fluctuations.
Depends on the operating system.

Quote:
For our application it would be preferrable to fail over
as quickly as possible, since we are servicing nodes in
a pretty large compute farm.
Can you think of anyone that desires a slow failover?

Quote:
Would retries=3,delay=5 be reasonable? Then work
should pick up in 15 seconds or so after a node fails.

Many TIA!
Mark
Typical is delay 5 and retries 180 but that does not mean
either is suitable for your environment.

Provide additional information and perhaps we can get you
better answers. Also, why TAF rather than FCF?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
  #6  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 01:19 PM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?

If you mean that's all on the server side, you may be correct,
but I always thought TAF needed an application that was
written to support it.

In that context, the answer should be 'No'
(if I'm (still?) correct).

Comments on the application needing TAF support?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #7  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 01:19 PM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?

If you mean that's all on the server side, you may be correct,
but I always thought TAF needed an application that was
written to support it.

In that context, the answer should be 'No'
(if I'm (still?) correct).

Comments on the application needing TAF support?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #8  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 01:19 PM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?

If you mean that's all on the server side, you may be correct,
but I always thought TAF needed an application that was
written to support it.

In that context, the answer should be 'No'
(if I'm (still?) correct).

Comments on the application needing TAF support?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #9  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 01:19 PM



mh (AT) pixar (DOT) com wrote:
Quote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?

If you mean that's all on the server side, you may be correct,
but I always thought TAF needed an application that was
written to support it.

In that context, the answer should be 'No'
(if I'm (still?) correct).

Comments on the application needing TAF support?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up


Reply With Quote
  #10  
Old   
DA Morgan
 
Posts: n/a

Default Re: typical TAF failover times? - 02-07-2008 , 05:14 PM



Frank van Bortel wrote:
Quote:
mh (AT) pixar (DOT) com wrote:
First, just to make sure I understand: All TAF configuration is
in the tnsnames.ora entry, and doesn't need any setup on the
RAC servers. Is that correct?


If you mean that's all on the server side, you may be correct,
but I always thought TAF needed an application that was
written to support it.

In that context, the answer should be 'No'
(if I'm (still?) correct).

Comments on the application needing TAF support?
It doesn't need one but it sure does benefit from one.

The app needs to know what to do if a failure occurs.

If a statement fails over, but the app is clueless, guess
what happens. <g>
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.