Home » Server Options » Data Guard » Oracle CDC
Oracle CDC [message #211419] Thu, 28 December 2006 09:43 Go to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
Someone in another thread suggested using Oracle's Change Data Capture as a solution to the following problem - we have 2 databases. One can potentially be down sometimes. So we replicated all 14 tables from that db - that our application uses so that if one db is down, the data from the other db is used. The problem - our users would like to refresh the data from db 2 with data from db 1 (that potentially be down) ON DEMAND. Is it possible to refresh the data on demand using Oracle's Change Data Capture? Any info would be apprciated.
Re: Oracle CDC [message #211429 is a reply to message #211419] Thu, 28 December 2006 10:48 Go to previous message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
also, I forgot to ask - as our app gets the data from db 2 (which in turn is refreshed with data from db 1 upon the users request - i.e. on demand), what is the best way to ensure that the performance of our application is not affected as the data gets refreshed? Our app would be just querying the data, no inserts, updates or deletes, but is there a potential performace hit when say the user is refreshing our tables in db 1 (which the app is querying) with data from db 2? thank you!
Previous Topic: standby redo logs
Next Topic: problems in failover of physical standby in MaxAvailAbility Mode
Goto Forum:
  


Current Time: Thu Mar 28 08:14:38 CDT 2024