Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit General > Dbvisit pre-sales

Thread Tools Search this Thread Display Modes
Old 12-19-2011, 09:06 AM
Mike Donovan Mike Donovan is offline
Dbvisit Team
Join Date: May 2008
Posts: 207
Default Dbvisit Replicate (logical replication) as a DR option

Dbvisit Replicate can be used to provide DR cover by creating an active-active/Oracle to Oracle replication partnership. However, it is important to be aware that there are consequences of this approach:

  • More overhead in terms of processing power/memory needed. Applying archives is a lot more efficient than applying SQL
  • More manual intervention required in terms of conflict resolution between the source and target destinations
  • Not a binary copy, so if a password is changed in the source database it is not updated in the target, then when it comes to failover the system will not work because of an old passsword etc

But on the positive side of the ledger:
  • No dataloss when it comes to failover time.
  • No rebuilds required after failover
  • Can switch back and forward between source and target as much as you like
  • Can actually use the target/DR database as a read/write reporting server at any time - it is an open Oracle instance in its own right

So, in terms of recovering after an outage/disaster event, Dbvisit Replicate will be able to synchronise the replication partnership again provided that:
  1. You have all the archivelogs
  2. The speed of mining/applying is faster than new transactions coming in. Otherwise it will never catchup
Reply With Quote

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 09:15 PM.