1 Reply Latest reply: Apr 12, 2013 10:53 AM by teits RSS

    10g Primary Performace - extra physical standbys

    574843
      Hi
      I have a 10g 3 node RAC primary db to a 3 node RAC standby (physical) db. (in SYNC mode delay = 0)
      The SLA for the app is extremely tight.

      I need to add 2 more standby databases (physical) in ASYNC mode.

      Does anyone have any performance metrics on primary db performance when adding extra standby databases.

      There is an oracle node about cascading standby db's in RAC environment (which suggests you shouldn't due to different redo streams).

      Where will the bottleneck be ..... if any...
        • 1. Re: 10g Primary Performace - extra physical standbys
          teits
          hello,

          I need to add 2 more standby databases (physical) in ASYNC mode.

          Does anyone have any performance metrics on primary db performance when adding extra standby databases.
          its depends on several things
          1. on the workload vs the cpu, memory,storage performance
          2. the size of your database
          3. network performance
          4. if you have recent backup, will reduce the time and impact on primary db
          There is an oracle node about cascading standby db's in RAC environment (which suggests you shouldn't due to different redo streams).

          Where will the bottleneck be ..... if any...
          if you are using cascading standby db, then the workload of redo transport will be off the primary.
          BUT "Cascaded Redo Transport Destinations... Releases prior to 11.2.0.2 have several limitations for this feature that are not present in release 11.2.0.2."


          Tobi
          HTH