Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-17-2012, 01:21 PM
Mike Donovan Mike Donovan is offline
Dbvisit Team
 
Join Date: May 2008
Posts: 207
Default How does Dbvisit Standby handle network connection timeouts?

Question:
If a network crashes (times out) while the Primary Database server is shipping archivelog files to the Standby Database server what will happen? Do I have to set a timeout in the DDC file? Or is this done in the ssh configuration?

Response:
If, for any reason, there is any network interruption Dbvisit Standby will attempt to re-transfer the logs on its next run automatically, without any intervention on the part of the DBA. Thresholds can be set so that you can specify how many time Dbvisit should re-transfer a log before notifications should be sent.

The key parameter to set in your DDC file is TRANSFER_RETRIES, which we explain in the following:

Determines the number of retries when the checksum of the transferred log file does not match the original file. When the checksum does not match, the file will be transferred again. If the checksum does not match after TRANSFER_RETRIES attempts, an alert will be raised.
Default value: 2
Example:
TRANSFER_RETRIES=2


Furthermore, network timeouts are actually set by the SSH configuration. So Dbvisit Standby relies on the SSH configuration to get the timeout signal back when the transfer was not completed successful. As soon as this is received, then Dbvisit Standby will attempt the transfer again. The important settings as far as Dbvisit Standby is concerned are:
TRANSFER_RETRIES wich was highlighted above.

RETRIES_WAIT_IN_SEC - Wait in seconds before a retry attempt of TRANSFER_RETRIES. By default this is 5 seconds.
Reply With Quote
Reply

Tags
network, retries_wait_in_sec, timeout, transfer_retries

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

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

Forum Jump


All times are GMT +12. The time now is 08:26 PM.