Help - Search - Members - Calendar
Full Version: Replicate data in multi servers
Oracle DBA Forums > Oracle > Oracle Forum
mrkamran
Dear all,
I m new in Oracle Database Administration and i have a question. My scenerio is that there are 3 diffrent offices locations where is running same oracle application and 1 place is working as database server running Oralce 9i. Now problem is that when db server side is down then other two location stop working becuse of db server unavailable. Kindly tell me a simple solution that the other 2 locations work properly even db server is off.
I have idea that if i install oracle 9i on other two client location and when db server will down, these location store their data locally and when db server will up data should update on main db server. How can i obtain my goal? Thanks in advance
dave
look up dataguard
burleson
>> Now problem is that when db server side is down then other two location stop working becuse of db server unavailable.

You have several choices (Data Guard, RAC, or Streams), depending on yout tolerance for unplanned downtime.

http://www.dba-oracle.com/t_oracledataguar...n_failover_.htm

I highly recommend that you get the book "Oracle Replication" for the details:

http://www.rampant-books.com/book_2003_2_replication.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.