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 02-17-2010, 11:46 AM
Mike Donovan Mike Donovan is offline
Dbvisit Team
 
Join Date: May 2008
Posts: 205
Default Configure Dbvisit to send only missing log files with resynchronize

Question:
Is there a way to configure Dbvisit such that during resynchronize (the -R option) it does not transfer all logs (from the last applied till the current one) but transfer only the ones that are missing?

Answer:
This is currently not possible, and no such configuration option currently exists within Dbvisit. However it is possible to manually control this process.

If you run dbvisit -R then it will send from the last sequence of the standby to the current sequence of the primary. For example, if the standby is at sequence 50 and the primary is at sequence 60 then dbvisit -R will send sequence:
50,51,52 -> 60.

So, say for instance that sequence 50 is missing on the standby, but 51 to 60 are there. You can run dbvisit -R to start sending sequence 50. Once sequence 50 has been transferred you can cancel Dbvisit with ctrl-c. Then you run Dbvisit again with the -r command to state which is the next sequence to run:
dbvisit -r 61

This will transfer sequence 61 and also updates the Dbvisit repository to say that 61 is the last sequence that was sent. So the next time Dbvisit runs, it will start from sequence 62.

Last edited by Mike Donovan; 02-17-2010 at 12:24 PM.
Reply With Quote
Reply

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 04:37 PM.