XPost: comp.databases.oracle.server   
   From: forbrich@yahoo.net   
      
   ~K wrote:   
      
   > I have 3 Oracle servers that I would like to keep in sync. Only one is   
   > used as my production, the other is a backup and the third is used for   
   > development purposes. In case my primary Oracle server goes down, I   
   > would like to immediately use the secondary server. My question is,   
   > what is the best way to keep all the servers up to date such that if   
   > tables are updated on my primary server they immediately are updated   
   > in the subsequent servers.   
   >   
   > Thanks,   
   > ~K   
      
   Oracle Streams   
   Oracle DataGuard - Physical   
   Oracle DataGuard - Logical (iffy until 10g)   
      
   I hate to direct you to the docs for 'how' without a chance to understand   
   the 'why' for the above.  (Basically Data Guard does auto/manual   
   fail/switch over and switch back.  Streams is the 'high speed' replacement   
   for replication.)   
      
   Unfortunately, with last week's improvements to OTN, attempts to find the   
   Oracle9i DataGuard white papers gives me an HTML-500 error.   
      
   Perhaps you can look through the 10g white papers and then adjust   
   expectations back to the 9i version.  (see High Availability > Disaster   
   Recovery at http://otn.oracle.com > database section.)   
      
   /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)