Oracle 9i: Keep multiple servers in sync

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ~K
    #1

    Oracle 9i: Keep multiple servers in sync

    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
    Tags: None
    • Ana C. Dent
      #2
      Re: Oracle 9i: Keep multiple servers in sync

      krandryc@hotmai l.com (~K) wrote in
      news:2d760bc3.0 408081658.2c864 168@posting.goo gle.com:
      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
      >
      Either RAC to Standby database

        Comment

        • Hans Forbrich
          #3
          Re: Oracle 9i: Keep multiple servers in sync

          ~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

            Comment

            Previous template Next
            Working...