Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Synchronize Data

    Hi,

    I would like to synchronize 2 databases. Source Database is in US and the Target Database is in India.

    can you please tell me the tools, mechanisms, logic that will be used to make sure that the data between both the databases in always in sync.

    Please let me know if you need more Information.

    thanks
    Shankar

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    You do not give DB version numbers so it is hard to tell you what to use. The cheapest (I think it is standard with Oracle) is to use the "Data Guard" method. Check out the doc http://download-west.oracle.com/docs...a96653/toc.htm. This is for 9i but I believe Oracle had similar methods previously. I think they had a different name then however.
    NOTE: Please disregard the label "Senior Member".

  3. #3
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    Shankar;
    You are missing a lot of data other than the database version. Your method will probably depend more on the bandwidth between the two locations than anything else. This will also determine what you can and can not do at the standby site. Are you merely trying to bring up a single database, or are you trying to synchronize an entire SAN.

    Give us a little more information - Please...

    HTH
    Peter

  4. #4
    Join Date
    Aug 2004
    Posts
    18
    Quote Originally Posted by shankar
    Hi,

    I would like to synchronize 2 databases. Source Database is in US and the Target Database is in India.

    can you please tell me the tools, mechanisms, logic that will be used to make sure that the data between both the databases in always in sync.

    Please let me know if you need more Information.

    thanks
    Shankar
    Missing details:

    1) How often you want to synchronize? Should it be real-time, or batch process is fine?
    2) What database version you have on both sites and what OS/hardware

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •